From: Rui DeSousa <rui@crazybean.net>
To: Thorsten Schöning <tschoening@am-soft.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Does anyone backup directly on Synology NAS using Barman or similar?
Date: Mon, 8 Jul 2019 14:14:49 -0400
Message-ID: <EBA02429-FB5F-4CF1-9FB1-2CD0DA05EC1E@crazybean.net> (raw)
In-Reply-To: <623997363.20190708183825@am-soft.de>
References: <623997363.20190708183825@am-soft.de>
> On Jul 8, 2019, at 12:38 PM, Thorsten Schöning <tschoening@am-soft.de> wrote:
>
> Hi all,
>
> Recently things have changed a bit additionally, since we are backing
> Postgres up directly on a Synology NAS onto that NAS now. So there's
> no additional fully blown Linux/Windows host copying things to some
> share or stuff, but instead the NAS itself executes scripts taking
> care of pg_start_backup, copying things around etc. simply using SSH.
What is PostgreSQL disk topology -- file system, local storage or using the NAS? Have you looked into snapshots?
> I already read that the exclusive backups we take now are deprecated
> anyway[1] and that shared backups need an open session during the time
> of the backup, which makes custom scripts additionally difficult.
>
Here’s an example of a bash script using a pipe to issue the non exclusive start/stop backup command:
https://www.commandprompt.com/blog/postgresql-non-exclusive-base-Backup-bash/ <https://www.commandprompt.com/blog/postgresql-non-exclusive-base-Backup-bash/;
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: rui@crazybean.net, tschoening@am-soft.de
Subject: Re: Does anyone backup directly on Synology NAS using Barman or similar?
In-Reply-To: <EBA02429-FB5F-4CF1-9FB1-2CD0DA05EC1E@crazybean.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