Re: Firewalls and Postgres

From: Tony Grant <tony(at)tgds(dot)net>
To: Holger Klawitter <lists(at)klawitter(dot)de>
Cc: Alan Carbutt <arcarbut(at)adams(dot)edu>, postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Firewalls and Postgres
Date: 2003-01-29 22:07:14
Message-ID: 1043878034.2496.30.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2003-01-29 at 10:47, Holger Klawitter wrote:

> > I can not figure yet how to do ssh port forwarding on it. Any tips
> > appreciated.
>
> No problems with that (at least with openssh), even through a firewall:
>
> ssh -l my-secret-key-file -n -N \
> -L 15432:other.host.com:5432 \
> other.host.com </dev/null
>
> psql -h localhost -p 15432 my_database
>
> However,you have to keep in mind that this connection ends up on
> other.host.com as a tcp/ip connection on 11.22.33.44, not on 127.0.0.1.
> Might need some tweaking in postgresl.conf and pg_hba.conf.

I thought it might be something like that. Not going to be easy with a
dynamic IP...

Thanks

Tony

--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2003-01-29 22:13:59 Re: Firewalls and Postgres
Previous Message Tony Grant 2003-01-29 22:03:51 Re: Website troubles