Sign in or sign up before continuing. Don't have an account yet? Register now to get started.
Register now

WARNING: Value=100100100100100100100100100100100100100100100100MB of parameter=wal_keep_size is too big

Postgres is warning about the the high value of the wal_keep_size, that is set to the maximum (2147483647MB - or ~2PB). Here is the full message:

2021-09-06 13:31:38,413 WARNING: Value=100100100100100100100100100100100100100100100100MB of parameter=wal_keep_size is too big, decreasing to 2147483647MB

The cluster has been created with the follow yaml:

apiVersion: stackgres.io/v1
kind: SGCluster
metadata:
  name: simple
spec:
  instances: 1
  postgres:
    version: 'latest'
  pods:
    persistentVolume: 
      size: '5Gi'

But when connected in the psql, it shows:

❯ kubectl exec -it simple-0 -c postgres-util -- psql
psql (13.4 OnGres Inc.)
Type "help" for help.

postgres=# show wal_keep_size;
 wal_keep_size
---------------
 2147483647MB
(1 row)

Attached they current values for the sgcluster and the sgpgconfig. Also de logs:

  • patroni-logs-beta3.log
  • simple-cluster-beta3.yml
  • default-pg-conf-sg-beta3.taml
  • patroni-config-beta3.yml

I've could not find any configuration that holds this new value.

About the env:

❯ kubectl get deployments -n stackgres stackgres-operator --template '{{ printf "%s\n" (index .spec.template.spec.containers 0).image }}'
stackgres/operator:1.0.0-beta3

❯ kubectl version
Client Version: version.Info{Major:"1", Minor:"22", GitVersion:"v1.22.1", GitCommit:"632ed300f2c34f6d6d15ca4cef3d3c7073412212", GitTreeState:"clean", BuildDate:"2021-08-19T15:45:37Z", GoVersion:"go1.16.7", Compiler:"gc", Platform:"linux/amd64"}
Server Version: version.Info{Major:"1", Minor:"17", GitVersion:"v1.17.11", GitCommit:"ea5f00d93211b7c80247bf607cfa422ad6fb5347", GitTreeState:"clean", BuildDate:"2020-09-14T07:50:38Z", GoVersion:"go1.13.15", Compiler:"gc", Platform:"linux/amd64"}
WARNING: version difference between client (1.22) and server (1.17) exceeds the supported minor version skew of +/-1
Assignee Loading
Time tracking Loading