备份
- 举例：
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
