Psql PgDump

Postgresql的备份和迁移

在新库中创建相同的角色(用户)

create user some_user with password 'password';

create database some_db owner some_user;

grant all privileges on database some_db to some_user;

pg_dump -U some_user -d some_db > some_db.sql

psql -U some_user -d some_db < some_db.sql

\c some_db

\dt

27 January 2026