人大金仓数据库创建与还原--九五小庞

1.创建用户

CREATE USER pxy CONNECTION LIMIT - 1 PASSWORD '123456';

2.给用户授权

ALTER USER pxy SUPERUSER;
ALTER USER pxy CREATEDB;
ALTER USER pxy CREATEROLE;
ALTER USER pxy LOGIN;
ALTER USER pxy REPLICATION;

3.创建库

create database labplatform with owner='pxy' ENCODING UTF8;

4.还原数据库

(1)方式1

注：如果此方式还原不成功，则通过第二种方式还原

.\ksql.exe -U system -d labplatform -p 3311 -f C:\Users\PXY\Downloads\date\DB_2023-07-31_10_18_11.dmp

(2)方式2

.\sys_restore.exe --username "pxy"  --port "3311" --dbname "labplatform" C:\Users\PXY\Downloads\date\DB_2023-07-31_10_18_11.dmp