pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thorsten Schöning <tschoening@am-soft.de>
To: pgsql-admin@postgresql.org
Subject: Does anyone backup directly on Synology NAS using Barman or similar?
Date: Mon, 8 Jul 2019 18:38:25 +0200
Message-ID: <623997363.20190708183825@am-soft.de> (raw)

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-what-now/#

Mit freundlichen Grüßen,

Thorsten Schöning

-- 
Thorsten Schöning       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äftsführer: Andreas Muchow






view thread (4+ messages)  latest in thread

Message-ID: <623997363.20190708183825@am-soft.de>
Permalink:  ../623997363.20190708183825@am-soft.de/
Also on:    postgresql.org/message-id/623997363.20190708183825@am-soft.de

 · 

reply

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: tschoening@am-soft.de
  Subject: Re: Does anyone backup directly on Synology NAS using Barman or similar?
  In-Reply-To: <623997363.20190708183825@am-soft.de>

* 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