search

sebastianfeldmann / phpbu

PHP Backup Utility - Creates and encrypts database and file backups, syncs your backups to other servers or cloud services and assists you monitor your backup process
https://phpbu.de
Other
1.29k stars 110 forks source link

What will happen if the database is huge? #366

Open OpenSourceSimon opened 7 months ago

OpenSourceSimon commented 7 months ago

I'm creating a logbook in my PostgreSQL database where a lot of rows will be created. Can phpbu split the back-up into multiple files? Otherwise it won't be very readable

sebastianfeldmann commented 7 months ago

Not sure pgdump supports something like that. But I would argue that the dump doesn't have be humanly readable. You should worry more about the machine readability so you can easily restore the backup.

The bigger the database gets the longer the backup takes to complete. And of course system file size and memory limitations apply.