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

Re: Problem connecting to PostgreSQL 7.3.4 using

From: "George T(dot) Gibson" <gtgibson(at)jbstamping(dot)com>
To: "KOUEMY Doris Z(dot)" <kzdoris(at)yahoo(dot)fr>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Problem connecting to PostgreSQL 7.3.4 using
Date: 2003-08-19 17:03:55
Message-ID: 34851.192.168.2.250.1061312635.squirrel@192.168.2.254 (view raw or flat)
Thread:
Lists: pgadmin-support
edit the pg_hba.conf file to allow access from remote machines...

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   password
host    all         all         192.168.X.X       255.255.255.0     password

Change X.X to your local network or add a remote network if you are using
a vpn tunnel or port forwarding (dangerous).

Make sure you have also added users that you are trying to connect with.

Log in as postgres and "createuser -P username" if you haven't done so.

Hope that helps.

-- 
J.B. Stamping, Inc.
George Gibson
7413 Associate Ave.
Cleveland, OH 44144
216.631.0013  216.631.1327 fax
gtgibson(at)jbstamping(dot)com


KOUEMY Doris Z. said:
> I use postgresql now and I install it following the instructions give by
> http://www.postgresql.org.
>
> The database server is installed and run on a Linux RH 8.0 machine, and
> pgAdmin II is installed on a Windows 2000 machine. Both machines are not
> on the same network.
>
> My pgAdmin II simply refuses to connect with error message "could not
> connect to server. Could not connect to remote socket".
> - In the postgresql.conf's file, I do " tcpip_socket = true "
> - The client workstation can establish a network connection to the server
> - On the database server
>   . when I do:
>       root:~#chkconfig --list postgresql
>     I see:
>       postgresql 0:off 1:off 2:off 3:off 4:off 5:off       6:off
>   . I have not /rc2.d/S20postgresql in /etc/rc.d/init.d
> - On pgAdminII, when I click on Plugins/pg_hba.conf Editor, I receive the
> following message:
> "an error has occured in pg_hba.conf Editor:frmWizard.Initialise
> Number:76
> Description: path not found "
>
> I'm really stumped on this. Any ideas appreciated.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ---------------------------------
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran├žais !
> Testez le nouveau Yahoo! Mail


In response to

pgadmin-support by date

Next:From: Hiroshi SaitoDate: 2003-08-19 17:10:53
Subject: Re: Problem connecting to PostgreSQL 7.3.4 using pgAdmin II v1.6.0
Previous:From: KOUEMY Doris Z.Date: 2003-08-19 15:59:25
Subject: Problem connecting to PostgreSQL 7.3.4 using pgAdmin II v1.6.0

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