With the help of Andreas, I could finally connect a from a guest xp running
with vmware inside a host xp machine
Now I'm trying to do the same with a host gentoo box and a guest xp SP1
this is my pg_hba.conf
tux data # cat pg_hba.conf | tail -n 8
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 <http://127.0.0.1/32> trust
host all all 192.168.0.0/16 <http://192.168.0.0/16> md5
# IPv6 local connections:
host all all ::1/128 trust
tux data # cat postgresql.conf | grep listen
# "pg_ctl reload". Some settings, such as listen_address, require
listen_addresses = '*'
#listen_addresses = 'localhost' # what IP interface(s) to listen on;
and my /etc/conf.d/postgresql
tux data # cat /etc/conf.d/postgresql
# PostgreSQL's Database Directory
# Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!)
# Run the PostgreSQL user as:
# Extra options to run postmaster with.
# If you want to enable TCP/IP for PostgreSQL, add -i to the following:
#PGOPTS="-N 1024 -B 2048 -i"
I have the xp guest configured to use NAT network connection, and in the
host file I've configured the ip address of the host.
I can ping each other by ip address or name, thanks to the hosts file in
(pinging from the host)
tux data # ping xp
PING xp (192.168.103.128 <http://192.168.103.128>) 56(84) bytes of data.
64 bytes from xp (192.168.103.128 <http://192.168.103.128>): icmp_seq=1
ttl=128 time=1.42 ms
64 bytes from xp (192.168.103.128 <http://192.168.103.128>): icmp_seq=2
ttl=128 time=0.148 ms
When I try to connect from the host using pgaminIII for windows, I get the
"Server not listening"
Am I missing something???
In response to
pgsql-novice by date
|Next:||From: A. Kretschmer||Date: 2005-11-14 09:45:39|
|Subject: Re: connecting to linux server from windows xp|
|Previous:||From: Sebastian Scarano||Date: 2005-11-14 07:32:23|
|Subject: help compiling pgmanage|