- 切换pg用户
su - postgres
- 登录pg数据库
pgsql -U postgres
- 创建用户
create user <userName> with LOGIN SUPERUSER PASSWORD '<password>';
- 创建数据库
create database <databaseName> owner <userName> ENCODING 'UTF8' template template0 LC_COLLATE 'zh_CN.utf8' LC_CTYPE 'zh_CN.utf8';
- 创建表空间
create tablespace <tablespaceName> owner <userName> location '/home/postgres/pgdata';
- 为数据库指定表空间
ALTER DATABASE <databaseName> SET TABLESPACE <tablespaceName>;
- 授权
GRANT ALL PRIVILEGES ON DATABASE <databaseName> TO <userName>;