client connection problem
От | Rasmus Mohr |
---|---|
Тема | client connection problem |
Дата | |
Msg-id | 910513A5A944D5118BE900C04F67CB5A0BFD01@MAIL обсуждение исходный текст |
Ответы |
Re: client connection problem
|
Список | pgsql-admin |
Hmmm... I've installed PostgreSQL 7.1.3 with the Red Hat 7.2 installation package, and everything works fine when connecting from localhost as the postgres user, but when I try to connect via TCP I get the usual "connectDBStart() -- ..." error suggesting that postmaster was started without the "-i" option. "-i" is added to /etc/init.d/postgresql - a "ps ax | grep postmaster" confirms this. The pg_hba.conf has modified to allow incoming connections from the subnet, as shown ... host all 192.168.1.164 255.255.255.0 trust host all 192.168.1.150 255.255.255.0 trust host all 192.168.1.0 255.255.255.0 trust ... and I've set "tcpip_socket=true" in the postgresql.conf file... Yet I'm unable to establish a connection - what is wrong? (nmap confirms that postgresql is listening at port 5432) ----------------------------------------------------------- Rasmus T. Mohr Phone : +45 70 117 117 Application Developer Direct : +45 36 910 122 Netpointers Intl. Mobile : +45 28 731 827 Vestergade 18 B Website : www.netpointers.com 1456 Copenhagen K Email : rmo@netpointers.com
В списке pgsql-admin по дате отправления: