Selfhosted

61923 readers

169 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.
AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago

MODERATORS

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

Portabase 1.14: Open source database backup/restore tool (github.com)

submitted 3 months ago by KillianLarcher@lemmy.world to c/selfhosted@lemmy.world

9 comments fedilink hide all child comments

Hello all!

I’m one of the maintainers of Portabase, I share about it on Lemmy one month ago (https://lemmy.world/post/45042565) and I have some updates!

Repository: https://github.com/Portabase/portabase

Database homogenous migration is now built-in!

Previously, migrating meant:

Download backup from the source DB
Upload & restore it into the target DB

Now: no download, no upload, everything happens directly through the GUI.

It works with all supported databases, and migrations can be done within the same organization.

We also added support for Microsoft SQL Server! It still needs broader community testing to help identify bugs or edge cases we may have missed.

Quick recap : Portabase is an open-source platform for database backup and restore.

We now support 9 databases:

PostgreSQL
MariaDB and MySQL
SQLite
MongoDB
Redis and Valkey
Firebird SQL
Microsoft SQL Server

What’s new since version 1.10:

Healthchecks for both the database and the agent (with optional notifications)
Homogeneous database migration
Support for Microsoft SQL Server

If you’re using Microsoft SQL Server (or any other supported database), we’d really appreciate your feedback. Feel free to open issues if you find any bugs.

you are viewing a single comment's thread
view the rest of the comments

[–] clifmo@programming.dev 2 points 3 months ago (1 children)

Nice to see the flurry of activity on this young project. I Considering deploying to my swarm to handle restore only. I have a bare metal db VM using cron to dump dbs, and autorestic handles retention with deduplication. This works well for me since my homelab is generally pretty quiet.

Two things I'd like/want to see: deduplication either via supporting Restic as a backup backend and swarm-style SECRET_FILE support (I forked and may PR this one)

[–] KillianLarcher@lemmy.world 1 points 3 months ago

Thanks for the feedback! Feel free to open issues for these ideas. A PR for SECRET_FILE support would be very welcome.