phpbu icon indicating copy to clipboard operation
phpbu copied to clipboard

What will happen if the database is huge?

Open OpenSourceSimon opened this issue 1 year ago • 1 comments

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

OpenSourceSimon avatar Jan 31 '24 10:01 OpenSourceSimon

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.

sebastianfeldmann avatar Feb 08 '24 14:02 sebastianfeldmann