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.
7413 Associate Ave.
Cleveland, OH 44144
216.631.0013 216.631.1327 fax
KOUEMY Doris Z. said:
> I use postgresql now and I install it following the instructions give by
> 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
> 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 Saito||Date: 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|