Re: Add a different archive_command example for Linux / Unix

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: gparc(at)free(dot)fr
Cc: gparc <gparc(at)online(dot)fr>, pgsql-docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Add a different archive_command example for Linux / Unix
Date: 2024-02-08 21:54:29
Message-ID: ZcVNlVIEa5BOpmdE@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Greetings,

* gparc(at)free(dot)fr (gparc(at)free(dot)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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message gparc 2024-02-09 09:06:28 Re: Add a different archive_command example for Linux / Unix
Previous Message gparc 2024-02-08 14:10:35 Re: Add a different archive_command example for Linux / Unix