On Wed, 26 Oct 2016 13:59:02 +0200 Thomas Kellerer <spam_ea...@gmx.net> wrote:
> Bjørn T Johansen schrieb am 26.10.2016 um 13:17: > > I have a database that I would like to replicate in case of hardware > > failure on this server. So I gather I just need a streaming replication > > (warm > > standby?) and I found a howto describing how to set it up, that looks like > > this: > > > > 1. Edit postgresql.conf on the master to turn on streaming replication. > > Change these settings: > > listen_addresses = '*' > > wal_level = hot_standby > > max_wal_senders = 3 > > 2. Edit pg_hba.conf on the master in order to let the standby connect. > > host replication all 192.168.0.2/32 trust > > 3. Edit postgresql.conf on the standby to set up hot standby. Change this > > line: > > hot_standby = on > > 4. Create or edit recovery.conf on the standby to set up replication and > > standby mode. Save a file in the standby's data directory, called > > recovery.conf, with the following lines: > > standby_mode = 'on' > > primary_conninfo = 'host=192.168.0.1' > > 5. Shut down both the master and standby, and copy the files. You want to > > copy most but not all files between the two servers, excluding the > > configuration files and the pg_xlog directory. An example rsync script > > would be: > > rsync -av --exclude pg_xlog --exclude postgresql.conf data/* > > 192.168.0.2:/var/lib/postgresql/data/ > > 6. Start the standby first, so that they can't get out of sync. (Messages > > will be logged about not being able to connect to the primary server, > > that's OK.) > > 7. Start the master. > > > > Is this all that is needed to get a working master - slave replication? (It > > just looks too easy... :) ) > > Yes, that's all. > > In fact 5. could be done withoug shutting down the master using pg_basebackup > > > Do I need to enable archive mode for this to work or? > > No. > > "wal_level = hot_standby" includes that. > > > Ok, thx.. :) BTJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
