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
--
