Re: Firewalls and Postgres - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Firewalls and Postgres
Date
Msg-id 5.1.0.14.1.20030130005349.028453b0@mbox.jaring.my
Whole thread Raw
In response to Re: Firewalls and Postgres  (Tony Grant <tony@tgds.net>)
Responses Re: Firewalls and Postgres
List pgsql-general
At 05:13 PM 1/29/03 -0500, Tony Grant wrote:
>ome tweaking in postgresl.conf and pg_hba.conf.
>
>OK the database is behind a firewall. What if I modify pg_hba.conf to
>let everybody access the database from anywhere?
>
>Risk is leet hax hacks his way through the firewall and does damage. If
>he gets through the firewall he will probably be able to break lots of
>other stuff than Postgres too...

How about pg_hba.conf configured to allow any IP to access.

But the host postgresql is running on is configured to not allow external
access postgresql port, and only allows ssh or whatever you picked to
tunnel stuff in.

So the only way in is via the tunnel.


>I really want to port forward the web application running on port 80.
>But the database behind the web application replies to the requests and
>won't serve the data to my IP. JSP is pretty good at tightening stuff
>like that down!

I don't understand the dynamic IP part you mentioned in another post.

Is your web app really on a dynamic IP on the Internet, trying to access a
remote postgresql server through a firewall?

Some details on your network setup could be helpful.

Link.


pgsql-general by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Re: numeric usernames in 7.3.1?
Next
From: Tom Lane
Date:
Subject: Re: index on timestamp performance