Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PGAdmin returns a loading screen #4132

Closed
srmklive opened this issue Mar 15, 2025 · 3 comments
Closed

PGAdmin returns a loading screen #4132

srmklive opened this issue Mar 15, 2025 · 3 comments

Comments

@srmklive
Copy link

Hi everyone,

I am facing an issue where pgadmin is not working. I have setup everything according to the docs.

Overview

I am utlizing terraform to provision the postgres cluster. The cluster is working, and i have connected it to various applications. The problem is with pgadmin. I have setup an ingress on the domain (e.g manager.example.com), i am able to see the login screen, but after i login with the credentials for pgadmin, i get the loading screen.

Environment

  • Platform: GKE
  • Platform Version: 1.31
  • PGO Image Tag: ubi8.5
  • Postgres Version: 17
  • Storage: PVC

Code

pgadmin manifest

apiVersion: postgres-operator.crunchydata.com/v1beta1
kind: PGAdmin
metadata:
  name: ${NAME}
  namespace: ${NAMESPACE}
spec:
  users:
  - username: ${PGADMIN_USER}
    role: Administrator
    passwordRef:
      name: ${CLUSTER_NAME}-pguser-${USER}
      key: password
  serviceName: ${NAME}
  dataVolumeClaimSpec:
    accessModes:
    - "ReadWriteOnce"
    resources:
      requests:
        storage: ${DISK_SIZE}Gi
  serverGroups:
    - name: supply
      postgresClusterSelector: {}
  config:
    settings:
      AUTHENTICATION_SOURCES: ['internal']

The values being passed are:

$NAME: pgadmin
$NAMESPACE: database
$PGADMIN_USER: sc@example.com
$CLUSTER_NAME: database-cluster
$USER: sc
$DISK_SIZE: 10

Steps to Reproduce

I am using terraform to provision the infra, and i am utilizing the kubectl_manifest to deploy the manifests. The deployment is successful every time changes are deployed:

Logs

Following is the attached screenshot of the logs for the pgadmin pod inside GKE:

Image

I really hope you guys can help me figure out this issue.

@andrewlecuyer
Copy link
Collaborator

What version of PGO are you using?

@srmklive
Copy link
Author

5.7.4

@srmklive
Copy link
Author

Resolved the issue. Turns out i had to set Cache-Control header on the ingress and also add a caching rule on Cloudflare so nothing related to pgadmin is cached.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants