Re: Firewalls and Postgres

Alan:
I'm running postgres DB's behind a local network with access
controlled via a linux machine, works well, but firewall is a pretty
generic term.. Our implementation is based on a host running linux
using iptables to manage access, though you may have problems with ident,
hostssl and userid/password work fine. Ident may work if you use the same
port mapping on the point of control (firewall machine) and on the
host which servers up postgres on the local (protected) lan. If the ports
are not the same on the point of control and the protected postgres
host, ident seems to get confused and does not work..

Kenny

On Wed, Jan 29, 2003 at 08:04:01AM -0700, Alan Carbutt wrote:
> Does anyone know if postgres uses any additional ports that might be
> blocked by a firewall? I'm setting up a data warehouse prototype using
> pgAccess as the front end and I'm not having too much success with
> firewalling. Any help is greatly appreciated.
> Thanks,
> --
> Alan Carbutt
> Systems Administrator/Programmer
> Adams State College
> 719-587-7741
> arcarbut(at)adams(dot)edu