By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,676 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

PostgreSQL 8.0 install woes

P: n/a
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 (0x0000274D/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


Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Taber, Mark" <Ma********@dof.ca.gov> writes:
Error connecting to the server: could not connect to the server: Connection
refused (0x0000274D/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

Nov 23 '05 #2

P: n/a
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 (0x0000274D/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 ma*******@postgresql.org

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.