search

reactive-tech / kubegres

Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.
https://www.kubegres.io
Apache License 2.0
1.32k stars 74 forks source link

wal_level #40

Closed thepostgresguy closed 3 years ago

thepostgresguy commented 3 years ago

How can I set wal_level to logical?

alex-arica commented 3 years ago

Thank you for you message.

Currently, Kubegres forces the wal_level to "replica" when creating a Pod.

We have not tested it with the wal_level "logical" but this could be added in the backlog as a new feature if you would like?

In that case the wal_level could be set from the postgres.conf as defined here: https://www.kubegres.io/doc/override-default-configs.html

thepostgresguy commented 3 years ago

Thank you!

alex-arica commented 3 years ago

I added this feature in the active backlog.

Thank you for suggesting it.

alex-arica commented 3 years ago

I am pleased to announce the release of Kubegres 1.12 which allow setting the property 'wal_level' to 'logical' in postgres.conf: https://github.com/reactive-tech/kubegres/releases/tag/v1.12

Thanks to @pgvirtuoso for suggesting this feature.

I added additional acceptance tests and updated the documentation page Override the default configurations by mentioning under the section "Override postgres.conf" that is it possible to set 'wal_level' to 'logical'.

To install Kubegres 1.12, please run:

kubectl apply -f https://raw.githubusercontent.com/reactive-tech/kubegres/v1.12/kubegres.yaml