[GENERAL] PostgreSQL 8.0 install woes

[Taber, Mark]

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

[Tom Lane]

"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

[Magnus Hagander]

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

[Ron St-Pierre]

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

[Taber, Mark]

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

[Taber, Mark]

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