ubuntu-14.04編譯安裝PostgreSQL

#安裝依賴包

sudo apt-get install libreadline6-dev

sudo apt-get install zlib1g-dev

sudo apt-get install libssl-dev

#下載源碼，并且壓縮

sudo tar xf postgresql-9.5.2.tar.gz

cd postgresql-9.5.2

./configure --prefix=/usr/local/pgsql--with-pgport=5432 --with-openssl

運(yùn)行make提示：

sudo apt-get install make   安裝make

#編譯安裝

make –j 4  &&  sudo make install

#安裝contrib

cd contrib

make

sudo make install

#添加用戶和組

sudo adduser postgres

#建立數(shù)據(jù)庫(kù)數(shù)據(jù)目錄并授權(quán)

sudo mkdir /usr/local/pgsql/data

sudo chown -R postgres:postgres/usr/local/pgsql/data

su postgres

#初始化數(shù)據(jù)庫(kù)并啟動(dòng)數(shù)據(jù)庫(kù)

/usr/local/pgsql/bin/initdb -D  /usr/local/pgsql/data/

/usr/local/pgsql/bin/postgres –D  /usr/local/pgsql/data>logfile 2>&1 &

#創(chuàng)建數(shù)據(jù)庫(kù)test

/usr/local/pgsql/bin/createdb test

#進(jìn)入test數(shù)據(jù)庫(kù)

/usr/local/pgsql/bin/psql test

#將啟動(dòng)腳本加入到系統(tǒng)服務(wù)

sudo cp /usr/local/src/postgresql-9.5.2/contrib/start-scripts/linux /etc/init.d/postgresql

sudo chmod +x /etc/init.d/postgresql

#查看postgresql服務(wù)

sudo service postgresql status

#查看數(shù)據(jù)庫(kù)進(jìn)程運(yùn)行狀態(tài)

ps aux | grep postgres

#設(shè)置為開(kāi)機(jī)啟動(dòng)

sudo update-rc.d postgresql defaults