ubuntu postgresql
PostgreSQL is pronounced Post-Gres-Q-L.
sudo apt-get install postgresql-9.1
sudo gedit /etc/postgresql/9.1/main/postgresql.conf
sudo gedit /etc/postgresql/9.1/main/pg_hba.conf
local all postgres peer
->
local all postgres trust
重新启动postgresql进程服务
sudo
/etc/init.d/postgresql restart
psql -U postgres
alter user postgres with password 'root';
\q
pgAdminIII