Re: 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; pgsql-general(at)postgresql(dot)org
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: pgsql-general(at)postgresql(dot)org
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 (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