When wanting to access a remote running postgres dbase I always forget the correct command to set up a ssh tunnel.

ssh -L 65432:localhost:5432 user@server