|
I've had problems before with the listen_addresses and had to set it accordingly. Wouldn't accept connections locally. listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all # (change requires restart) port = 5432 > Date: Tue, 27 Apr 2010 21:08:31 +0900 > From: ketanaka@xxxxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: pg_hba.conf > > Hi > > >Would there be a line earlier in the file that matches and is preventing > >a connection? > > At first, I think so too. > But if there is a line earlier in the file ,we get following error. > > ------------------------------------------------------------------------ > psql: could not connect to server: Connection refused > Is the server running on host "192.168.23.132" and accepting > TCP/IP connections on port 1843? > ------------------------------------------------------------------------ > > ex: my pg_hba.conf > ------------------------------------------------------------------------ > host all all 192.168.23.132 255.255.255.255 deny > host all all 192.168.23.132 255.255.255.255 trust > ------------------------------------------------------------------------ > > > The Jim's message say pg_hba.conf has no entory. > > ------------------------------------------------------------------------ > FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres", > database "arc" > ------------------------------------------------------------------------ > > 1)Is pg_hba.conf's location correct? > You can check to execute this command. > > postgres=# show hba_file; > hba_file > ------------------------------- > /home/p843/pgdata/pg_hba.conf > (1 row) > > 2)Did you reload pg_hba.conf? > If we change pg_hba.conf ,we must execute "pg_ctl reload" > > 3)pg_hba.conf may have a trash. > Can you recreate pg_hba.conf? > *Don't copy old pg_hba.conf. > > > Thank you. > > > On 27/04/2010 11:42, jkunkel@xxxxxxxxxxx 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 > >> > > Would there be a line earlier in the file that matches and is preventing > > a connection? > > > > Ray. > > > > > > > -- > ================================================ > Kenichiro Tanaka > K.K.Ashisuto > http://www.ashisuto.co.jp/english/index.html > ================================================ > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Hotmail & Messenger. Get them on your phone now. |
