Skip to main content

Hi,

We have PostgreSQL server (Linux on VM) with DB ~7TB in size. We would like to have only full (or better  full+ inc combination) backup done once per day to be able to restore whole DB only to time of backup.

That environment is probably to huge for streaming backup (dump or FS), so we would like to use block-level-backup.

BLB requires WAL logging enabled and during snap backup additional log backup job is running automatically.

It looks like snap backup is consistent because it quiesce DB and put into backup mode, make snap and run DB further. So it looks like in that case logs are not required during restore.

We don’t want run log backup because that DB generates ~0,5TB  logs every hour and, if WAL enabled we need to run additional log backups hourly to delete logs from WAL directory (it takes about 40 minutes every hour). Additionally it requires a lot of space on LOG disklibrary,

Is there any way to run PostgreSQL BLB FSBased backups without log backup?

 

regards,

Przemek

Hi Przemek,

The database is not consistent with block level backup even if we put the DB in backup mode and quiesce the file system. It needs WAL logs to be applied to recover it to a consistent state. That’s the very nature of the hot backup. There can always be dirty pages.

 

If your requirement is not to enable WAL at all and get consistent DB backup, you might need to stop the Postgres instance, take FS block level backup and start the server. Unfortunately this involves down time of the database.

 

Thanks,

Sunil-

Hi Sunil,

Thanks for clarification.

 

regards,

Przemek

Reply


Terms & ConditionsCookie settings