Selfhosted

58172 readers

465 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:

Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
No spam posting.
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
No trolling.
No low-effort posts. This is subjective and will largely be determined by the community member reports.

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 2 years ago

MODERATORS

HybridSarcasm@lemmy.world

HybridSarcasm@lemmy.hybridsarcasm.xyz

Portabase v1.7.1 - Open source database backup/restore tool (github.com)

submitted 2 weeks ago* (last edited 2 weeks ago) by KillianLarcher@lemmy.world to c/selfhosted@lemmy.world

18 comments fedilink hide all child comments

Hi community,

I’m one of the maintainers of Portabase, and this is my first time sharing about it on Lemmy.

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

It’s designed to be simple, reliable, and lightweight, without exposing your databases to public networks. It works via a central server and edge agents (like Portainer), making it perfect for self-hosted or edge environments.

It currently supports 7 databases:

PostgreSQL, MariaDB, MySQL, SQLite, MongoDB, Redis and Valkey

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

(we hit 500 stars recently!)

Key features:

Logical backups for PostgreSQL, MySQL, MariaDB, MongoDB, SQLite, Redis, Valkey
Multiple storage backends: local filesystem, S3, Cloudflare R2, Google Drive
Notifications via Discord, Telegram, Slack, webhooks, etc.
Cron-based scheduling with flexible retention strategies
Agent-based architecture for secure, edge-friendly deployments
Ready-to-use Docker Compose setup and Helm Chart

What’s coming next:

Increasing test coverage
Extending database support

I’d love to hear from you: which database would you like to see supported next in Portabase?

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

[–] abecede@lemmy.world 3 points 2 weeks ago (2 children)

Can you explain to me how the core backup process works? I browsed the git repo, but could not find it after about 10 minutes.

For example PostgreSQL: does it just do a pg_dump of a whole database? Or table for table? What about incremental backups? Are these implemented? And if so, what's the concept behind it?

Otherwise I would not see any use for larger (dozens of gigabytes and more) databases.

[–] KillianLarcher@lemmy.world 3 points 2 weeks ago (1 children)

Currently, the backup process is logical. Incremental backups are not implemented yet, as supporting them across multiple database systems (PostgreSQL, MariaDB, MongoDB, etc.) would require significant development effort.

The system relies on the database’s native tools when possible, such as pg_dump for PostgreSQL or mongodump for MongoDB. Table-level backups are not currently supported, but could be introduced in the future if there is enough demand.

[–] abecede@lemmy.world 1 points 2 weeks ago

Thanks for the clarification. Now I know, that I'll stick to my daily cronjob that just runs pg_dump via ssh to another machine. I get e-mail notifications with my simple shell script as well.