Re: upgraded postgresql - bother! can't find the thread
Richard Lyons <[email protected]>
| Newsgroups | gmane.comp.web.sql-ledger.user |
|---|---|
| Organization | the-place |
| Message-ID | <[email protected]> |
On Wednesday 04 September 2002 20:34, Richard Lyons wrote: [snip] > The files are all neatly restored, and all I have to do now is remember how > to sort the permissions and ownership to avoid > Error! > FATAL 1: IDENT authentication failed for user "postgres" Well, that took me many hours, not being a postgresql expert. I finally read http://www.postgresql.org/idocs/index.php?client-authentication.html and realised that I needed to do something with the pg_hba.conf. In the end I have uncommented local all trust and suddenly I can log onto sql-ledger again. I suppose I would have to do something more secure if the system were open to other users, but this will do for now. -- richard ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/