From: Stephen Frost <sfrost@snowman.net>
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: pgsql-admin@postgresql.org
Subject: Re: Bad recovery: no pg_xlog/RECOVERYXLOG
Date: Thu, 2 Nov 2017 07:11:41 -0400
Message-ID: <20171102111141.GZ4628@tamriel.snowman.net> (raw)
In-Reply-To: <94a943ac-8b63-5cfc-9d48-22b7193b9766@catalyst.net.nz>
References: <1070071508952614@web46j.yandex.ru>
<ae7f2ee9-97ff-267e-b6dc-9399250a9314@cahoots.pl>
<20171030154706.GE4628@tamriel.snowman.net>
<7966ee9e-2241-eced-4639-e32c157b915a@catalyst.net.nz>
<20171031114756.GP4628@tamriel.snowman.net>
<2e3453d3-da6f-88af-05ec-7530e7f60547@catalyst.net.nz>
<20171101122847.GS4628@tamriel.snowman.net>
<4efa2769-78c4-7bf0-5c33-0cf2d942ce74@catalyst.net.nz>
<20171101221807.GW4628@tamriel.snowman.net>
<94a943ac-8b63-5cfc-9d48-22b7193b9766@catalyst.net.nz>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Mark,
* Mark Kirkwood (mark.kirkwood@catalyst.net.nz) wrote:
> Ok, that is interesting. In my experience, provided the a)
> construction you are using in archive_command correctly reports
> success/failure, and b) you have some monitoring that checks for
> archive failure then that requirement of you having the required
> logs will be fine. Finally that c) your pg_basebackup concoction
> properly checks return codes then you are fine.
>
> All these are reasonably straightforward to implement via shell.
Sure, that'll work much of the time, but that's about like saying that
PG could run without fsync being enabled much of the time and everything
will be ok. Both are accurate, but hopefully you'll agree that PG
really should always be run with fsync enabled.
> Also, if what you are suggesting were actually the case, almost
> everyone's streaming replication (and/or log shipping) would be
> broken all the time.
No, again, this isn't an argument about if it'll work most of the time
or not, it's about if it's correct. PG without fsync will work most of
the time too, but that doesn't mean it's actually correct.
> With respect to 'If I would like to develop etc etc..' - err, all I
> was doing in this thread was helping the original poster make his
> stuff a bit better - I'll continue to do that.
Ignoring the basic requirements which I outlined isn't helping him get
to a reliable backup system.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, mark.kirkwood@catalyst.net.nz
Subject: Re: Bad recovery: no pg_xlog/RECOVERYXLOG
In-Reply-To: <20171102111141.GZ4628@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox