Re: Problem connecting to PostgreSQL 7.3.4 using

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