From: Stephen Frost <sfrost@snowman.net>
To: gparc@free.fr
Cc: gparc <gparc@online.fr>
Cc: pgsql-docs <pgsql-docs@lists.postgresql.org>
Subject: Re: Add a different archive_command example for Linux / Unix
Date: Thu, 8 Feb 2024 16:54:29 -0500
Message-ID: <ZcVNlVIEa5BOpmdE@tamriel.snowman.net> (raw)
In-Reply-To: <705658729.361810855.1707401435362.JavaMail.zimbra@free.fr>
References: <170738227967.3279716.16428042124969376330@wrigleys.postgresql.org>
<ZcTCTQKLmJBYUwHF@tamriel.snowman.net>
<705658729.361810855.1707401435362.JavaMail.zimbra@free.fr>
Greetings,
* gparc@free.fr (gparc@free.fr) wrote:
> Thanks Stephen for your detailed reply and broad perspective.
> But I see the cp example command used **as is** most of the time.
In those cases- how would changing it to be a dd command be helpful?
The directory still wouldn't be fsync'd and there's a very good chance
that the rest of the documentation isn't followed or understood either,
leading almost certainly to broken backup setups. This wouldn't be the
only issue in any case, to be sure.
This comes back to my earlier suggestion that perhaps we should just
change it to something like:
archive_command = 'backup_tool %p /mnt/server/archivedir/%f'
and not talk about specific tools that exist but don't perform in the
manner we actually expect from an archive command that we're using. We
already make it pretty clear to anyone who knows the tools mentioned
that the 'example' command won't work, if you read everything under that
section.
Alternatively, we could actually document the tools we're aware of that
do work and which do strive, at least, to try and be good backup tools
and good archive commands for PG. That would certainly be a service to
our users and might result in far fewer misconfigured systems using the
examples because they thought (despite the explicit note in our
documentation) that they were recommendations.
Thanks,
Stephen
Attachments:
[application/pgp-signature] signature.asc (832B, ../ZcVNlVIEa5BOpmdE@tamriel.snowman.net/2-signature.asc)
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, gparc@free.fr, gparc@online.fr, pgsql-docs@lists.postgresql.org
Subject: Re: Add a different archive_command example for Linux / Unix
In-Reply-To: <ZcVNlVIEa5BOpmdE@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