Disable Streaming Replication without restarting either master or slave

From: Samba <saasira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Disable Streaming Replication without restarting either master or slave
Date: 2012-05-29 10:18:47
Message-ID: CAKgWO9+yhTMGdFV7ymxejdeHqS-_miKXjFJt8dLLJR=Y5crxjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it possible stop/disable streaming replication without stopping or
restarting either master or slave servers?

Since stopping or restarting the postgres servers would involve complete
invalidation of the connection pool [Java/JEE app server pool] that may
take a few minutes before the application becomes usable, it would be great
if there is a way we can disable replication [for maintenance reasons like
applying patches or upgrades, etc].

Thanks and Regards,
Samba

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-05-29 12:58:50 Re: Export and import from one postgres server to another
Previous Message Craig Ringer 2012-05-29 09:03:00 Re: main log encoding problem