su - postgres
psql -d aflmdata -U aflm1234
psql -U aflm1234 -W
postgres=# create user <USER_NAME> with password '******';
CREATE ROLE
postgres=# create database <DB_NAME> owner <USER_NAME>;
CREATE DATABASE
postgres=# grant all privileges on database <DB_NAME> to<USER_NAME>;
GRANT
postgres=# \q
-bash-4.2$ exit
alter user ** with password '';
列出所有数据库：\l 或 select datname from pg_database;
切换数据库：\c 数据库
查询最大连接数
select count(1) from pg_stat_activity;
查看当前连接数
show max_connections;
修改最大连接数
cd /nfsc/csp_stg_fls_afch_id009044_vol1001_stg/postgresql && vim postgresql.conf
