Create DB and Users at start

PostgreSQL Percona Distribution for PostgreSQL
, ,
1

Hi

I am using pg-db and pg-operator and installing using helm but what i want is i need to create few database and users at start

I saw the options in values.yaml

users:

  • name: pg
    databases:
    • zoo
      options: “SUPERUSER”
      password:
      type: ASCII
      secretName: “rhino-credentials”

databaseInitSQL:
key: init.sql
name: cluster1-init-sql

But it is not working

Guide me the correct way to create database and users at start

2

Hi
I’m facing the same problem, configured it according to the docs.
added the CM but it seems that nothing happens, checked for logs with stern to be sure not to miss anything.

did you find any solution for it ?