0
votes
Vote UpVote

Postgresql Streaming Replication recipe

Leonardo's blog – This is a quick recipe for PostgreSql 9.x Streaming Replication configuration between a Master and Slave servers based on https://www.howtoforge.com/tutorial/postgresql-replication-on-ubuntu-15-04/Master: IP 192.168.1.249Everything should be done as postgres user.psql CREATE USER replica REPLICATION LOGIN ENCRYPTED PASSWORD 'replicauser@';# ctrl + d to exitcd /etc/postgresql/9.4/mainvim postgresql.conflisten_addresses = 'localhost,192.168.1.248'wal_level = hot_standbycheckpoint_segments = 8archive_mode = onarchive_command = 'cp -i %p /var/lib/postgresql/9.4/main/archive/%f'max_wal_senders = ...
Favorite? Off-Topic? Leonardo M. Ramé @ 2017-07-19 16:13

Statistics

Visits: 520
Votes: 0
Favorites: 0
Off-Topic: 0

Visits by Source

User Actions

Users who voted for this posting

Subscribe:
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News

Sponsor

 
Please login or register to use this functionality.
(click on this box to dismiss)