Document how to tweak and upgrade SGDistributedLogs
Create the following sections under Administration:
-
Document how to tweak an SGDistributedLogs
by usingstackgres.io/reconciliation-pause
annotation to change the Pod used resources or the Postgres configuration. This section should include a list of specific options a user could touch to avoid break functionality.
Also, the current documentation for upgrading distributed logs is not working since distributed logs database structure changes from 0.9
to 1.0
.
In particular:
- timescaledb extensions version 1.7.4 is not created
- Tables
log_patroni
andlog_postgres
are not timescale hypertables
To make the operation more portable we should create a runbook to:
- Create a new instance of distributed logs
- Point the
SGCluster
s to the new distirbtued logs - Move all the data from the old instance to the new one with
kubectl exec
+pg_dumpall
+psql
- - Delete the old distributed logs
Edited by Adrián Escoms