Re: dropdb breaks replication? - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: dropdb breaks replication?
Date
Msg-id CAP=oouGTJuthjJOeaj-Px1QKbvJtAaaxvaViNFdCNwmz+fLp6Q@mail.gmail.com
Whole thread Raw
In response to dropdb breaks replication?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: dropdb breaks replication?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
On Wed, Oct 31, 2012 at 10:32 AM, Edson Richter
<edsonrichter@hotmail.com> wrote:
> I've two PostgreSQL 9.1.6 running on Linux CentOS 5.8 64bit.
> They are replicated asynchronously.
>
> Yesterday, I've dropped a database of 20Gb, and then replication has broken,
> requiring me to manually synchronize both servers again.
>
> It is expected that dropdb (or, perhaps, createdb) break existing
> replication between servers?

How did you determine that replication was broken, and how did you
manually synchronize the servers?  Are you certain that replication
was working prior to dropping the database?


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: dropdb breaks replication?
Next
From: Edson Richter
Date:
Subject: Re: dropdb breaks replication?