Re: pg_dump --snapshot - Mailing list pgsql-hackers

From bricklen
Subject Re: pg_dump --snapshot
Date
Msg-id CAGrpgQ9AgTmFCGGrjM4aKFEq8W4ZCLe_SaQAhxKVdSt_e5aXdw@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump --snapshot  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers

On Tue, May 7, 2013 at 10:02 AM, Dimitri Fontaine <dimitri@2ndquadrant.fr> wrote:
Rather than take some locks, you can now prevent the database objects
from changing with an event trigger. pg_dump could install that event
trigger in a preparing transaction, then do its work as currently, then
when done either remove or disable the event trigger.

All the event trigger has to do is unconditionnaly raise an exception
with a message explaining that no DDL command is accepted during when a
dump is in progress.


I'm thinking of a case where a hot standby is executing a pg_dump and DDL is issued on the master -- would that cause any unexpected problems on the hot standby?

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: corrupt pages detected by enabling checksums
Next
From: Jeff Davis
Date:
Subject: Re: corrupt pages detected by enabling checksums