Postgresql Stream 配置

概述一、安装配置数据库（master\slave） 系统信息： 192.168.1.20 gserver20(master) 192.168.1.21 gserver21(slave) 1.建立目录 mkdir /opt/pgsql-9.3.1 mkdir /opt/pgdata/main mkdir /opt/pgdata/archive 2.建立postgres用户 adduser postgre

一、安装配置数据库（master\slave）
系统信息：

192.168.1.20gserver20(master)
192.168.1.21gserver21(slave)

1.建立目录

mkdir/opt/pgsql-9.3.1
mkdir/opt/pgdata/main
mkdir/opt/pgdata/archive

2.建立postgres用户

adduserpostgres
chown-Rpostgres/opt/pgdata/

3.设置密码
#passwdpostgres
Changingpasswordforuserpostgres.
Newpassword:
BADPASSWORD:itistoosimpListic/systematic
BADPASSWORD:istoosimple
Retypenewpassword:
passwd:allauthenticationtokensupdatedsuccessfully.
#

4.设置用户环境变量

su-postgres
vi.bash_profile

#.bash_profile
#Getthealiasesandfunctions
if[-f~/.bashrc];then
.~/.bashrc
fi
#Userspecificenvironmentandstartupprograms
exportPGHOME=/opt/pgsql-9.3.1
exportPGDATA=/opt/pgdata/main
exportPATH=$PGHOME/bin:$PATH:$HOME/bin
exportLD_liBRARY_PATH=$PGHOME/lib:$LD_liBRARY_PATH

[postgres@gserver21~]$

5.安装postgresql
./configure--prefix=/opt/pgsql-9.3.1
gmake
su
gmakeinstall

二、配置streamreplication
1.master
1)切换到postgres用户
$su-postgres
2）初始化数据库
$initdb
3）配置pg_hba.conf
在#IPv4localconnections下面添加一行，设置Postgresql的访问及其权限
hostallall192.168.111.1/24trust
在#replicationprivilege.下面添加一行，设置replication用户及权限
hostreplicationpostgres192.168.111.1/24trust
4）配置postgresql.conf
配置监听，修改Listen_addresses='localhost'
Listen_addresses='*'#whatIPaddress(es)toListenon;
配置PrimaryReplication参数
wal_level=hot_standby
max_wal_senders=5
wal_keep_segments=32
archive_mode=on
archive_command='cp%p/opt/pgdata/archive/%f</dev/null'
"/opt/pgdata/archive"是Replication的archive的存储路径。Postgresql会将Replication的WAL保存在"/opt/pgdata/archive"路径下。
5)启动Primary上的Postgresql数据库
$pg_ctlstart
6)在primary上执行以下命令
$psql-c"SELECTpg_start_backup('label',true)"
将Primary的PGDATA目录下的文件，除了postmaster.pID复制到Standby节点的“/opt/pgdata/main”目录下，该目录是Standby节点上的

Postgresql数据库的PGDATA目录。
$rsync-a${PGDATA}/postgres@192.168.1.21:/opt/pgdata/main--excludepostmaster.pID
$psql-c"SELECTpg_stop_backup()"
2.standby
su-postgres
PGDATA=/opt/pgdata/main
Standby节点的PGDATA路径就是Primary节点的PGDATA的副本
1）配置postgresql.conf
设置hot_standby为
hot_standby=on
2）编辑recovery.conf，文件路径为$(PGDATA)/recovery.conf，内容为
---------------------------------------------------------------------------------------------------------------------------
#SpecifIEswhethertostarttheserverasastandby.Instreamingreplication,
#thisparametermusttobesettoon.
standby_mode='on'
#SpecifIEsaconnectionstringwhichisusedforthestandbyservertoconnect
#withtheprimary.
primary_conninfo='host=192.168.1.20port=5432user=postgres'
#SpecifIEsatriggerfilewhosepresenceshouldcausestreamingreplicationto
#end(i.e.,failover).
trigger_file='/opt/pgdata/trigger'
#SpecifIEsacommandtoloadarchivesegmentsfromthewalarchive.If
#wal_keep_segmentsisahighenoughnumbertoretaintheWALsegments
#requiredforthestandbyserver,thismaynotbenecessary.But
#alargeworkloadcancausesegmentstoberecycledbeforethestandby
#isfullysynchronized,requiringyoutostartagainfromanewbasebackup.
restore_command='cp/opt/pgdata/archive/%f%p'

--------------------------------------------------------------------------------------------------------------------------3)复制pg_xlog下的所有文件到/opt/pgdata/archive目录下cd/opt/pgdata/main/pg_xlogmv*../../archive4)启动standby节点，完成Replicationpg_ctlstart3.完成StreamingReplication配置。

总结

以上是内存溢出为你收集整理的Postgresql Stream 配置全部内容，希望文章能够帮你解决Postgresql Stream 配置所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。