Re: Client connection: Port 5432 / Postgres

Поиск
Список
Период
Сортировка
От Nicolas Gignac
Тема Re: Client connection: Port 5432 / Postgres
Дата
Msg-id 172264ae0702081701g74095ca3jfae8a467abf22fc7@mail.gmail.com
обсуждение исходный текст
Ответ на Client connection: Port 5432 / Postgres  ("Nicolas Gignac" <gignacnic@gmail.com>)
Список pgsql-general
Thanks. Finally, I discovered one line not uncomment, stupid typos error.

Nicolas

2007/2/7, Nicolas Gignac <gignacnic@gmail.com>:
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 по дате отправления:

Предыдущее
От: "Mike"
Дата:
Сообщение: Re: Service startup - troubleshooting
Следующее
От: Tommy Gildseth
Дата:
Сообщение: Re: how to store whole XML file in database