search

zalando / spilo

Highly available elephant herd: HA PostgreSQL cluster using Docker
Apache License 2.0
1.51k stars 373 forks source link

WALE_BACKUP_THRESHOLD_MEGABYTES, WALE_BACKUP_THRESHOLD_PERCENTAGE and BACKUP_SCHEDULE #396

Open vitobotta opened 4 years ago

vitobotta commented 4 years ago

Hi!

I am trying to understand how these settings work. I think the backup schedule refers to a full backup done every X hours or whatever depending on how I configure it. Is this correct or am I understanding it wrongly?

Also what do the thresholds mean as far as backups are concerned? I thought there would be continuous archiving of wal to s3, but I only see the initial wal backup (/wal directory) after creating the cluster. It's not been 12 hours yet (I configured the schedule for every 12 hours) so I don't know yet if an update is going to happen then. So, the question is: is this doing a continuous archiving or how does it work? Ny clarification is much appreciated. Thanks! :)

boris-savic commented 4 years ago

+1, would love better explaination of the config.

kungfuchicken commented 3 years ago

+1 bump on this. the existing documentation also doesn't mention BACKUP_NUM_TO_RETAIN, which also seems to be a valid environment variable. clearer explanations, and examples of the impact would be really valuable.