PostgreSQL使用

下载源码

git clone https://github.com/postgres/postgres.git
cd postgres
git checkout REL_11_STABLE

编译安装

./configure --prefix=/Users/oyld/work/pghome --enable-debug --enable-cassert CFLAGS="-ggdb -O0 -g3 -Wall -fno-omit-frame-pointer -fstack-protector-strong"
make -j
make instll

配置环境变量

export PATH=/Users/oyld/work/pghome/bin:$PATH
export LD_LIBRARY_PATH=/Users/oyld/work/pghome/lib:$LD_LIBRARY_PATH
export PGHOME=/Users/oyld/work/pghome
export PGDATA=/Users/oyld/work/pgdata

初始化数据库

initdb -D /Users/oyld/work/pgdata

修改配置参数

vim /Users/oyld/work/pgdata/postgresql.conf

启动/停止数据库

pg_ctl -D /Users/oyld/work/pgdata -l /Users/oyld/work/pgdata/logfile1 start
pg_ctl -D /Users/oyld/work/pgdata -l /Users/oyld/work/pgdata/logfile1 stop

连接

psql -p 5432 -d postgres

postgres=# \?
postgres=# create table t1(a int, b text);
postgres=# \dt
postgres=# insert into t1 values(1, 'aa');
postgres=# select * from t1;