postgresql9.2.24安装

1、yum安装

 

yum install -y postgresql-server postgresql-contrib

 

2、初始化

 

postgresql-setup initdb

 

3、挂载数据盘

 

ln -s /data/pgsql /var/lib/pgsql

chown -R postgres:postgres pgsql

 

4、修改配置文件

pg_hba.conf

 

local   all             all                                     peer
host    all             all             0.0.0.0/0               md5
host    all             all             ::1/128                 ident

 

postgresql.conf

listen_addresses = "*"
max_connections = 200
shared_buffers = 3000MB
work_mem = 100MB
maintenance_work_mem = 1000MB
effective_cache_size = 6000MB
constraint_exclusion = partition
logging_collector = on
log_filename = "postgresql-%a.log"
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
log_timezone = "PRC"
datestyle = "iso, mdy"
timezone = "PRC"
lc_messages = "en_US.UTF-8"
lc_monetary = "en_US.UTF-8"
lc_numeric = "en_US.UTF-8"
lc_time = "en_US.UTF-8"
default_text_search_config = "pg_catalog.english"


#新增
wal_level=hot_standby
archive_mode=on
archive_command = "cp %p /var/lib/postgresql/pg_bak/%f"
max_wal_senders=4

5、启动

systemctl start postgresql

systemctl enable postgresql