duh!listen_addresses = '*'I must add that having to modify both files forremote access is a bit misleading, and I didn't set at least 4 postgresql servers before...From: mcmoisei@hotmail.comTo: pgsql-general@postgresql.orgSubject: [GENERAL] Ubuntu, Postgresql-8.2 and remote access thru pg_hba.confDate: Mon, 18 Jun 2007 01:09:18 -0500





Hi,I just want to say that ubuntu team done an excelent job integration thepenultimate version of postgresql in spite of the fact that I was running 7.4.7 it manages to install 8.2 in paralel without affecting my production version. There is one single thing that bothers me big time - I cannot connect to 8.2 from my vista box.I was able to do so to 7.4.7 using Vista and I'm still able to do so on the very same box!Here's some fact, I know people overhere like facts0. I want to connect from within my network ( only from one computer) to the remote box that runs ubuntu1. If I run a telnet on the box that runs the 8.2 to the port number I get a connection, and the postgredsql-8.2 log shows the connection (modified the postmaster.conf to log extra)2. Connection remotely from pgadmin it says connection fail and no other info. In postgresql logs there is no trace of the pgadmin connectionI assume that the 8.2 doesn't allow connection from my vista IP address3. My pg_hba.conf looks like below, I have an entry with IPV6 in there but it didn't work either.# Database administrative login by UNIX socketslocal all postgres ident sameuser# TYPE DATABASE USER CIDR-ADDRESS METHOD# "local" is for Unix domain socket connections onlylocal all all ident sameuser# IPv4 local connections:host all all 127.0.0..1/32 trusthost all all 192.168.1.103/32 trust# IPv6 local connections:host all all ::1/128 trustWhat do you suggest to try next.Thanks,MC