ubuntu 14.04 postgresql 的总结

1）为了允许远程连接：

    a) http://askubuntu.com/questions/423165/remotely-access-postgresql-database

To open the port 5432 edit your /etc/postgresql/9.1/main/postgresql.conf and change

listen_addresses='localhost'

to

listen_addresses='*'

 

  b) /etc/postgresql/9.3/main/pg_hba.conf

  host all all 10.182.209.0/24 trust

 

2) postgres 超级用户的密码

http://serverfault.com/questions/110154/whats-the-default-superuser-username-password-for-postgres-after-a-new-install

sudo -u postgres psql postgres

# \password postgres

Enter new password: