From: Stephen Frost <sfrost@snowman.net>
To: Gunnar Nick Bluth <gunnar.bluth@pro-open.de>
Cc: pgsql-docs@postgresql.org
Subject: Re: Missing important information in backup.sgml
Date: Wed, 16 Nov 2016 09:36:51 -0500
Message-ID: <20161116143651.GC13284@tamriel.snowman.net> (raw)
In-Reply-To: <cec57bd3-3742-9bae-a76f-f3414dcf135e@elster.de>
References: <cb648ec1-5212-60c5-b73a-9572d21b2ae9@elster.de>
<cec57bd3-3742-9bae-a76f-f3414dcf135e@elster.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
Gunnar, all,
* Gunnar "Nick" Bluth (gunnar.bluth.extern@elster.de) wrote:
> Am 16.11.2016 um 11:37 schrieb Gunnar "Nick" Bluth:
> > I ran into this issue (see patch) a few times over the past years, and
> > tend to forget it again (sigh!). Today I had to clean up a few hundred
> > GB of unarchived WALs, so I decided to write a patch for the
> > documentation this time.
>
> Uhm, well, the actual problem was a stale replication slot... and
> tomatoes on my eyes, it seems ;-/. Ashes etc.!
>
> However, I still think a warning on (esp. rsync's) RCs >= 128 is worth
> considering (see -v2 attached).
Frankly, I wouldn't suggest including such wording as it would imply
that using a bare rsync command is an acceptable configuration of
archive_command. It isn't. At the very least, a bare rsync does
nothing to ensure that the WAL has been fsync'd to permanent storage
before returning, leading to potential data loss due to the WAL
segment being removed by PG before the new segment has been permanently
stored.
The PG documentation around archive command is, at best, a starting
point for individuals who wish to implement their own proper backup
solution, not as examples of good practice for production environments.
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-docs@postgresql.org
Cc: sfrost@snowman.net, gunnar.bluth@pro-open.de
Subject: Re: Missing important information in backup.sgml
In-Reply-To: <20161116143651.GC13284@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