PostgreSQL
Jump to navigation
Jump to search
Migrating all databases
On the old server:
su - postgres
pg_dumpall > /tmp/pg-dump.sql
On the new server:
su - postgres
psql -f /tmp/pg-dump.sql