pgAdmin II connection problem

Did you start postmaster with -i option.
Without this option, only local Unix domain socket connections are accepted.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of jj
Sent: Monday, October 14, 2002 7:45 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pgAdmin II connection problem

hi all,

i would like to connect the postgreSQL from a remote hosts, but fails, here
's the detail.
Did anyone know what's going on?

postgreSQL : 7.2.2
OS : RedHat 7.3
ip : 192.168.1.195

remote host :
OS : windows XP
ip 192.168.1.204

i added follwoing line in /var/lib/pgsql/data/pg_hba.conf
host all 192.168.1.204 255.255.255.0 trust

PS : attached with error msg from pgAdmin II
"An error occured in pgAdmin II:frmConnect.cmdConnect_Click:
Number: -2147467259
Description: Could not connect to the server;
Could not connect to remote socket."

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On 15 Oct 2002 at 1:44, jj wrote:

PS : attached with error msg from pgAdmin II
"An error occured in pgAdmin II:frmConnect.cmdConnect_Click:
Number: -2147467259
Description: Could not connect to the server;
Could not connect to remote socket."

Did you started postgresql with -i option? That would enable TCP-IP networking
in postgresql. By default it's not there..

HTH

Bye
Shridhar

--
All new: Parts not interchangeable with previous model.

Hi
Do you have this line in postgresql.conf

tcpip_socket = true

Regards
Serkan Bektas

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of jj
Sent: Monday, October 14, 2002 8:45 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pgAdmin II connection problem

hi all,

i would like to connect the postgreSQL from a remote hosts, but fails, here
's the detail.
Did anyone know what's going on?

postgreSQL : 7.2.2
OS : RedHat 7.3
ip : 192.168.1.195

remote host :
OS : windows XP
ip 192.168.1.204

i added follwoing line in /var/lib/pgsql/data/pg_hba.conf
host all 192.168.1.204 255.255.255.0 trust

PS : attached with error msg from pgAdmin II
"An error occured in pgAdmin II:frmConnect.cmdConnect_Click:
Number: -2147467259
Description: Could not connect to the server;
Could not connect to remote socket."

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org