For tunnelling your dev app to your live postgres database (assuming you have ssh access to your server), use:

ssh -L 5432:localhost:5432 user@host

That assumes you are not running postgres locally; if you are you’ll need to change the first 5432 in the command to a free local port, and update your dev settings accordingly. — mattw