PostgreSQL创建用户

1. 切换pg用户

	su - postgres

2. 登录pg数据库

 pgsql -U postgres

3. 创建用户

	create user <userName> with LOGIN SUPERUSER PASSWORD '<password>';

4. 创建数据库

 create database <databaseName> owner  <userName> ENCODING 'UTF8' template template0 LC_COLLATE 'zh_CN.utf8' LC_CTYPE 'zh_CN.utf8';

5. 创建表空间

create tablespace <tablespaceName> owner <userName> location '/home/postgres/pgdata'; 

6. 为数据库指定表空间

ALTER DATABASE <databaseName>  SET TABLESPACE <tablespaceName>;

7. 授权

GRANT ALL PRIVILEGES ON DATABASE <databaseName> TO <userName>;