I am using postgresql 8.2 on Ubuntu Gutsy. I am attempting to connect to my
database on one computer from another computer on my network. I can connect
to the database if I have:
listen_addresses = '*'
in my postgresql.conf file. But I can't connect if I have:
listen_addresses = 'localhost, 192.168.2.102'
in my postgresql.conf file. The computer that is assigned 192.168.2.102 is
the computer I am attempting to connect from that works with the * but not
with an assigned IP address. I understand that having a * allows all
connections but I am attempting to restrict this so only a certain computer
can access the database.
Does anyone know why I can't connect to the database from another computer
when specifying the IP address in 'listen_addresses' and how to fix my
Thanks a lot for the help.
pgsql-admin by date
|Next:||From: Mehlape, Makgati||Date: 2008-02-19 09:39:18|
|Subject: Re: Can't connect from computer on network.|
|Previous:||From: Simon Riggs||Date: 2008-02-19 08:19:18|
|Subject: Re: Failover of the Primary database and starting thestandby database in Postgresql in PITR configuraiton?|