[pgpool-general: 1249] Re: Dropping template1 through PGPool not possible

Philip Hofstetter phofstetter at sensational.ch
Fri Dec 7 18:58:31 JST 2012


On Fri, Dec 7, 2012 at 10:37 AM, Maik Kulbe <maik.kulbe+pgpool at gmail.com> wrote:

>> Unfortunately since DROP DATABASE cannot execute in a transaction
>> block and pgpool does not start an explicit transaction, DROP DATABASE
>> may causes inconsistency among backends. I don't think checking DROP
>> DATABASE can be executed beforehand is easy: there's always a window
>> between at the time check and actual execution of DROP DATABASE.
> So is there any recommended way to execute such statements that PGPool can't
> handle that well?

just execute them on the master and have replication take care of them.


More information about the pgpool-general mailing list