Postgres Pro
Downloads
Home   >   mailing lists

Client connection: Port 5432 / Postgres - Mailing list pgsql-general

From Nicolas Gignac
Subject Client connection: Port 5432 / Postgres
Date
Msg-id 172264ae0702070828o36e14e91x6a5e6dd02df3361a@mail.gmail.com
Whole thread Raw
Responses Re: Client connection: Port 5432 / Postgres  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Client connection: Port 5432 / Postgres  (Richard Huxton <dev@archonet.com>)
Re: Client connection: Port 5432 / Postgres  (Mikko Partio <dun@haisuli.net>)
Re: Client connection: Port 5432 / Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Client connection: Port 5432 / Postgres  ("Nicolas Gignac" <gignacnic@gmail.com>)
List pgsql-general
Tree view
Hello,

I have installed Postgres 8.2 on a internal server having Windows Server 2003 (IIS 6) up and running.
- I have configure the hp_config file to: host                    all                             0.0.0.0./0                                md5
- I have change the listening address to '*' in the postgres.conf file
- No Firewall activated on this internal server
- I have restart the server and I can connect to postgres from remote computer, PostgreSQL works only from the local host
- When I do a Netstat I got this: TCP           127.0.0.0.1:5432                            0.0.0.0.0                          LISTENING              440
- When I tried to connect from local host to the port with telnet localhost 5432, I got an error: on port 23, connect failed.

What are the options/ways to allow connection by PostgreSQL remote Clients to the 5432 port on my server in this internal network? Or is there any problem with my steps, something I missed?

Thanks for your help.

Nicolas Gignac

pgsql-general by date:

Previous
From: "fritz-bayer@web.de"
Date:
Subject: line folding versus shop line
Next
From: "Jim C."
Date:
Subject: Re: Postgres SQL Syntax