PostgreSQL Master-Slave configuration

master:10.0.1.114

slaver:10.0.1.116

One, yum installation 80310285

Second, the master-slave configuration

1. Master data Configuration (10.0.1.114)

1.1 Initialization

　　

1.2 Starting PostgreSQL

Systemctl Start postgresql-9.6

　　

1.3 Switch to Postgres User (install to build Default user)

[Email protected] data]# su-postgres  last Login: 35 month 09:19:49 UTC 2018pts/0    -bash-4.2$-bash-4.2$ psql Enter Database    postgres=#

　　

1.4 Create an account and authorize

postgres=# Create role account name login replication encrypted password ' password ';

　　

1.5 Modify the/var/lib/pgsql/9.6/data/pg_hba.conf configuration file.

# IPV4 Local connections:  host    all             127.0.0.1/32            ident  # Add the  following  host    Replication     repl            10.0.1.0/24             MD5  host    all             repl            10.0.1.1/24             

　　

1.6 Modifying postgresql.conf

-bash-4.2$ vim postgresql.conf  listen_addresses = ' 10.0.1.114 '     wal_level = hot_standby  #热备模式  Max _wal_senders= 6 #可以设置最多几个流复制链接, almost a few from, set how much  wal_keep_segments = 10240  #重要配置   wal_send_timeout = 60s   max_connections = #从库的 max_connections to greater than main library  Archive_mode = on #允许归档   archive_command = ' cp%p/url/pat H%f '   #根据实际情况设置  

　　

Third, from the database configuration

1. Switch to Postgres

[Email protected] data]# Su-postgres  

　　

2, copy master configuration related files.

-bash-4.2$ rm-rf/var/lib/pgsql/9.6/data/*  -bash-4.2$ pg_basebackup-h 10.0.1.114-u repl-d/var/lib/pgsql/9.6/ Data-x stream-p       -bash-4.2$ cp/usr/pgsql-9.6/share/recovery.conf.sample/var/lib/pgsql/9.6/data/recovery.conf  

　　

3. Modify the Recovery.conf file

Standby_mode =  on primary_conninfo = ' host=10.0.1.114 port=5432 user=master created user name password= ' password '  trigger_file = '/var/lib/pgsql/9.6/data/trigger.kenyon '    #主从切换时后的触发文件  recovery_target_timeline = ' latest '  

　　

PostgreSQL Master-Slave configuration