linux
ssh登陆远程服务器
ssh 192.168.31.109 -l root -p 22
新建用户
create user test02 password '123';
授予权限，如授予select权限
grant select on all tables in schema public to test02;
新建数据库表空间
mkdir /usr/local/pgdata
chown postgres:postgres /usr/local/pgdata/
postgres=# create tablespace tbs_test owner postgres location '/usr/local/pgdata';
新建数据库
CREATE database test_db with owner=test02 template=template0 encoding='UTF8' tablespace=tbs_test connection limit = 100;
修改表空间位置
ALTER DATABASE "test_db" SET TABLESPACE "tbs_test02";
