ubuntu下安装PostgreSQL笔记

1.下载PostgreSQL数据库:

postgresql-9.6beta2.tar.gz
https://www.postgresql.org/ftp/source/v9.6beta2/

2.解压安装包

tar -zvxf postgresql-9.6beta2.tar.gz

3.根据安装包内的install文件来安装

./configure
make
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
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

4解决安装过程中可能出现的错误

a)readline没有安装

configure: error: readline library not found

安装readline

sudo apt-get install libreadline6 libreadline6-dev

b)zlib没有安装

configure: error: zlib library not found

安装zlib

sudo apt-get install zlib1g zlib1g-dev