Search This Blog

2009-12-23

PostgreSQL over SSH tunnel

17.9. Secure TCP/IP Connections with SSH Tunnels

ssh -L 3333:localhost:5432 joe@foo.com
psql -h localhost -p 3333 postgres

Magic numbers...

And our debian server installation size at the moment is:

6291456 - (3808624 - (286884 + 2788684)) = 5558400

2009-12-20

how do you keep http service running as a non privileged user and bound to port 80?

1. get the server running on 8080
2. in the startup script before the actual server start command add:

iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-port 8080