ubuntu 16.04 下 postgresql 9.5 备份

备份

• 举例： pg_dump -h localhost -d nakama -U nakama -v -f ./nakama.sql

恢复

drop database nakama;
drop user nakama;
CREATE DATABASE nakama;
CREATE USER nakama WITH ENCRYPTED PASSWORD 'some-password';
GRANT ALL PRIVILEGES ON DATABASE nakama TO nakama;
ALTER USER nakama CREATEUSER;
psql -h localhost -d nakama -U nakama -f ./nakama.sql
ALTER USER nakama NOCREATEUSER;

注意： 如果不赋予nakama用户更高权限，再导入数据时会报错如

psql:./nakama.sql:34: ERROR:  must be owner of extension plpgsql

psql:./nakama.sql:11383787: WARNING:  no privileges could be revoked for "public"
REVOKE
psql:./nakama.sql:11383788: WARNING:  no privileges could be revoked for "public"
REVOKE
psql:./nakama.sql:11383789: WARNING:  no privileges were granted for "public"
GRANT
psql:./nakama.sql:11383790: WARNING:  no privileges were granted for "public"
GRANT