Skip to main content
Solved

Consistent PostgreSQL Backups with Kasten K10

M

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​​​

Best answer by BertrandFR

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?

View original
Did this topic help you find an answer to your question?

3 comments

MicoolPaul
Forum|alt.badge.img+23

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.

Michael Paul - Opinions are my own and do not necessarily reflect the opinion of Veeam | https://micoolpaul.com | Mastodon: @micoolpaul@masto.nu | Bluesky: @micoolpaul.com
BertrandFR
1 person likes this
  • BertrandFR
    BertrandFR
BertrandFR
Forum|alt.badge.img+8
  • BertrandFR
  • Influencer
  • 528 comments
  • Answer
  • June 8, 2022

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?

M
  • M.Z.
  • Author
  • 1 comment
  • August 11, 2022

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


Terms & Conditions