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




posted @ 2014-05-22 20:35  openlog  阅读(541)  评论(0编辑  收藏  举报