deployment.yaml file
containers:
- image: postgres:8.4
env:
- name: PFADMIN_SERVER_JSON_FILE
value: /pgadmin4/servers.json
volumeMounts:
- name: server-config
mountPath: /pgadmin4/servers.json
subPath: servers.json
- name: password-config
mountPath: /var/lib/storage/pgpass
subPath: pgpass
volumes:
- name: password-config
configMap:
name: pgad-password-config
- name: pgad-server-config
configMap:
name: server-config
configmap for servers.json
kind: ConfigMap
apiVersion: v1
metadata:
name: pgad-server-config
data:
servers.json: |
{
"Servers": {
"1": {
"Name": "My Postgres Server",
"Group": "Servers",
"Host": "host.docker.internal",
"Port": 5432,
"MaintenanceDB": "postgres",
"Username": "postgres",
"PassFile": "/var/lib/storage/pgpass",
"SSLMode": "prefer",
"ConnectionTimeout":10,
"SavePassword": true,
}
}
}
configmap for pgpass
kind: ConfigMap
apiVersion: v1
metadata:
name: password-config
data:
pgpass: |
hostname:port:database:username:password
The issue is when i log in to the postgres, i can see the server but it is prompting me to enter the password so it is not able to read the one i supplied.
i get this error in the UI: connection failed: fe_sendauth: no password supplied