From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Nicolas Gignac <gignacnic(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Client connection: Port 5432 / Postgres |
Date: | 2007-02-08 17:03:33 |
Message-ID: | 45CB57E5.4090606@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Nicolas Gignac wrote:
> 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
Don't you mean pg_hba.conf?
> - 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
It's either not re-read the postgresql.conf file or there is a syntax
error in the file. Otherwise you'd see it listening. What do the logs
say when you restart PostgreSQL?
> - When I tried to connect from local host to the port with telnet localhost
> 5432, I got an error: on port 23, connect failed.
That looks like you're trying to connect to port 23.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-02-08 17:06:22 | Re: Service startup - troubleshooting |
Previous Message | Bruce Momjian | 2007-02-08 16:53:08 | Re: Error on table insert: attribute 13 has wrong type |