From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | David Steele <david(at)pgmasters(dot)net>, 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-12-12 05:58:58 |
Message-ID: | 1bb48329781d508704ce87c72f67e78785d78bef.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 2018-12-11 at 23:43 -0500, David Steele wrote:
> > > > [about managing backups from pre- and post-file-system-backup scrips]
> > I have come up with some sample code here:
> > https://github.com/cybertec-postgresql/safe-backup
> >
> > This just uses bash and psql.
> > Does that look reasonably safe?
> >
> > It's probably too big to be introduced into the documentation, but maybe
> > we could add it to the Wiki.
>
> My bash-fu is not all that great, but it seems to me you could do this
> all in one script and forgo the table entirely. Just do the file copy
> at about line 60 in pgpre.sh.
>
> It does look workable to me, just wonder if it could be simpler.
Thanks for having a look. Yes, it looks appallingly complicated.
Sure, if I knew there was a file to write, and I knew where to write
it, I could do it in the "pre" script. But since I have no idea how the
actual backup is performed and how the "backup_label" file is going to
be saved, I thought it best to return the information to the caller and
persist it somewhere, and only the "post" script can actually return the
information.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Surafel Temesgen | 2018-12-12 06:05:31 | Re: COPY FROM WHEN condition |
Previous Message | Michael Paquier | 2018-12-12 05:55:17 | Re: Making WAL receiver startup rely on GUC context for primary_conninfo and primary_slot_name |