Skip site navigation (1) Skip section navigation (2)

Re: connecting to linux server from windows xp

From: Sebastian Scarano <opensas(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: connecting to linux server from windows xp
Date: 2005-11-14 09:17:49
Message-ID: d574718c0511140117h2db1881eo3801a8ca35d8f5d8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
---

my postgresql.conf

---

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
PGDATA=/var/lib/postgresql/data

# Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!)
PGLOG=/var/lib/postgresql/data/postgresql.log

# Run the PostgreSQL user as:
PGUSER=postgres

# 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"
PGOPTS="-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
both machines

----

(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
following error:

"Server not listening"

Am I missing something???

In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2005-11-14 09:45:39
Subject: Re: connecting to linux server from windows xp
Previous:From: Sebastian ScaranoDate: 2005-11-14 07:32:23
Subject: help compiling pgmanage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group