ppa forwarding

to upgrade the database, I need to add a ppa archive, but the outbound
port is blocked, the port number is 11371

on db:

on server:
sysctl net.netfilter.nf_conntrack_acct=1
sysctl net.ipv4.ip_forward=1

and then the rules
iptables --append FORWARD -j ACCEPT
iptables -t nat --append POSTROUTING  -j MASQUERADE

and then on the client I set the gw for that host to be server.

The above may be a bit overkill, but it worked.  I tried using iptables on the client to forward the packets without setting the gateway, but I didn't have any luck with that.

Now onto upgrading postgres.

First backup with pg_dumpall

Next aptitude dist-upgrade

Then use psql to reimport the data, and it looks ok.

the next task is to connect to a different schema than public using perl