pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes anyone backup directly on Synology NAS using Barman or similar?
4+ messages / 3 participants
[nested] [flat]
* Does anyone backup directly on Synology NAS using Barman or similar?
@ 2019-07-08 16:38 Thorsten Schöning <tschoening@am-soft.de>
2019-07-08 18:14 ` Re: Does anyone backup directly on Synology NAS using Barman or similar? Rui DeSousa <rui@crazybean.net>
2019-07-08 19:11 ` Re: Does anyone backup directly on Synology NAS using Barman or similar? Stephen Frost <sfrost@snowman.net>
0 siblings, 2 replies; 4+ messages in thread
From: Thorsten Schöning @ 2019-07-08 16:38 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Does anyone backup directly on Synology NAS using Barman or similar?
2019-07-08 16:38 Does anyone backup directly on Synology NAS using Barman or similar? Thorsten Schöning <tschoening@am-soft.de>
@ 2019-07-08 18:14 ` Rui DeSousa <rui@crazybean.net>
1 sibling, 0 replies; 4+ messages in thread
From: Rui DeSousa @ 2019-07-08 18:14 UTC (permalink / raw)
To: Thorsten Schöning <tschoening@am-soft.de>; +Cc: pgsql-admin
> 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/ <https://www.commandprompt.com/blog/postgresql-non-exclusive-base-Backup-bash/;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Does anyone backup directly on Synology NAS using Barman or similar?
2019-07-08 16:38 Does anyone backup directly on Synology NAS using Barman or similar? Thorsten Schöning <tschoening@am-soft.de>
@ 2019-07-08 19:11 ` Stephen Frost <sfrost@snowman.net>
2019-07-09 10:42 ` Re: Does anyone backup directly on Synology NAS using Barman or similar? Thorsten Schöning <tschoening@am-soft.de>
1 sibling, 1 reply; 4+ messages in thread
From: Stephen Frost @ 2019-07-08 19:11 UTC (permalink / raw)
To: Thorsten Schöning <tschoening@am-soft.de>; +Cc: pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Does anyone backup directly on Synology NAS using Barman or similar?
2019-07-08 16:38 Does anyone backup directly on Synology NAS using Barman or similar? Thorsten Schöning <tschoening@am-soft.de>
2019-07-08 19:11 ` Re: Does anyone backup directly on Synology NAS using Barman or similar? Stephen Frost <sfrost@snowman.net>
@ 2019-07-09 10:42 ` Thorsten Schöning <tschoening@am-soft.de>
0 siblings, 0 replies; 4+ messages in thread
From: Thorsten Schöning @ 2019-07-09 10:42 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2019-07-09 10:42 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-08 16:38 Does anyone backup directly on Synology NAS using Barman or similar? Thorsten Schöning <tschoening@am-soft.de>
2019-07-08 18:14 ` Rui DeSousa <rui@crazybean.net>
2019-07-08 19:11 ` Stephen Frost <sfrost@snowman.net>
2019-07-09 10:42 ` Thorsten Schöning <tschoening@am-soft.de>
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