On Thu, 30 Apr 2009, Grzegorz Bu? wrote:
listen_addresses = 'localhost,XXX.XXX.XXX.XXX'
where XXX.XXX.XXX.XXX is IP address of remote client that I want to be able to use PostgreSQL server. Port is default.
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='*'
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.
--
* Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
