On 12/13/19 3:56 AM, Magnus Hagander wrote:
On Fri, Dec 13, 2019 at 9:00 AM Michael Paquier <mich...@paquier.xyz
I think that's a bad idea to put a restriction of this kind. There
are large consumers of 2PC, and everybody needs backups.
You misunderstood me. I certainly didn't mean that people who use 2PC
shouldn't be able to use proper backups -- that would be *terrible*.
I meant disallowing pg_start_backup() in a session that had a prepared
transaction, and disallowing preparing a transaction in a session with
an ongoing backup. They would still work perfectly fine in *other*
parallel sessions.
+1. I think it is reasonable to expect pg_start/stop_backup() to be
performed in its own session without prepared transactions.
+more if this concession keeps other aspects of the code simpler.
--
-David
da...@pgmasters.net
