Comments (5)
Hi @mzwettler2, sorry you're running into this. I'm afraid I've never seen this particular error before.
Just to make sure I understand the situation, the pgadmin pod is running fine? If so, can you hit it directly from inside the k8s cluster?
And the way that you've exposed it (virtualservice and istio service mesh) is something that's working fine for other pods in the namespace?
from postgres-operator.
Two times yes. I suspect it is related to istio. I am just surprised because the old, cluster-scoped version 4.6 has no problems.
from postgres-operator.
Hey @mzwettler2, would you be able to change from crunchy-pgadmin4:ubi8-7.8-0
to crunchy-pgadmin4:ubi8-8.6-1
?
Actually, before you do, I want to point to some changes we made between those two images: https://access.crunchydata.com/documentation/postgres-operator/latest/releases/5.6.x#560
(IMHO, the biggest change that might impact people moving from the 7.8 image to a 8.6 image is probably user management, so here's the relevant doc: https://access.crunchydata.com/documentation/postgres-operator/latest/guides/pgadmin/user-management. My quick summary of that change is we no longer automatically set up an admin user for you to manage your own users; now you can define users in the pgadmin CR (and set them as users or admins).)
OK, now that I've gone over the changes that might make the 8.6 experience different, I want to discuss the one change that I think might affect this weird error. One change we recently made was that we are now using gunicorn in the newer image (and gunicorn was what we were using in the older, cluster-scoped image). I am wondering if serving the app through gunicorn might help relieve whatever is happening between pgadmin and istio. (Though also: I don't know for sure that that's where the issue is coming from, but like you, I suspect it is.)
from postgres-operator.
Hey @mzwettler2, just realized -- I have never run an update from 7.8 to 8.6, so I do not know how that will go. Rather than deal with that now, you could create a new pgadmin using the 8.6 image and see if that clears up that noise. If it does, then we can move on to figuring out a best practice for migrating. (Someone else may have that experience, I just wanted to note that I haven't done that yet.)
from postgres-operator.
I am not able to update from 7.8 to 8.6 right now. But I will keep this in mind.
Regarding the new PGAdmin user spec. Cool feature. Thanks. But I have one small criticism. The secrets for the database users are created by pgo automatically. The secrets for the PGAdmin users have to be created manually. That's a bit inconsistent, isn't it?
from postgres-operator.
Related Issues (20)
- Adding extension mysql_fdw to postgres-gis HOT 3
- 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 3
- Issue with the makefile HOT 1
- Default requests/limits for containers in PostgresCluster CR HOT 3
- Deploying replication slots HOT 2
- 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 3
- UnableToCreateStanzas warning with wrong address for backup repo pod HOT 2
- Add the postgrescluster helm chart to the OCI developer registry HOT 1
- 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
- Configuration for multi-master write and replication HOT 2
- Is TLS Rotation Supported? HOT 3
- Replica data file corrupted after restoring database from pg dump file (on primary pod) HOT 1
- PGO/PGBackrest reports "ServiceError: TLS error [1:337260938] dh key too small" when backing up to S3-compatible object storage HOT 2
- Not All Postgrescluster Resources Deleted on Helm Uninstall HOT 4
- unrecognized configuration parameter lc_collate on postgres 16
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.