[GENERAL] PostgreSQL 8.0 install woes
I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. I’m even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following message: An error has occurred: Error connecting to the server: could not connect to the server: Connection refused (0x274D/10061) Is the server running on host “nnn.nnn.nnn.nnn” and accepting TCP/IP connections on port 5432? The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432. It fails in both directions. The machines can see each other on the network. Thanks in advance for all your help. Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945
Re: [GENERAL] PostgreSQL 8.0 install woes
"Taber, Mark" <[EMAIL PROTECTED]> writes: > Error connecting to the server: could not connect to the server: Connection > refused (0x274D/10061) That means the operating system rejected the connection, which probably means a firewall/packet filter problem. If the request had made it as far as the postmaster, you'd have gotten a different response. > The answer is, yes the server is running on the host, and there are no > restrictions on either machine for port 5432. I think you're dead wrong on that last assertion. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] PostgreSQL 8.0 install woes
Title: Meddelande Make sure the server actually listens on connections other than 127.0.0.1 - check "listen_addresses" in postgresql.conf. //Magnus -Ursprungligt meddelande-Från: Taber, Mark [mailto:[EMAIL PROTECTED] Skickat: den 4 oktober 2004 20:29Till: [EMAIL PROTECTED]Ämne: [GENERAL] PostgreSQL 8.0 install woes I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. Im even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following message: An error has occurred: Error connecting to the server: could not connect to the server: Connection refused (0x274D/10061) Is the server running on host nnn.nnn.nnn.nnn and accepting TCP/IP connections on port 5432? The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432. It fails in both directions. The machines can see each other on the network. Thanks in advance for all your help. Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945
Re: [GENERAL] PostgreSQL 8.0 install woes
Taber, Mark wrote: I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. I’m even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following message: An error has occurred: Error connecting to the server: could not connect to the server: Connection refused (0x274D/10061) Is the server running on host “nnn.nnn.nnn.nnn” and accepting TCP/IP connections on port 5432? The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432. It fails in both directions. The machines can see each other on the network. Thanks in advance for all your help. **Mark Taber** State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 //x//294 On the off-chance that you're running ZoneAlarm, make sure that postgres is allowed to run as a server. Ron ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] PostgreSQL 8.0 install woes
Thanks for your help. Over the protests of my network guys, I did a port scan, and sure enough, port 5432 wasn’t available. Also, my .conf file was only looking for localhost. Having worked through this, now there’s something wrong with my pg_hba.conf file. Again, thanks, all. Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945 From: Taber, Mark Sent: Monday, October 04, 2004 11:29 AM To: [EMAIL PROTECTED] Subject: [GENERAL] PostgreSQL 8.0 install woes I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. I’m even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following message: An error has occurred: Error connecting to the server: could not connect to the server: Connection refused (0x274D/10061) Is the server running on host “nnn.nnn.nnn.nnn” and accepting TCP/IP connections on port 5432? The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432. It fails in both directions. The machines can see each other on the network. Thanks in advance for all your help. Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945
Re: [GENERAL] PostgreSQL 8.0 install woes
A final note…we are up and running. Thanks again for all the help. So post mortem indicates that 1) Port 5432 was not available, despite what our network guys told me; 2) In my rush to get things up and running, I forgot to make relevant changes to the .conf files (problem lay between the keyboard and the chair). Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945 From: Taber, Mark Sent: Monday, October 04, 2004 1:55 PM To: Taber, Mark; [EMAIL PROTECTED] Subject: RE: [GENERAL] PostgreSQL 8.0 install woes Thanks for your help. Over the protests of my network guys, I did a port scan, and sure enough, port 5432 wasn’t available. Also, my .conf file was only looking for localhost. Having worked through this, now there’s something wrong with my pg_hba.conf file. Again, thanks, all. Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945 From: Taber, Mark Sent: Monday, October 04, 2004 11:29 AM To: [EMAIL PROTECTED] Subject: [GENERAL] PostgreSQL 8.0 install woes I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. I’m even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following message: An error has occurred: Error connecting to the server: could not connect to the server: Connection refused (0x274D/10061) Is the server running on host “nnn.nnn.nnn.nnn” and accepting TCP/IP connections on port 5432? The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432. It fails in both directions. The machines can see each other on the network. Thanks in advance for all your help. Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945