On Tue, Nov 1, 2011 at 1:35 PM, Samba <saasira@xxxxxxxxx> wrote: > > But how do I disable streaming replication, with the effect that both WAL > sender on master and WAL receiver on slave gets stopped? Similarly, when I > enable streaming replication, the WAL sender and WAL receiver processes > would need to be started. > There is no such thing that i know. but the effect is the same as if you shutdown the standby. The problem is that if you have a standby server and stop walsender and walreceiver. what happens when you start them again: 1) there would be accumalated work (wal records to send and to receive), so it will take some time until standby catch up 2) what if the wal segment that was being used when you stopped walsender is reused in master before walsender is reactivated? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
