安装

sudo apt install -y postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt install curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
sudo apt update
sudo apt -y install postgresql

# 切换到postgres用户
sudo -i -u postgres

# 备份流程
pg_dump -U ms_test -h localhost -p 5432 -Fc ms_crm_test > ms_crm_test.dump
pg_restore -U postgres -h localhost -p 5432 -d ms_file_manage_dev ms_crm_test.dump
# 授予用户对数据库的权限：
# 切换到目标数据库（假设数据库名是 ms_crm_test）：
\c ms_crm_test
# 授予对整个数据库的访问权限（包括创建对象的权限）：
GRANT CONNECT ON DATABASE ms_crm_prod TO ms_crm;
GRANT CREATE ON DATABASE ms_crm_prod TO ms_crm;
# 授予用户对所有表的权限：
# 如果你想授予 ms_test 用户对 ms_crm_test 数据库中所有现有表的所有权限，可以执行以下 SQL 语句：
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO ms_test;
# 这将会授予 ms_test 用户对 public 模式中所有表的所有权限。
# 授予用户对未来创建的表的权限：
# 如果希望 ms_test 用户对未来创建的所有表也有权限，可以运行以下命令：
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO ms_test;

# 创建数据库并授权
CREATE DATABASE ms_file_manage_dev;
GRANT ALL ON SCHEMA public TO ms_dev;
GRANT ALL PRIVILEGES ON DATABASE ms_file_manage_dev TO ms_dev;
ALTER DATABASE ms_file_manage_dev OWNER TO ms_dev;
GRANT ALL ON DATABASE ms_file_manage_dev TO ms_dev;