Client connection: Port 5432 / Postgres
От | Nicolas Gignac |
---|---|
Тема | Client connection: Port 5432 / Postgres |
Дата | |
Msg-id | 172264ae0702070828o36e14e91x6a5e6dd02df3361a@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Client connection: Port 5432 / Postgres
Re: Client connection: Port 5432 / Postgres Re: Client connection: Port 5432 / Postgres Re: Client connection: Port 5432 / Postgres Re: Client connection: Port 5432 / Postgres |
Список | pgsql-general |
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
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 по дате отправления: