Solved

Consistent PostgreSQL Backups with Kasten K10


I did a research for consistent PostgreSQL backups with Kasten K10 and found:

https://docs.kasten.io/latest/kanister/postgresql/install_app_cons.html

Application Consistent PostgreSQL Backup

You described there to use a Kanister pre-hook (“pg_start_backup”) and post-hook (“pg_stop_backup”).

 

Afaik, that alone will not create a consistent backup. You also need any generated archived WAL file between. Archiving must be enabled (archive_mode=on), archived WAL files must be backuped too, therefore.

 

I did not find anything about how to backup archived WAL files. How will you handle them?

 

Thanks, Markus​​​

icon

Best answer by BertrandFR 8 June 2022, 08:57

View original

3 comments

Userlevel 7
Badge +8

I’d suggest this goes in https://community.veeam.com/groups/kasten-k10-support-92

 

So the awesome Kasten folk (staff & community) can see it easier.

Userlevel 7
Badge +3

from my POV, AL shoud be mandatory on production on VMs or physical. I won’t say for pods, i didn’t dig the subject.

Why without AL it could be not consistent backup? you should have a point from your pgbackup?

Remind that I am talking about physical backups only.

 

Without AL, the only possiblity for a consistent backup would be an offline backup, that is shutdown postgres (primary in case of replicas) - save $PGDATA - startup postgres.

 

Without AL, you could only rely on dumps, offline backups and replicas which would not be appropriate for production in most cases.

Comment