Re: cannot connect anymore from a remote host

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Luca Ferrari <fluca1978(at)infinito(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: cannot connect anymore from a remote host
Date: 2006-11-09 15:21:47
Message-ID: 7318.1163085707@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)com> writes:
> Luca Ferrari wrote:
>> I've started the daemon as:
>> postmaster -D /mnt/data/database &

> Is that how you normally start your DB server?

Ditto. But if you are using a stock postgresql.conf then in fact the
postmaster will *not* be listening to TCP with that command line.
You need to check listen_addresses or tcpip_socket depending on which
Postgres release this is.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-11-09 15:29:43 Re: Why overlaps is not working
Previous Message Luca Ferrari 2006-11-09 15:14:04 Re: cannot connect anymore from a remote host