You did restart your Postgresql after you changed pg_hba.conf...?
Taryn East wrote:
Hi all, I'm having some issues getting SQL-ledger to work and I'd be very grateful for any suggestions on where to look next. Basically, I'm running Ubuntu Hoary. I apt-get installed sql-ledger (btw, postgres didn't automatically get pulled in when I did that - should it have?) and set up the database users etc and have logged into the administration page. I am up to the step that tells me I should do a "create dataset", but whatever I do (whether I put details in or not) it gives me the following error: Error! 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. :( I googled further to find a suggestion to someone else, mentioning that they had had two copies around and it was seeing the wrong one... using find I see that I have both: /etc/postgresql/pg_hba.conf /var/lib/postgres/data/pg_hba.conf so that looks like a distinct possibility... I was hoping somebody would be able to help me to find out which one is the "right" one and what I do with it when I do... otherwise if anybody has any other good suggestions they would also be welcome. Thanks heaps, Taryn
-- Howard. LANNet Computing Associates - Your Linux people <http://lannet.com.au> -- When you just want a system that works, you choose Linux; When you want a system that just works, you choose Microsoft. -- Flatter government, not fatter government; Get rid of the Australian states. -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
