Subject: Re: Bad recovery: no pg_xlog/RECOVERYXLOG
To: Stephen Frost <sfrost@snowman.net>
Cc: pgsql-admin@postgresql.org
References: <d90474b1-6913-f3ff-d224-73fd931cdd98@cahoots.pl>
 <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>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Message-ID: <c37a48d3-05f0-9041-a586-fe7591c9154c@catalyst.net.nz>
Date: Thu, 2 Nov 2017 17:23:07 +1300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.4.0
MIME-Version: 1.0
In-Reply-To: <20171101221807.GW4628@tamriel.snowman.net>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 02/11/17 11:18, Stephen Frost wrote:

> Not having
> a way to reliably sync the WAL files copied by archive command to disk,
> in particular, really is an issue, it's not some feature, it's a
> requirement of a functional PG backup system.  The other requirement for
> a functional PG backup system is a check to verify that all of the WAL
> for a given backup has been archived safely to disk, otherwise the
> backup is incomplete and can't be used.
>
>

Funnily enough, the original poster's scripts were attempting to address 
(at least some) of this: he was sending stuff to swift, so if he got a 
ok return code then it is *there* - that being the whole point of a 
distributed, fault tolerant object store (I do swift support BTW).

I wonder if you are seeing this discussion in the light of folk doing 
backups to unreliable storage locations (e.g: the same server, NFS etc 
etc), then sure I completely agree with what you are saying (these issue 
impact backup designs no matter what tool is used to write them).

Best wishes

Mark


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin