PostgreSQL源码安装和配置

tar xjf postgresql-9.5.1.tar.bz2
cd postgresql-9.5.1
# 编译安装，加上python和perl两个过程语言选项，一般需要
./configure --prefix=/usr/local/pgsql --with-perl--with-python
make
make install

useradd postgres
passwd postgres

export PATH=/usr/local/pgsql/bin:$PATH;
export LD_LIBRARY_PATH=/usr/local/pgsql/lib
export PGDATA=/data/pgdata
export PGPORT=6432

initdb

cd postgresql-9.5.1/contrib.
make
make install

pg_ctl start -D $PGDATA

pg_ctl stop -D $PGDATA -m [Shutdownmodes]
Shutdown modes are:
 smart       quit after all clientshave disconnected
 fast        quit directly, withproper shutdown
 immediate   quit without completeshutdown; will lead to recovery on restart

# vi postgresql.conf
listen_addresses = '*'
port = 6432
# 重启数据库生效

logging_collector = on  #打开日志收集
log_directory = 'pg_log' #日志目录，一般使用默认值
log_filename ='postgresql-%Y-%m-%d_%H%M%S.log #日志文件名
log_truncate_on_rotation = off #不循环覆盖
log_rotation_age = 1d #每天一个文件
log_rotation_size = 0 #不限制大小
# pg_ctl reload 生效

shared_buffers = 256MB #共享内存大小，用于共享数据块
work_mem = 64MB #单个sql执行关联及排序使用到的内存，sql执行完后内存释放
# pg_ctl reload 生效

[postgres@mas01 ~]$ psql
psql (9.5.1)
Type "help" for help.
 postgres=#