1.Install PostgreSql9.3
A:yum Install
Copy Repository to:/ETC/YUM/YUM.REPOS.D
Yum-y Install Postgresql93-server Postgresql93-contrib--skip-broken
Yum Install http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-redhat95-9.5-2.noarch.rpm
sudo yum install postgresql95-server postgresql95-contrib
2.Install Postgres
yum -y install postgresql93-server postgresql93-contrib
3.Master 配置
1.创建PG Data Dir
mkdir –p /opt/postgresql/datamkdir –p /opt/postgresql/data/archive chmod /opt/postgresql/datasudochown postgres:postgres/opt/postgresql/data
2. Set profile
sudo vi /etc/profileexport PATH=/usr/pgsql-9.3/Bin: $PATHexport PGDATA=/opt/ postgresql/data/su –postgresvi ~/. Bash_profileexport PATH=/usr/pgsql-9.3 /Bin: $PATHexport PGDATA=/opt/postgresql/data/
3.InitDB for Master
su ---encoding=utf-8 --username=postgres--pwprompt--pgdata=/opt/postgresql/data/
4.配置文件
VI $PGDATA _home/pg_hba.conf
(replace"Ident"With"MD5") (#IPv4 local connections) host all192.168.1.1/ -MD5 (replace ident or peer with Trust) (#"Local"Is forUnix domain socket connections only) Local all-trust# allow REPL Ication connections from localhost, by a user with the# replication privilege. #local Replication Postgres Peer#host Replication Postgres127.0.0.1/ +identhost replication Postgres192.168.1.1/ -Trust
VI $PGDATA _home/postgresql.conf
' * '
5432
Wal_level = Hot_standby
Max_wal_senders = 5
Wal_keep_segments = 32
Archive_mode = On
Archive_command = ' cp%p/opt/postgresql/data/%f </dev/null '
checkpoint_segments = 8
5. Start Master DB
su --d/opt/postgresql/data/-l logfile start
pg_ctl– D/var/lib/pgsql/9.3/data-"CREATE USER postgres REPLICATION LOGIN ENCRYPTED PASSWORD ' Conversant '; "
$psql
Postgres=# alter user postgres with password 'conversant';
4.Slave
4.1 Install Postgres
4.2 Configure Profile
4.3 Copy master data
Su192.168. 1.12 -d/opt/postgresql/data-u replicator-p-v-x
4.4 Configuration
VI $PGDATA _home/postgresql.conf
' * ' ==3 8 8
VI $PGDATA _home/recovery.conf
sudo su - CP /usr/pgsql-9.3 /share/ Recovery.conf.sample/opt/postgresql/data/chown Postgres:postgres recovery.conf.sample mv recovery.conf.sample recovery.conf
VI'host=192.168.1.12 port=5432 user=replicator password=conversant ' /opt/postgressql/data/trigger 'on'
5. Open Firewall 5432 Port
$sudo5432 –J ACCEPT
$sudo /etc/rc.d/init.d/iptables Save
$sudo /etc/init.d/iptables status
6. Start slave
su --d/opt/postgresql/data/-L logfile Start
1. startpg_ctl-d/opt/postgresql/data/-l/opt/postgresql/data/logfile Start2. stoppg_ctl-d/opt/postgresql/data/-l/opt/postgresql/data/logfile--mode=fast stop3. restartpg_ctl-d/opt/postgresql/data/-l/opt/postgresql/data/logfile Restart
7. List of issues:
1.error Check sum:
Fix Error:yum primary.sqlite.bz2: [Errno-3] Error performing checksum Trying other mirror.
Enabled=0
2.GPG Key retrieval failed: [Errno 5] OSError
[Errno 2] No such file or directory: '/etc/pki/rpm-gpg/rpm-gpg-key-pgdg-93 '
Gpgcheck=0
Postgresql Master/slaver