Postgresql 一些常用配置

su -postgres
psql

create user xxx with password 'aaa';
create database xxx owner xxx;
grant all privileges on database xxx to xxx;

#可能需要添加linux用户
sudo adduser xxx;
sudo passwd xxx;

# postgresql.conf
listen_addresses = '*'

# pg_hba.conf 用户xxx 数据库xxx 可以远程连接
#TYPE   DATABASE    USER    ADDRESS     METHOD
host    xxx         xxx     0.0.0.0/0   md5

# 或者所有
host   all         all     0.0.0.0/0   md5

alter user user with password 'password';