> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
