Обсуждение: can't connect to PostgreSQL Database using pgAdminII

I already created the database, the services are good
as well as the network connection but still I can't
connect to the Database. I'm using pgAdminII for
win98. The errors I've encountered are listed below:


Could not connect to the server;
Could not connect to remote socket.

Check each of the following possible causes of this
error:
- The server or port specified is incorrect.

- The client workstation cannot establish a network
connection to the server. Try using 'ping' on the
workstation to check the network.

- The server is not listening on a TCP/IP port. Make
sure that the postmaster was started with the -i
option, or that tcpip_socket = true is set in
$PGDATA/postgresql.conf.


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

did you started your database using the -i parameter ?

send-me the startup string you are using.


---------------------------------
Marco Túlio Oliveira
IT-Manager
www.telecontrol.com.br
----- Original Message -----
From: "dojie pornea" <dojiep@yahoo.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, November 13, 2003 11:39 AM
Subject: [ADMIN] can't connect to PostgreSQL Database using pgAdminII


> I already created the database, the services are good
> as well as the network connection but still I can't
> connect to the Database. I'm using pgAdminII for
> win98. The errors I've encountered are listed below:
>
>
> Could not connect to the server;
> Could not connect to remote socket.
>
> Check each of the following possible causes of this
> error:
> - The server or port specified is incorrect.
>
> - The client workstation cannot establish a network
> connection to the server. Try using 'ping' on the
> workstation to check the network.
>
> - The server is not listening on a TCP/IP port. Make
> sure that the postmaster was started with the -i
> option, or that tcpip_socket = true is set in
> $PGDATA/postgresql.conf.
>
>
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

I just went through this same thing today.  You will also need to go into your postgresql.conf file and set tcpip_socket=true and yes spaces matter (tcpip_socket = true will not work). 

jim



Telecontrol Networking wrote:

did you started your database using the -i parameter ?

send-me the startup string you are using.


---------------------------------
Marco Túlio Oliveira
IT-Manager
www.telecontrol.com.br
----- Original Message -----
From: "dojie pornea" <dojiep@yahoo.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, November 13, 2003 11:39 AM
Subject: [ADMIN] can't connect to PostgreSQL Database using pgAdminII

 

I already created the database, the services are good
as well as the network connection but still I can't
connect to the Database. I'm using pgAdminII for
win98. The errors I've encountered are listed below:


Could not connect to the server;
Could not connect to remote socket.

Check each of the following possible causes of this
error:
- The server or port specified is incorrect.

- The client workstation cannot establish a network
connection to the server. Try using 'ping' on the
workstation to check the network.

- The server is not listening on a TCP/IP port. Make
sure that the postmaster was started with the -i
option, or that tcpip_socket = true is set in
$PGDATA/postgresql.conf.


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
   

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html