TAG
Tag: SSH
4 articles tagged SSH.
- Database
Migrate a PostgreSQL database between two VPS with pg_dump
Move an entire PostgreSQL database (schema and data) from a source VPS to a target VPS through your local machine: dump with pg_dump, restore in a single transaction, verify row counts, then cut over and roll back safely.
- Database
Clone a PostgreSQL database from a VPS to local Windows
Make a full copy (schema and data) of a PostgreSQL database on a VPS onto a Windows dev machine using an SSH tunnel, pg_dump and pg_restore, including how to move the local PostgreSQL port out of the way.
- Database
Connect to PostgreSQL on a VPS through an SSH tunnel
Use an SSH tunnel so your dev machine can reach PostgreSQL on a VPS without exposing port 5432 to the internet, plus the DATABASE_URL setup for local and production.
- VPS
Set up a new VPS: the essential secure steps
Bring up a fresh Ubuntu/Debian VPS safely: create a sudo user, log in with an SSH key, harden sshd, enable the UFW firewall, and disable ping.