创建空库
CREATE DATABASE abcv4
WITH
OWNER = postgres
ENCODING = ‘UTF8’
LC_COLLATE = ‘Chinese (Simplified)_China.936’
LC_CTYPE = ‘Chinese (Simplified)_China.936’
TABLESPACE = pg_default
CONNECTION LIMIT = -1;
还原数据库
psql -d abcv4 -U odoo14 -f abcv4_2023_2_9.sql
备份数据库
pg_dump -U postgres abcv4_5> abcv4_5_2023_2_10.sql
先创建空库再进行还原