人大金仓数据库创建与还原--九五小庞
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