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]/

Reply via email to