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

From Greg Williamson
Subject Re: dropdb breaks replication?
Date
Msg-id 1351723677.94106.YahooMailNeo@web125905.mail.ne1.yahoo.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
Edson --

>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
serversagain. 
>
>It is expected that dropdb (or, perhaps, createdb) break existing replication between servers?
>


Sorry for the slow response -- as others have indicated, the drop db is probably not the problem. We have one system
thatdrops a several-gig database hourly and the replication has never failed. We see issues on the master with dead
filehandles but the replication itself is rock solid. 

Greg


pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: Re: Delay streaming replication using a paramter
Next
From: "Kevin Burton"
Date:
Subject: role does not exist