Re: setting Postgres client
От | Richard Huxton |
---|---|
Тема | Re: setting Postgres client |
Дата | |
Msg-id | 48D3CBBE.9040801@archonet.com обсуждение исходный текст |
Ответ на | Re: setting Postgres client ("Markova, Nina" <nmarkova@NRCan.gc.ca>) |
Ответы |
Re: setting Postgres client
|
Список | pgsql-general |
Markova, Nina wrote: > > Thanks Richard. > > > I specified the host IP ( I use the default 5432 port), got error: > psql: could not connect to server: Connection refused > Is the server running on host "192.168.XX.XXX" and accepting > TCP/IP connections on port 5432? > > The only tcp lines in my postgres.conf are > #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > # 0 selects the system default > #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > # 0 selects the system default > #tcp_keepalives_count = 0 # TCP_KEEPCNT; > # 0 selects the system default > Should I change something here? Check "listen_addresses" and "port" look OK. You're probably only listening to localhost. You can test by telnet-ing to port 5432 or using lsof / netstat to see what connections you have open in that zone. -- Richard Huxton Archonet Ltd
В списке pgsql-general по дате отправления: