On Fri, 19 Oct 2001, Stephane Pinel wrote:
> I need to connect to a pgsql database from a remote place. I read the manual
> and made all the changes in pg_hba.conf etc... But it don't runs.
> Maybe someone could explain to me all the steps I have to complete ?
It's helpful to post error messages you receive rather than simply saying
it doesn't run.
The most likely problem is that you're not running the postmaster or
pg_ctl program w/TCP connections enabled. As a security precaution,
disabled by default.
(a) add -o "-i" to your postmaster or pg_ctl command (for occasional TCP
use depending on startup)
(b) edit postgresql.conf to set tcpip_socket = true
Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
In response to
pgsql-novice by date
|Next:||From: Jason Davis||Date: 2001-10-19 23:57:59|
|Subject: Re: ecpg and multiple connections|
|Previous:||From: Brett W. McCoy||Date: 2001-10-19 20:32:28|
|Subject: Re: Connect to pg via tcpip|