client connection problem

Поиск
Список
Период
Сортировка
Искать
От
Rasmus Mohr
Тема
client connection problem
Дата
Msg-id
910513A5A944D5118BE900C04F67CB5A0BFD01@MAIL
Список
Дерево обсуждения
Re: client connection problem Rasmus Mohr <rmo@Netpointers.com>
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 по дате отправления
От: Roman Gavrilov
Дата:
Сообщение: Re: Monitoring database
От: Jeff Boes
Дата:
Сообщение: Re: VACUUM ANALYZE--how often?
FAQ