From: | Grzegorz Buś <gall(at)p-team(dot)org> |
---|---|
To: | |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: could not bind IPv4 socket |
Date: | 2009-05-03 19:01:24 |
Message-ID: | 000301c9cc21$907084d0$b1518e70$@org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> listen_addresses gets set to the IP address of the server itself, the
> IP address it is "listening" for input on. Since you're giving it a
> remote address, that's why it can't create a socket to listen there.
> There is a second file here, pg_hba.conf, that filters down who can
> connect to the database. Normal practice here is to set:
> listen_address='*'
OK. My settings now are following:
# cat postgresql.conf | grep listen
listen_addresses = 'localhost,*' # what IP address(es) to listen on;
I did restart postgresql service, but problem still persists:
# rm /var/lib/pgsql/data/pgstartup.log
rm: remove regular file `/var/lib/pgsql/data/pgstartup.log'? y # service
postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
# cat /var/lib/pgsql/data/pgstartup.log
LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a
few seconds and retry.
Local apps can still connect to the postgresql server - but remote can't.
> So that the server is remotely accessible from all of its interfaces,
> and then you can do all filtering of who can connect just via pg_hba.conf
instead.
> See http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html for
more information.
I know - after upgrading PostgreSQL from version 7.4 (which allowed remote
connections) to 8.3 I copied settings from old pg_hba.conf.
--
Kind Regards,
Grzegorz Bus
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2009-05-03 20:14:33 | Re: could not bind IPv4 socket |
Previous Message | Scott Marlowe | 2009-05-03 18:22:10 | Re: keeping track of function execution |