1 1
pkfox

Backup suggestions

Recommended Posts

HI all, having finally got my Nanopi m4 v2s setup as I want them ( bionic ) and pretty stable too. I would like to setup a nightly backup , I have Postgres installed so would want that data backed up to . Do any of you have any suggestions as to the best way / strategy to do this ? I have external SSD' and USB drives available

Share this post


Link to post
Share on other sites

Is this still an issue?

 

A nice way to backup DB's these days is to use either LVM or BTRFS snapshots for crash-consistent backups.  Each of them is done differently, but they give you point in time recovery.  The right way to get clean backups of Postgres is to dump the data out and put that somewhere safe.

 

It's been a long time since I've used LVM for this, so I'm not going to recommend anything there.

 

For BTRFS snapshots, you can use snapper for local backups or btrfs-sxbackup for local and/or remote backups.  The advantage of btrfs-sxbackup here is that it will do filesystem level incremental backups which is faster than checking and copying files.

 

For the PG backups there's a tool to automate it for you: autopostgresqlbackup.  Remember you will still need to get those backups off the system.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
1 1