Thread: Problem connecting to PostgreSQL 7.3.4 using pgAdmin II v1.6.0

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@jbstamping.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

Dear KOUEMY Doris Z.

> From: KOUEMY Doris Z.
>
> 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.

It is solved if it can be set up.
It is as mentioned in the message of Mr. George T. of the point.
(snip)

> - 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.

Hmm,
Did this try to touch the thing connected with smb of Samba?
But, it seems to edit the local file of the cygwin base with this plugin.
As a matter of fact, time to fail seems that be in Input (LOF (iFile),
#iFile) of VB.
Could you give us more details about it.

Regards,
Hiroshi Saito