From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it>, Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com> |
Subject: | Re: Updated backup APIs for non-exclusive backups |
Date: | 2018-11-26 05:44:33 |
Message-ID: | 62e871d1f7908b74b14c6083ec9d1e0a56f28eb1.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, 2018-11-25 at 22:01 +0100, Magnus Hagander wrote:
[about managing backups from pre- and post-file-system-backup scrips]
> I agree with your point that it's not an uncommon thing to need. If a good solution
> for it can be proposed that requires the exclusive backup interface, then I wouldn't
> be against un-deprecating that. But that's going to require a lot more than just a
> documentation change, IMHO. What could perhaps be handled with a documentation change,
> however, is to document a good way for this type of setup to use the new interfaces.
Good point, and it puts the ball in my court :^)
> > I'm arguing on behalf of users that run a few databases, want a simple backup
> > solution and are ready to deal with the shortcomings.
>
> Those that want a simple backup solution have one -- pg_basebackup.
>
> The exclusive backup API is *not* simple. It is convenient, but it is not simple.
>
> Actually having a simple API that worked with the pre/post backup scripts, that
> would be an improvement that we should definitely want!
Right; unfortunately it is not simple to come up with one that doesn't exhibit
the problems of the existing exclusive backup.
Perhaps it's theoretically impossible. The goal is to disambiguate what a file
system backup sees in backup mode and what the startup process sees after a crash
in backup mode, and I can't see how that could be done.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | myungkyu.lim | 2018-11-26 05:48:39 | RE: [Todo item] Add entry creation timestamp column to pg_stat_replication |
Previous Message | Michael Paquier | 2018-11-26 05:43:02 | Handling of REGRESS_OPTS in MSVC for regression tests |