[COLUG] Postgres / VMWare

[Vincent Herried]

On Friday 28 December 2007 11:27:17 am Mark Erbaugh wrote:
> I have determined that VMWare gives my host computer the IP address of
> 192.168.201.1 so that the VM can use to communicate with it.  I want to
> set up the Postgres server to listen on that address, but don't want it
> listening on all IP addresses. Thus in postgresql.conf, I set
> listen_addresses to '192.168.201.1,localhost'.

I don't claim to fully understand this... in file
/var/lib/pgsql/data/pg_hba.conf
add a line like....

host    all     all     192.168.1/16            trust

This would allow access from all 192.168.*

-- 
my website is http://planetvince.info
v