Chris Guo wrote: > Dear all, > > > > I just installed postgresql 0.8.3 on the fedora core linux 3, I also > installed pgadmin 1.0.2 in my computer. But I am having trouble connecting > postgresql by using pgadmin, it shows me the error message" An error > occurred: Error connecting to the server: could connect to server: > Connection refused (0x0000274D/10061) Is the server running on host > "192.168.3.118" and accepting TCP/IP connections on port 5432?" > > I am pretty sure that the postgresql server is running, but I figured it's > because the command I use to run the postgresql serve is not quite right and > the port 5432 is not open to listen to the request since I didn't find port > 5432 after using namp to check the open port on the linux server.
Hi Chris, please make sure that you have "tcpip_socket = true" in the postgresql.conf file (located in /etc/postgresql on my system). After that tune the parameters in the pg_hba.conf file located in the same directory as postgresql.conf. Then restart your PostgreSQL server and everything should be ok. In the next release of pgAdmin it should be possible to connect directly to the local socket without needing to configure TCP/IP listening on server side. Regards, Raphaël ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly