Re: postgresql with tcp/ip conection

[Zenaan Harkness <zen@freedbms.net>]

On Fri, 2004-07-09 at 16:59, Oliver Elphick wrote:
> On Thu, 2004-07-08 at 18:33, cenapad wrote:
> > Does anybody  know how to configure /etc/init.d/postgresql to accept 
> > TCP/IP conections?

> The default setup for TCP/IP connections is to accept them from
> localhost only.  If you are having problems connecting from another
> machine, this is likely to be what needs changing.

I recommend using putty (on windows) or ssh to tunnel postgres
connections to the postgres box. Eg:

ssh -L 5432:localhost:5432 username@postgres-host

that is:

ssh -L <local port>:<host to connect from remote host>:<remote port> ...

Then, of course, run some postgres tool (like pgadmin, psql, etc) and
connect localhost:5432 (where you start the tunnel from).

cheers
zen