PostgreSQL Ubuntuでインストール(ソースから)

sudo apt-get install gcc
sudo apt-get install libreadline6-dev
sudo apt-get install zlib1g-dev
./configure
#sudo ln -s /usr/bin/make /usr/bin/gmake
sudo gmake
sudo gmake install
sudo adduser postgres
sudo mkdir /usr/local/pgsql/data
sudo chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Service Stop:
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop

自動起動
/etc/init.d/rc.localに下記の行を追加する
sudo su -l postgres -c "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >> /home/postgres/dblog/logfile 2>&1 &"

(optional) change postgres user password,type: sudo passwd postgres
(optional) To start the server automatically at every boot, add: su -c ‘/usr/local/pgsql/bin/pg_ctl start -l /usr/local/pgsql/data/log/logfile -D /usr/local/pgsql/data’ postgres to your /etc/rc.local file