Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connect to pg via tcpip

Connect to pg via tcpip

From
Stephane Pinel
Date:
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 ?

Thanks in advance.


----------------------------------
Stéphane Pinel
39, Rue du Docteur Heulin
75017 Paris (FRANCE)
33 1 53 11 05 77
33 6 08 94 63 16
spinel@noos.fr
----------------------------------

Re: Connect to pg via tcpip

From
"Brett W. McCoy"
Date:
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 ?

Did you start the postmaster with the -i option?

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
You had mail, but the super-user read it, and deleted it!

Re: Connect to pg via tcpip

From
Joel Burton
Date:
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,
they're
disabled by default.

Either:

(a) add -o "-i" to your postmaster or pg_ctl command (for occasional TCP
use depending on startup)

or

(b) edit postgresql.conf to set tcpip_socket = true

HTH,

 --

Joel BURTON  |  joel@joelburton.com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant