Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkYAH-0002Qq-1k for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2019 18:15:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkYAF-00066B-QC for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2019 18:14:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkYAF-000663-D1 for pgsql-admin@lists.postgresql.org; Mon, 08 Jul 2019 18:14:59 +0000 Received: from impout003aa.msg.chrl.nc.charter.net ([47.43.20.27] helo=impout003.msg.chrl.nc.charter.net) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkYA8-0003BS-I1 for pgsql-admin@postgresql.org; Mon, 08 Jul 2019 18:14:58 +0000 Received: from cerberus.crazybean.net ([24.151.10.150]) by cmsmtp with ESMTP id kYA7hYjWNnJPnkYA7hKUeS; Mon, 08 Jul 2019 18:14:51 +0000 Authentication-Results: crazybean.net; none X-Authority-Analysis: v=2.3 cv=aafVYigt c=1 sm=1 tr=0 a=D2HTw/M6/8MmcHighGO7rg==:117 a=D2HTw/M6/8MmcHighGO7rg==:17 a=jpOVt7BSZ2e4Z31A5e1TngXxSK0=:19 a=0o9FgrsRnhwA:10 a=10CFcY03AAAA:8 a=lIcLCrFqTpXdUw6iwvoA:9 a=QEXdDO2ut3YA:10 a=oMMZcS-H_PM7WLhTZ1oA:9 a=oQ6F7YAIXVj-kcZ0:21 a=_W_S_7VecoQA:10 a=zcM2FQi4MiFXQC_z8s7f:22 Received: from [10.25.233.58] (144.121.139.193.lightower.net [144.121.139.193]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id 150ffdee (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Mon, 8 Jul 2019 14:14:50 -0400 (EDT) From: Rui DeSousa Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_74D83C96-A1D0-4537-90CF-1BD7BA676145" Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.11\)) Subject: Re: Does anyone backup directly on Synology NAS using Barman or similar? Date: Mon, 8 Jul 2019 14:14:49 -0400 In-Reply-To: <623997363.20190708183825@am-soft.de> Cc: pgsql-admin@postgresql.org To: =?utf-8?Q?Thorsten_Sch=C3=B6ning?= References: <623997363.20190708183825@am-soft.de> X-Mailer: Apple Mail (2.3445.104.11) X-CMAE-Envelope: MS4wfBbgYE+WrwQTh7u/NlY3NQzha7+ql+gq+OlzDSjOabuNGf81PjWZ4390KPf9E15qIoAkvSv9tQBYuialxXNgJQdKBalXfAYLxIVX3YJwyuT+rrzSoh7d ENhJ/yi6Yz7XZsmXx4WnlW94zi1S+9qqCM2eo2MBc6Xqt9vBN5FPP8+2FmLm47T82x+0JGERla/cEM204zEza2vk9rU0Yy7FSaul0zsD9BGmrMAkwdx0pf08 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_74D83C96-A1D0-4537-90CF-1BD7BA676145 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On Jul 8, 2019, at 12:38 PM, Thorsten Sch=C3=B6ning = wrote: >=20 > Hi all, >=20 > 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?=20 > 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. >=20 Here=E2=80=99s 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-ba= sh/ = --Apple-Mail=_74D83C96-A1D0-4537-90CF-1BD7BA676145 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

On Jul 8, 2019, at 12:38 PM, Thorsten Sch=C3=B6ning <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=E2=80=99s 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-bas= e-Backup-bash/


= --Apple-Mail=_74D83C96-A1D0-4537-90CF-1BD7BA676145--