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

From John R Pierce
Subject Re: dropdb breaks replication?
Date
Msg-id 50917130.2050506@hogranch.com
Whole thread Raw
In response to Re: dropdb breaks replication?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
On 10/31/12 11:34 AM, Edson Richter wrote:
> Sorry for the portguese text. Yes, your assumption is correct: WAL
> segment has been excluded before being able to replicate.
> I keep 80 WAL segments, but I was wondering if a drop database is
> being logged: it's just so fast, I thought it wasn't logged.
> And what is the purpose to log (and replicate) the database drop, if
> you will not be able to recover it - IMHO, dropdb should be replicated
> as "database deactivation" or something more or like that...


WAL is not a 'redo' log like Oracle uses.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: dropdb breaks replication?
Next
From: craig@gtek.biz
Date:
Subject: Unable to do a mailing list proper search