PostgreSQL: Database replication

##src: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps#configure-the-master-server ############## Master: psql -c "CREATE USER rep REPLICATION LOGIN CONNECTION LIMIT 1 ENCRYPTED PASSWORD 'yourpassword';" #//at file /etc/postgresql/9.5/main/pg_hba.conf host replication rep IP_address_of_slave/32 md5 #//at file /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 #//at file /etc/postgresql/9.5/main/pg_hba.conf host replication rep IP_address_of_master/32 md5 #//at file /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 ## if no problem: less /var/log/postgresql/postgresql-9.5-main.log
Postgres Database streammed replication

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.