zalando / postgres-operator

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
https://postgres-operator.readthedocs.io/
MIT License
4.29k stars 974 forks source link

Extension GZIP #1673

Open DTvGe45vc opened 2 years ago

DTvGe45vc commented 2 years ago

Please, answer some short questions which should help us to understand your problem / question better?

Some general remarks when posting a bug report:

Hello I installed Zalando postgres-operator by helm chart version 1.7.0. I try to install extension gzip in postgres-cluster and don't understand how I can do it My manifest doesn't work

     preparedDatabases:
       postgres:
         extensions:
           gzip: public
     postgresql:
       version: "13"
       parameters:  # Expert section
         shared_buffers: "32MB"
         max_connections: "100"
         log_statement: "all"

Postgres pod stop running with error:

   Error: Database is uninitialized and superuser password is not specified.
   You must specify POSTGRES_PASSWORD to a non-empty value for the
   superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".

   You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
   connections without a password. This is *not* recommended.

   See PostgreSQL documentation about "trust":
   https://www.postgresql.org/docs/current/auth-trust.html

Help me please? how I can solve it?

CyberDem0n commented 2 years ago

Postgres pod stop running with error:

Error: Database is uninitialized and superuser password is not specified. You must specify POSTGRES_PASSWORD to a non-empty value for the superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".

You must be running not Spilo, but some other image.

And regarding gzip extension - it is not supported in Spilo