Re: [GENERAL] Port forwarding via iptables to postgres listening locally

2011-06-20 Thread David Resnick
I've turned on connection logging in postgres; there is no indication of any connection attempt. There don't seem to be any additional rules configured in iptables that would drop the packets. Are the tables set to drop by default, or allow by default? They are set to drop by default. I'll

Re: [GENERAL] Port forwarding via iptables to postgres listening locally

2011-06-19 Thread Craig Ringer
On 06/19/2011 12:07 PM, David Resnick wrote: Hi, I have a posgres instance configured to listen at the localhost default. I'm trying to enable port forwarding via iptables. I set up the following rule: iptables -t nat -I PREROUTING --source 0/0 --destination 0/0 -p tcp --dport 5432 -j REDIRECT

Re: [GENERAL] Port forwarding via iptables to postgres listening locally

2011-06-19 Thread David Resnick
Thanks a lot for your reply! OK, the source and destination parameters were not intended to hide anything. Setting them like that got the same results in the iptables status output as when not specifying --source and --destination at all. Does --source need to be set to the address the machine is

Re: [GENERAL] Port forwarding via iptables to postgres listening locally

2011-06-19 Thread Craig Ringer
On 06/19/2011 08:35 PM, David Resnick wrote: Thanks a lot for your reply! OK, the source and destination parameters were not intended to hide anything. Setting them like that got the same results in the iptables status output as when not specifying --source and --destination at all. Whoops, I

[GENERAL] Port forwarding via iptables to postgres listening locally

2011-06-18 Thread David Resnick
Hi, I have a posgres instance configured to listen at the localhost default. I'm trying to enable port forwarding via iptables. I set up the following rule: iptables -t nat -I PREROUTING --source 0/0 --destination 0/0 -p tcp --dport 5432 -j REDIRECT and can see that it is redirecting packets