TAG
Tag: PostgreSQL
7 articles tagged PostgreSQL.
- 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.
- Database
Tune VPS performance: swap, PostgreSQL and the DB pool
Speed up a 16GB Ubuntu VPS that runs many Docker containers next to PostgreSQL: add swap to keep the OOM Killer away, tune PostgreSQL for more RAM and SSD storage, then raise the app's connection pool.
- Database
Fix Docker containers that cannot reach PostgreSQL on a VPS
Docker picks a new network range every time you run docker-compose down and up, so PostgreSQL on the host rejects the container. Diagnose the subnet, open UFW and pg_hba.conf, then allow the whole 172.16.0.0/12 range to fix it once.
- Database
DBeaver tips: bigger toolbar icons and the TimeZone error fix
Two handy dbeaver.ini tweaks: scale up tiny toolbar icons on high-DPI displays with swt.autoScale, and fix the invalid value for parameter TimeZone Asia/Saigon error when connecting to PostgreSQL.
- Database
Set up PostgreSQL on a VPS securely
Install and configure PostgreSQL on an Ubuntu/Debian VPS for production: create a database and user, open remote access safely (SSL + pg_hba + UFW), and understand transaction isolation.