Обсуждение: Does anyone backup directly on Synology NAS using Barman or similar?

Поиск
Список
Период
Сортировка

Does anyone backup directly on Synology NAS using Barman or similar?

От
Thorsten Schöning
Дата:
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




Re: Does anyone backup directly on Synology NAS using Barman orsimilar?

От
Rui DeSousa
Дата:


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/


Re: Does anyone backup directly on Synology NAS using Barman orsimilar?

От
Stephen Frost
Дата:
Greetings,

* Thorsten Schöning (tschoening@am-soft.de) wrote:
> 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.

Doesn't that provide a CIFS network share that you could then mount..?
Or maybe an iSCSI LUN that you could mount to your database server?

Seems like having a network mount and then using something which works
with that kind of network mount would be a good option (pgbackrest
supports CIFS mounts explicitly, I'm not sure about other tools).

Thanks,

Stephen

Вложения

Re: Does anyone backup directly on Synology NAS using Barman or similar?

От
Thorsten Schöning
Дата:
Guten Tag Stephen Frost,
am Montag, 8. Juli 2019 um 21:11 schrieben Sie:

> Doesn't that provide a CIFS network share that you could then mount..?
> Or maybe an iSCSI LUN that you could mount to your database server?

The NAS is in an external place and network, completely independent
from the database server. So I focussed on something "pulling" using
SSH only at best. But turning things around might be an option as
well, there's already an OpenVPN making the NAS accessible as well.
Thanks for the hint!

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