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;