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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2003-08-19 17:10:53 | Re: Problem connecting to PostgreSQL 7.3.4 using pgAdmin II v1.6.0 |
Previous Message | KOUEMY Doris Z. | 2003-08-19 15:59:25 | Problem connecting to PostgreSQL 7.3.4 using pgAdmin II v1.6.0 |