Taryn East <[EMAIL PROTECTED]> writes:
> FATAL: IDENT authentication failed for user "sql-ledger" > > > Now I've googled for answers and the FAQs all do mention this error - > they tell me to edit pg_hba.conf and add "local all all trust" > > which I tried... to no avail. :( That's for unix socket connections, it's probably connecting via tcpip. You want something like host sql-ledger sql-ledger 127.0.0.1 255.255.255.255 md5 The first sql-ledger is the database name, if the database is called something different you'll have to fix that up, or replace it with "all". The md5 line means the passwords will have to be set up correctly, you can replace with "trust" to disable passwords. The order of lines in pg_hba.conf is important. Probably put it underneath the first line that has 127.0.0.1 in it. then "sudo /etc/init.d/postgresql reload" Oh, and the reason postgres wasn't pulled in when you installed sql-ledger is because you can set it up to use a database on another box. So you don't have to install postgres on the same box as sql-ledger. -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
