| Lists: | pgsql-general |
|---|
| From: | zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | port warded (iptables) postgres |
| Date: | 2010-11-16 23:41:53 |
| Message-ID: | AANLkTim7uAXOvwp=pjR6uEUcoN-8ttmgKw7mU0x4ofWY@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hello
I have successfully used iptables to direct ports for other services.
For example I run apache on 8443 on 127.0.0.1 and
use iptable to direct traffic to public ip on 443. Trying the same
with postgresql does not seem to work properly.
I was wondering whether anyone has successfully used iptables +
postgres this way
Thanks in advance
Mr. Wu
| From: | Scott Mead <scott(at)scottrmead(dot)com> |
|---|---|
| To: | zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: port warded (iptables) postgres |
| Date: | 2010-11-17 01:05:55 |
| Message-ID: | AANLkTintuSrwtxg0H4fJgVHukmUhERH_oGD0OoKMOS53@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Make sure that listen_addresses='<someIP>' or '*'
By default, the server only listens on unix sockets.
--Scott
On Tue, Nov 16, 2010 at 6:41 PM, zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com> wrote:
> Hello
>
> I have successfully used iptables to direct ports for other services.
> For example I run apache on 8443 on 127.0.0.1 and
> use iptable to direct traffic to public ip on 443. Trying the same
> with postgresql does not seem to work properly.
>
> I was wondering whether anyone has successfully used iptables +
> postgres this way
>
> Thanks in advance
>
> Mr. Wu
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>