Comments (5)
Hi @mzwettler2. At this time, the PostgresCluster-Scoped pgAdmin is not compatible with PostgreSQL 15 and newer, and we are currently focusing our attention on the new Namespace-scoped pgAdmin that was included in the CPK v5.5.0 release.
Have you had an opportunity to try the new pgAdmin API? This is our brand-new, modern API for pgAdmin, which has full support for both Postgres 15 and 16.
I therefore definitely recommend checking it out if you haven't already done so. We'd certainly be curious to hear about your experience with this new implementation, and welcome any feedback.I also recommend checking the following blog for a great introduction to the new API: https://www.crunchydata.com/blog/cpk-5-5-a-new-pgadmin-experience
from postgres-operator.
Yes, we have tried the new variant and will use it out of necessity, as the old variant does not work with PG 15 and PG 16.
We only have one PG cluster per namespace, so the old variant was better for our purposes, as the defined users from spec.users were synchronized to PGAdmin. With the new variant, normal PGAdmin users must now be created and maintained manually.
Once again, any plans that the Cluster scoped pgAdmin4 version is also updated?
from postgres-operator.
Hi @mzwettler2!
At this time we our focusing our efforts on the new Namespace-scoped pgAdmin API. We therefore do not have any immediate plans to add Postgres 15 or 16 support to the PostgresCluster-Scoped pgAdmin solution.
This means you will need to leverage the new pgAdmin API to have full support for the latest versions of Postgres (e.g. PG 15 & 16).
As for user-sync functionality you referenced, it sounds like this is the primary benefit of the cluster-scoped solution that you would like to continue to leverage? I'll note that this functionality is something we have considered for the new API as well.
However, as you might be able to imagine, since a single pgAdmin is now able to support more than one PostgresCluster, this also means multiple cluster could have the same spec.users defined, complicating the ability to synchronize with pgAdmin. We therefore definitely welcome any thoughts or feedback you might have as to how we might be able design & implement similar functionality within the new API.
from postgres-operator.
As for user-sync functionality you referenced, it sounds like this is the primary benefit of the cluster-scoped solution that you would like to continue to leverage? I'll note that this functionality is something we have considered for the new API as well.
Yes. That is exactly my point.
We therefore definitely welcome any thoughts or feedback you might have as to how we might be able design & implement similar functionality within the new API.
I am afraid I don't have "the" solution. one solution could be a new key "spec.users.addToPGAdmin". another could be to always append the cluster name to the spec.users.name to get unique names in PGAdmin.
from postgres-operator.
I played with the namespace-scoped variant for a while.
If no spec.users are synchronized to pgAdmin, then it would at least be helpful if another "normal" pgAdmin user would be created by default in addition to the "admin" pgAdmin Administrator.
The pgAdmin secrets should always have the same name. One appropriate format could be e.g:
<<namespace>>-pgadmin-<<admin>>
<<namespace>>-pgadmin-<<user>>
(Background: We synchronize the passwords from Hashicorp Vault to the secrets. However, this does not work well if the secret names are subject for change, eg. in case of a redeployment).
from postgres-operator.
Related Issues (20)
- Documentation Bug - Missing Key HOT 2
- Create Openshift Service + Route on PGAdmin resource deployment HOT 1
- Recreate pgbackrest stanza after lost backrest-shared-repo storage, please help! HOT 2
- Postgres replicas bootstrap error at new deployment HOT 2
- How to enable debug mode in postgres HOT 4
- closed HOT 3
- Adding extension mysql_fdw to postgres-gis HOT 2
- How to limit or prevent the impact HOT 3
- pgbackrest backup fails with ERROR: [082]: WAL segment 000001B000000AF80000009B was not archived before the 60000ms timeout HOT 2
- Issue with the makefile
- Default requests/limits for containers in PostgresCluster CR HOT 3
- Deploying replication slots HOT 1
- Postgres Major Version Upgrade connection to server on socket "/pgdata/.s.PGSQL.50432" failed: FATAL: could not access file "zombodb.so": No such file or directory HOT 2
- UnableToCreateStanzas warning with wrong address for backup repo pod
- Add the postgrescluster helm chart to the OCI developer registry
- Pgadmin URL is not working post adding userInterface in the PGO CRD. HOT 1
- `no pg_hba.conf entry for host` when cluster is being connected to from another namespace
- Install Decoderbufs Extension
- Unable to disable TLS effectively
- new pgadmin 7.8 in namespace scoped mode gives error ERROR\tpgadmin:\t'pinged'
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from postgres-operator.