Multiple Database in a postgres cluster on Kubernetes?

Question

Is it possible to have multiple databse in a cluster with Crunchydata (postgres)? When I create a cluster with "pgo create cluster" command I can specify only one database.

 -d, --database string                       If specified, sets the name of the initial database that is created for the user. Defaults to the value set in the PostgreSQL Operator configuration, or if that is not present, the name of the cluster

But I need multiple database per cluster, and I can't find any official way to create them.

Another question: How can I find the "superuser" username and password to login to PGOAmin Web?

Thanks a lot.

Super credentials are usually generated by the operators on creating the clusters. You can try to see what ConfigMaps and Secrets are added to Kubernetes after creating the cluster. You will find credentials in one of these. PS, I haven't used cruchydata's operator. I have used the one by Zalando. — ashu
– ashu, Commented Sep 30, 2020 at 15:37
Thanks for the reply. I've tried all secrets in the cluster namespace and in the operator namespace as well, but none of them worked. — user2384666
– user2384666, Commented Sep 30, 2020 at 15:49
access.crunchydata.com/documentation/postgres-operator/3.5.2/… Found this. Looks like something that can solve your issue — ashu
– ashu, Commented Sep 30, 2020 at 15:56
Did you find answer to create multiple databases? Me too looking for the answer — Sathish Kumar
– Sathish Kumar, Commented May 4, 2021 at 12:49
Same question here: How do we "officially" add databases to the cluster? We could use psql, but would db created in psql get backed up by the cluster? — Tom Grushka
– Tom Grushka, Commented Jun 5, 2021 at 5:38

Nurhun · Accepted Answer · 2021-12-02 11:47:47Z

1

This could be useful, however it stated:

"It may make more sense to have each of your databases in its own cluster if you want to have them spread out over your Kubernetes topology."

https://github.com/CrunchyData/postgres-operator/issues/2655

answered Dec 2, 2021 at 11:47

Nurhun

6921 gold badge12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nimrod Yonatan Ben-Nes Over a year ago

Liked (good link) but would say that the comment is a bit misleading as it start with "As to "is it recommended," it's up to how you want to organize your data and what your availability and performance requirements are."

Collectives™ on Stack Overflow

Multiple Database in a postgres cluster on Kubernetes?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related