[PostgreSQL] 密码设置

1. 创建用户名密码
=# create role hoge password 'pass';
CREATE ROLE
=# alter role hoge login;
ALTER ROLE
=# \password hoge

2. pg_hba.conf
# TYPE  DATABASE USER ADDRESS METHOD
  local all      hoge         md5 (password)

3. 免密码设置
hostname:port:database:username:password
$ echo localhost:5432:postgres:hoge:pass > ~/.pgpass
$ chmod 600 ~/.pgpass