Ubuntu 12.04安装最新版本PostgreSQL
https://wiki.postgresql.org/wiki/Apt
sudo nano /etc/apt/sources.list.d/pgdg.list
粘贴
deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
ctrl+o 回车
ctrl+x
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install postgresql-9.3 pgadmin3
更改密码
sudo su postgres
psql
psql (9.3.4)
Type "help" for help.
postgres=# \password postgres
Enter new password:
Enter it again:
postgres=# \q
exit