Scheduled Maintenance

By default, there will be a security maintenance on Tuesday night (Central Europe Time).

For more information about maintenance procedures, please visit the product description.

The day and time can be adjusted as described below. Times are in the CET time zone.

PostgreSQL instance with custom maintenance

apiVersion: vshn.appcat.vshn.io/v1
kind: VSHNPostgreSQL
metadata:
  name: pgsql-app1-prod
  namespace: prod-app
spec:
  parameters:
    maintenance:
      dayOfWeek: wednesday (1)
      timeOfDay: '23:30:00' (2)
    service:
      repackEnabled: true (3)
      vacuumEnabled: false (4)

1	The day when the maintenance should take place
2	The time when the maintenance should be started
3	Enable or disable pg_repack for all databases
4	Enable or disable VACUUM for all databases

Besides version upgrades, pg_repack is performed on all databases by default. It can run alongside the VACUUM operation. It’s impossible to set both vacuumEnabled and repackEnabled to false.