ERROR: cannot execute INSERT in a read-only transaction on Bitnami/postgresql-ha

Question

In the Bitnami chart postgresql-ha, I've gotten an error like this at the pod postgresql-ha-postgresql-0;

ERROR: cannot execute INSERT in a read-only transaction

kreato · Accepted Answer

The solution seems to be to add Helm values like so;

          pgpool:
            configuration: |
              connection_cache = false
              failover_on_backend_error = on
              failover_on_backend_shutdown = on

After deleting the pods, the problem seems to have gone away.

ERROR: cannot execute INSERT in a read-only transaction on Bitnami/postgresql-ha

1 Answers