> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Keith Worthington > Sent: 11 October 2004 19:49 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] bad pg_hba.conf file > > Hi All, > > When I try to connect to the database server I get an error > indicating my pg_hba.conf file is bad. Here are the only two > lines that I have. Any comments pointing me in the correct > direction would be appreciated. > > # TYPE DATABASE USER IP-ADDRESS IP-MASK > METHOD > local all all > host all all 192.168.7.0 > 255.255.255.0 trust
This should really be on a PostgreSQL list, not a pgadmin one, but seeing as it's a quickie, you appear to be missing the method value on the 'local all all' entry. You need to specify how matches to that line will be authenticated - eg. md5, trust etc. Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html