I had a similar problem: older versions of Postgres have IP addressing in one column and subnetting/mask in the next one. 8.4 uses CIDR expression in one column - applying CIDR notation solved my problem. I think it's advisable to manually correct the pg_hba.conf file instead of replacing it with the old configuration file from the older version of Postgres.
Cheers, Pete From: Scott Mead <scott.li...@enterprisedb.com> To: jkun...@laurcat.com Cc: postgres help <pgsql-general@postgresql.org> Date: 28/04/2010 18:41 Subject: Re: [GENERAL] pg_hba.conf Sent by: pgsql-general-ow...@postgresql.org On Tue, Apr 27, 2010 at 6:42 AM, <jkun...@laurcat.com> wrote: I am putting up a new server on version 8.4.3. I copied pg_hba.conf from a running 8.3.6 system, changing only the public IP address for the local machine. I get the error: FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres", database "arc" pg_hba.conf contains the line: host all all 209.159.145.248 255.255.255.255 trust Hmm, just for giggles, does it work using CIDR syntax: host all all 209.159.145.248/32 trust ? --Scott -- Scott Mead Principal Systems Engineer EnterpriseDB Corporation The Enterprise Postgres Company Other records work (I can connect from my remote site using pgAdmin, just fine), so I know the file is being read by posgres. Any ideas? Thanks in advance, Jim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general This email (and attachments) are confidential and intended for the addressee(s) only. If you are not the intended recipient please notify the sender, delete any copies and do not take action in reliance on it. Any views expressed are the author's and do not represent those of IOP, except where specifically stated. IOP takes reasonable precautions to protect against viruses but accepts no responsibility for loss or damage arising from virus infection. For the protection of IOP's systems and staff emails are scanned automatically.” Institute of Physics Registered in England under Registration No 293851 Registered Office: 76/78 Portland Place, London W1B 1NT
