<BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <FONT face=Tahoma size=2>-----Original Message-----From: Dave & Eileen Brooks [mailto:[EMAIL PROTECTED]] Sent: 06 October 2001 22:20To: Dave PageSubject: RE: [pgadmin-support] Little Help please <FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">I am trying to connect using ip:port, not odbc <FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> <FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> <FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><IMG class=shape style="DISPLAY: none; WIDTH: 0px; HEIGHT: 0px" height=0 src="png00010.png" width=0 v:src = " "cid:[EMAIL PROTECTED]""; v:dpi = "96" width = "1" height = "1"> <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001>Actually pgAdmin uses the ODBC driver to make the connection, you just don't see that! The error you are getting does mean exactly what it says - it can't connect to the server. Some things to check: <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001> <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001>1) Can you ping your server using the hostname/ip address that you are specifying in the pgAdmin logon dialogue? <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001> <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001>2) Is the postmaster really running on the tcp/ip port specified in the pgAdmin logon dialogue - make sure either the relevant option is set in your postgresql.conf file in $PGDATA, or that the postmaster was started with the -i option. Netstat will show the default domain socket as well as the tcp/ip socket - don't get them confused :-) <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001> <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001>3) Does $PGDATA/pg_hba.conf on you server allow access to the template1 database from your client PC? <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001> <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001>Please let me know if this fixes your problem. <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001> <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001>Regards, Dave. <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN class=833084308-07102001> --Dave Page ([EMAIL PROTECTED])<A href="http://pgadmin.postgresql.org/";>http://pgadmin.postgresql.org/
png00010.png
Description: ""
