search

timescale / helm-charts

Configuration and Documentation to run TimescaleDB in your Kubernetes cluster
Apache License 2.0
263 stars 223 forks source link

Allow adding pgbackrest options to pgbackrest_restore.sh #606

Open omkaark opened 1 year ago

omkaark commented 1 year ago

What is missing? Currently, there is no way to add options like db-include to the cluster restore process (pgbackrest_restore.sh). We want to create a whitelist of dbs to restore and whitelist of tables with certain databases to restore (this would use the tablespaces map option in pgbackrest).

Why do we need it? Allows for a more official way to restore only the data we need in our clusters. Currently, we have a workaround where the post-init script drops unneeded dbs and tables but it causes us to restore all the data and then drop the stuff we don't want which is inefficient.

Anything else we need to know?: Thank you!

theelderbeever commented 10 months ago

In general there is no way to mount custom files seemingly either. Meaning you can't create a separate script and point to it despite being able to configure what script the restore command points at.