Обсуждение: Does anyone backup directly on Synology NAS using Barman or similar?
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
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:
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
Вложения
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