KillianLarcher4d ago

Portabase v1.7.1 - Open source database backup/restore tool

https://lemmy.world/post/44386846

Show threadabecede

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.

Mar 18 at 10:11amWeb
Show threadKillianLarcher3d ago

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.

Show threadabecede3d 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.