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

This is a multi-part message in MIME format.

------=_NextPart_000_007E_01C77791.7CC2E860
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_007E_01C77791.7CC2E860
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">

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

> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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

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?



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings