Thanks John, spot on in pg_hba.conf local all ident sameuser changed to local all trust (just for testing)
good description in the PostgreSQL Administrators Guide Cheers, Colin On Tue, 2002-10-01 at 11:28, John Summerfield wrote: > On Mon, 30 Sep 2002 20:54, Colin Tree wrote: > > Hi, > > I'm new to sql-ledger and am having a bit of a problem > > setting up my database. When I do a create Dataset I get this > > > > > > Error! > > FATAL 1: IDENT authentication failed for user "sql-colin" > > > > > > > > > > My setup is Debian 3.0r0, > > I've followed the faq to the letter ??? > > my eyes are nearly burnt out, > > more coffee you say! > > > postgresql? > > Check your configuration. I don't know what the defaults are on Debian, but it > seems they don't suit you. > > Read the (copious) documentation, check pg_hba.conf > > -- > Cheers > John Summerfield > > > Microsoft's most solid OS: http://www.geocities.com/rcwoolley/ > Join the "Linux Support by Small Businesses" list at > http://mail.computerdatasafe.com.au/mailman/listinfo/lssb > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > ------------------------------------------------------- > (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive: http://www.mail-archive.com/[email protected]/ > ------------------------------------------------------- This sf.net email is sponsored by: DEDICATED SERVERS only $89! Linux or FreeBSD, FREE setup, FAST network. Get your own server today at http://www.ServePath.com/indexfm.htm ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/

