[vwnc] Login to postgreSQL on Ubuntu system from windows

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

On Fri, 18 Apr 2008 16:47:57 +0200
"Dario Trussardi" <[hidden email]> wrote:

> Hello All,
>
> i have a server 'monviso' with Ubuntu 64bit OS where run postgreSQL "testdb" store database.
>
> But if in the enviroment define monviso:5432_testdb the vw erase the error:
>
> Unable to connect to ' store database ' because of the following error:
>
>     Peer communications error.


In cases like this, take a look at the output of

# netstat -lpn

run as root. The top part displays the listening processes with their
port numbers and IP addresses. From what you describe I'd guess that
you'll find 127.0.0.1:5432 for postmaster (i.e. PostgreSQL server)
and monviso probably resolves to another IP address. Even worse,
it might theoretically only 'listen' to a unix socket which usually only
available on the machine itself.

Change the settings in your postgresql.conf file to use

        listen_addresses = '*'

as a quick and dirty fix.

s.
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc