TAG
Tag: Backup
2 articles tagged Backup.
- 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.