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 1hkWez-0007YM-0h for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2019 16:38:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkWex-0000K5-LG for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2019 16:38:35 +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 1hkWex-0000Jy-90 for pgsql-admin@lists.postgresql.org; Mon, 08 Jul 2019 16:38:35 +0000 Received: from mail.am-soft.de ([83.218.36.120]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkWeu-0002Ig-D3 for pgsql-admin@postgresql.org; Mon, 08 Jul 2019 16:38:34 +0000 Received: from mail.am-soft.de (localhost [127.0.0.1]) by mail.am-soft.de (Postfix) with ESMTP id 7BE8716F20C6 for ; Mon, 8 Jul 2019 18:38:28 +0200 (CEST) Received: from tschoening-nb.fritz.box (dslb-188-102-129-135.188.102.pools.vodafone-ip.de [188.102.129.135]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-SHA256 (128/128 bits)) (No client certificate requested) by mail.am-soft.de (Postfix) with ESMTPSA id 52CDE16F20C4 for ; Mon, 8 Jul 2019 18:38:27 +0200 (CEST) Date: Mon, 8 Jul 2019 18:38:25 +0200 From: =?utf-8?Q?Thorsten_Sch=C3=B6ning?= Organization: AM-SoFT GmbH IT-Systeme Message-ID: <623997363.20190708183825@am-soft.de> To: pgsql-admin@postgresql.org Subject: Does anyone backup directly on Synology NAS using Barman or similar? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-AV-Checked: ClamAV using ClamSMTP List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, we are reviewing our current backup process based on the low level pg_start_backup and pg_stop_backup using the exclusive approach. And thanks to many of you caring about my former questions, what we currently do seems to be broken. :-) I already had switching to e.g. Barman in mind for quite some time, but simply couldn't make it yet. 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. 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. Does anyone use a Synology NAS as well and runs complex software like Barman or alternatives directly on the NAS? I would like to read about how to set things up, experiences about how smooth things run over a longer period of time, how it's handled during upgrading the OS of the NAS itself and stuff. I did some research on that topic myself of course but the only things I found where using the NAS as storage only, while the software actually executed somewhere else. I would just like to know if it's a real option to not need an additional host or if that would be a waste of time most likely. Thanks again for your insights! [1]: https://www.cybertec-postgresql.com/en/exclusive-backup-deprecated-wha= t-now/# Mit freundlichen Gr=C3=BC=C3=9Fen, Thorsten Sch=C3=B6ning --=20 Thorsten Sch=C3=B6ning E-Mail: Thorsten.Schoening@AM-SoFT.de AM-SoFT IT-Systeme http://www.AM-SoFT.de/ Telefon...........05151- 9468- 55 Fax...............05151- 9468- 88 Mobil..............0178-8 9468- 04 AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB 207 694 - Gesch=C3=A4ftsf=C3=BChrer: Andreas Muchow