PostgreSQL: Database replication

############## Master: psql -c "CREATE USER rep REPLICATION LOGIN CONNECTION LIMIT 1 ENCRYPTED PASSWORD 'yourpassword';" #//archivo /etc/postgresql/9.5/main/pg_hba.conf host replication rep IP_address_of_slave/32 md5 #//archivo /etc/postgresql/9.5/main/postgresql.conf listen_addresses = 'localhost,IP_address_of_THIS_host' wal_level = 'hot_standby' archive_mode = on archive_command = 'cd .' max_wal_senders = 1 hot_standby = on service postgresql restart ############### Slave: service postgresql stop #//archivo /etc/postgresql/9.5/main/pg_hba.conf host replication rep IP_address_of_master/32 md5 #//archivo /etc/postgresql/9.5/main/postgresql.conf listen_addresses = 'localhost,IP_address_of_THIS_host' wal_level = 'hot_standby' archive_mode = on archive_command = 'cd .' max_wal_senders = 1 hot_standby = on ################## Master: psql -c "select pg_start_backup('initial_backup');" rsync -cva --inplace --exclude=*pg_xlog* /var/lib/postgresql/9.5/main/ slave_IP_address:/var/lib/postgresql/9.5/main/ psql -c "select pg_stop_backup();" ################### Slave: cd /var/lib/postgresql/9.5/main/recovery.conf standby_mode = 'on' primary_conninfo = 'host=master_IP_address port=5432 user=rep password=yourpassword' trigger_file = '/tmp/postgresql.trigger.5432' ##Cuando queramos poner este como Master por falla del Master original, se crea este archivo y ya. service postgresql start ## ver si hay problema: less /var/log/postgresql/postgresql-9.5-main.log