October 25, 2018 - - env: - name: POSTGRES_DB valueFrom: configMapKeyRef: name: postgres-config key: POSTGRES_DB - name: POSTGRES_USER valueFrom: configMapKeyRef: name: postgres-config key: POSTGRES_USER - name: POSTGRES_PASSWORD valueFrom: configMapKeyRef: name: postgres-config key: POSTGRES_PASSWORD

1 month ago - PostgreSQL Configuration: Reference a user-created ConfigMap with postgresql.conf overrides via postgresConfigRef on shard templates.

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes - postgres-operator/manifests/configmap.yaml at master · zalando/postgres-operator

April 12, 2022 - Example Kubernetes setup with Postgres and two Services for serving an API and a static site using Ingress. Also have a CronJob example for kicks. - instructions.txt

Postgres connection pool on Kubernetes in 1 minute · First we create a Config Map for the following values: ... DB_PASSWORD will be set using the previously created secret. POOL_MODE is set to transaction and SERVER_RESET_QUERY to DISCARD ALL by default in the respective deployment manifest. $ kubectl create configmap pgbouncer-configs \ --from-literal=DB_HOST=postgresql-svc.postgres.svc.cluster.local \ --from-literal=DB_USER=postgres

Postgres connection pool on Kubernetes in 1 minute · First we create a Config Map for the following values: ... DB_PASSWORD will be set using the previously created secret. POOL_MODE is set to transaction and SERVER_RESET_QUERY to DISCARD ALL by default in the respective deployment manifest. $ kubectl create configmap pgbouncer-configs \ --from-literal=DB_HOST=postgresql-svc.postgres.svc.cluster.local \ --from-literal=DB_USER=postgres

September 8, 2020 - Data stored in a ConfigMap not encrypted. These Kubernetes resources should be only be used with data that is non-sensitive. apiVersion: v1 kind: ConfigMap metadata: name: postgres data: POSTGRES_DB: myapp_production

February 17, 2026 - Learn how to create the PostgreSQL instance, ConfigMap, and Deployment objects

apiVersion: v1 kind: ConfigMap metadata: name: pod-env-overrides namespace: postgres-operator-system data: # Any env variable used by spilo can be added USE_WALG_BACKUP: "true" USE_WALG_RESTORE: "true" CLONE_USE_WALG_RESTORE: "true" WALG_AZ_PREFIX: "azure://container-name/$(SCOPE)/$(PGVERSION)" # Enables Azure Backups (SCOPE = Cluster name) (PGVERSION = Postgres version) Setup your operator configuration values. With the psql-backup-creds and pod-env-overrides resources applied to your cluster, ensure that the operator's configuration is set up like the following: ... kubernetes: pod_environment_secret: "psql-backup-creds" pod_environment_configmap: "postgres-operator-system/pod-env-overrides" aws_or_gcp: wal_az_storage_account: "postgresbackupsbucket28302F2" # name of storage account to save the WAL-G logs ...

October 8, 2020 - apiVersion: v1 kind: ConfigMap metadata: name: pg-hba-configmap data: pg_hba.conf: |+ # TYPE DATABASE USER ADDRESS METHOD # Some personal settings here --- apiVersion: apps/v1 kind: StatefulSet metadata: name: db spec: selector: matchLabels: app: db serviceName: db replicas: 1 template: metadata: labels: app: db spec: nodeSelector: db: 'true' containers: - name: db image: kartoza/postgis:10.0-2.4 volumeMounts: - name: data-volume mountPath: /var/lib/postgresql - name: pg-hba-config-volume mountPath: /var/lib/postgresql/10/main/pg_hba.conf subPath: pg_hba.conf volumes: - name: data-volume hostPath: path: /data/db - name: pg-hba-config-volume configMap: name: pg-hba-configmap

kind: ConfigMap · metadata: name: init-data · namespace: n8n · data: init-data.sh: | #!/bin/bash · set -e; if [ -n "${POSTGRES_NON_ROOT_USER:-}" ] && [ -n "${POSTGRES_NON_ROOT_PASSWORD:-}" ]; then · psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL ·

By default, kubernetes_use_configmaps: false, meaning endpoints will be used. docker_image Spilo Docker image for Postgres instances. For production, don't rely on the default image, as it might be not the most up-to-date one. Instead, build your own Spilo image from the github repository.

February 21, 2024 - In brief, our Support Experts demonstrated how to deploy Postgres in Kubernetes with ConfigMap.

kubectl apply -k github.com/za... acid-minimal-cluster. manifest. ... To install the Postgres Operator in OpenShift you have to change the config parameter kubernetes_use_configmaps to "true"....

Describes detailed steps to deploy Postgresql on Kubernetes with SSL/TLS support using PersistentVolume, configMap, and secrets along with possible issues, troubleshooting steps and work-around. - pppoudel/postgresql-with-ssl-on-kubernetes

November 28, 2017 - $ kubectl exec -it postgres-3585693371-xnzjv bash root@postgres-3585693371-xnzjv:/# psql -U user -d url_shortener_db psql (9.6.5) Type "help" for help.url_shortener_db=# ConfigMaps can also be defined by a manifest with data in a key/value form, but for the sake of example, we’ll load the content from an external file, config.yaml which contains a single entry (cough!) to set the logger level:

playing with kubernetes, minikube, docker, rest-api - DanielePalaia/kubernetes-postgres

Running postgres in kubernetes. GitHub Gist: instantly share code, notes, and snippets.

For each namespace where a Kubegres resource is created, Kubegres controller creates a base ConfigMap resource with this contents. That base ConfigMap contains the default configs for all Kubegres resource(s) in that namespace. It defines default contents for "postgres.conf", "pg_hba.conf" and a backup logic in "backup_database.sh".

kubectl create -f postgres.yaml kubectl create -f postgres-service.yaml kubectl port-forward svc/postgres 5000:5432 kubectl create -f config-map.yaml · The respective commands create a deployment, a service, perform a database port forwarding inside k8s and create a configmap for the database.