On 04/29/2012 07:07 AM, Bill House wrote: > > On 04/29/2012 08:43 AM, Adrian Klaver wrote: >> On 04/29/2012 06:39 AM, Bill House wrote: >>> Hello all, >>> >>> I am not having much success with connecting to my postgresql server. >>> >>> D >>> >>> Will someone tell me what I have done wrong? >> >> >> What is the error message? >> What does the Postgres log show? >> > ###################### > Connection Test: Failed (from CxnEditor > ###################### > Could not connect to the database: FATAL: Ident authentication failed > for user "wch" >
You are using ident authentication instead of password. This requires that the database user you are connecting as, be the same as the system user you are logged in as. This is happening because of the following two lines: host all all 127.0.0.1/32 ident host all all ::1/128 ident Change the ident to md5 and you should be good. md5 is the encrypted version of password. The reason the below is not being invoked is that in your connection string you are probably passing the localhost argument which makes a TCP/IP connection(host) instead of a socket(local) connection. local all all password The details of what all this means can be found here: http://www.postgresql.org/docs/9.1/interactive/client-authentication.html -- Adrian Klaver [email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
