Thread: I have a need to run PostgreSQL on a windows 2000 server

I have a need to run PostgreSQL on a windows 2000 server

From
"H. Krenske"
Date:
Can you point me to a location where I can get information to install and configure PostgreSQL on a W2K server so that it can be accessed using and the ODBC interface. 
 
I program in powerbuilder and so far I have been able to use  this strategy in front of an early version of PostgreSQL running in RH7.2 as well as MS SQL and Sybase SQL anywhere with very little code modification.  (locking was the only real issue).
 
However in front of PostgreSQL on windows 2000 it returns the error
 
SQLSTATE=08001
Could not connect to the server;
Could not connect to the remote socket.
 
Many thanks
Hugh Krenske

Re: I have a need to run PostgreSQL on a windows 2000 server

From
Ludek Finstrle
Date:
> However in front of PostgreSQL on windows 2000 it returns the error
>
> SQLSTATE=08001
> Could not connect to the server;
> Could not connect to the remote socket.

What's you connection string? You can turn psqlodbc log or mylog (more
details) so you can see what's the connection string and the problem.
Usualy the problem is in hostname in psqlodbc or the server doesn't allow
TCP/IP connection (postgresql.conf on server) or some firewall between?

Regards,

Luf

Re: I have a need to run PostgreSQL on a windows 2000 server

From
Andreas
Date:
H. Krenske schrieb:
> Can you point me to a location where I can get information to install
> and configure PostgreSQL on a W2K server so that it can be accessed
> using and the ODBC interface.
If you use the binary installer version it's just a few clicks and a wee
bit of editing the config-files.

> I program in powerbuilder and so far I have been able to use  this
> strategy in front of an early version of PostgreSQL running in RH7.2
> as well as MS SQL and Sybase SQL anywhere with very little code
> modification.
The configuration of PG on RH7 shouldn't be all that much different than
on Windows.
> However in front of PostgreSQL on windows 2000 it returns the error
> SQLSTATE=08001
> Could not connect to the server;
> Could not connect to the remote socket.

Looks like a network/access-rights issue to me.

1)   Do you run any firewall on the Windows server that prohibits access
to port  5432  ?

2)   Did you enable the option that postmaster should listen for network
clients?

3)   Have you included the clients IP into the pg_hba.conf file within
the datadirectory?

4)   Have you tried to access your PG on Windows without ODBC by psql or
PgAdmin so that you can rule out network issues?