From 766009c664cc8aaf5a6bf98fe5547024506b842d Mon Sep 17 00:00:00 2001 From: Joe Banks Date: Sun, 2 Jun 2024 17:23:37 +0100 Subject: Remove PostgreSQL deployment from Kubernetes --- .../namespaces/databases/postgresql/README.md | 16 ------- .../namespaces/databases/postgresql/configmap.yaml | 38 ----------------- .../databases/postgresql/deployment.yaml | 47 --------------------- .../namespaces/databases/postgresql/secrets.yaml | Bin 279 -> 0 bytes .../namespaces/databases/postgresql/service.yaml | 12 ------ .../namespaces/databases/postgresql/volume.yaml | 14 ------ 6 files changed, 127 deletions(-) delete mode 100644 kubernetes/namespaces/databases/postgresql/README.md delete mode 100644 kubernetes/namespaces/databases/postgresql/configmap.yaml delete mode 100644 kubernetes/namespaces/databases/postgresql/deployment.yaml delete mode 100644 kubernetes/namespaces/databases/postgresql/secrets.yaml delete mode 100644 kubernetes/namespaces/databases/postgresql/service.yaml delete mode 100644 kubernetes/namespaces/databases/postgresql/volume.yaml (limited to 'kubernetes/namespaces/databases/postgresql') diff --git a/kubernetes/namespaces/databases/postgresql/README.md b/kubernetes/namespaces/databases/postgresql/README.md deleted file mode 100644 index 07eed4f..0000000 --- a/kubernetes/namespaces/databases/postgresql/README.md +++ /dev/null @@ -1,16 +0,0 @@ -# Postgres -This folder contains the manifests for Postgres, our primary database. - -You can alter the configuration file inside the `configmap.yaml` file which will be injected into the database container upon boot. Certain parameters (marked in the file) will require a server restart whereas others can be reloaded by using `SELECT pg_reload_conf();` inside Postgres. - -Note that there may be up to a minute before your changes to the ConfigMap are reflected inside the container, if things do not change after that you will have to restart the server for the configuration to apply. - -## Secrets - -postgres requires a `postgres-env` secret with the following entries: - -| Environment | Description | -|-------------------|-----------------------------------| -| PGDATA | The path to the pg_data directory | -| POSTGRES_PASSWORD | The default password to use | -| POSTGRES_USER | The default user to use | diff --git a/kubernetes/namespaces/databases/postgresql/configmap.yaml b/kubernetes/namespaces/databases/postgresql/configmap.yaml deleted file mode 100644 index 4c66ab1..0000000 --- a/kubernetes/namespaces/databases/postgresql/configmap.yaml +++ /dev/null @@ -1,38 +0,0 @@ -apiVersion: v1 -kind: ConfigMap -metadata: - name: postgres-config - namespace: databases -data: - postgresql.conf: | - # From pgtune https://pgtune.leopard.in.ua/ - # DB Version: 16 - # OS Type: linux - # DB Type: web - # Total Memory (RAM): 6 GB - # CPUs num: 4 - # Connections num: 110 - # Data Storage: ssd - - max_connections = 110 - shared_buffers = 1536MB - effective_cache_size = 4608MB - maintenance_work_mem = 384MB - checkpoint_completion_target = 0.9 - wal_buffers = 16MB - default_statistics_target = 100 - random_page_cost = 1.1 - effective_io_concurrency = 200 - work_mem = 7149kB - huge_pages = off - min_wal_size = 1GB - max_wal_size = 4GB - max_worker_processes = 4 - max_parallel_workers_per_gather = 2 - max_parallel_workers = 4 - max_parallel_maintenance_workers = 2 - - # Custom conf - listen_addresses = '*' - password_encryption = md5 - shared_preload_libraries = 'pg_stat_statements' # (change requires restart) diff --git a/kubernetes/namespaces/databases/postgresql/deployment.yaml b/kubernetes/namespaces/databases/postgresql/deployment.yaml deleted file mode 100644 index bf1f246..0000000 --- a/kubernetes/namespaces/databases/postgresql/deployment.yaml +++ /dev/null @@ -1,47 +0,0 @@ -apiVersion: apps/v1 -kind: Deployment -metadata: - name: postgres - namespace: databases -spec: - replicas: 1 - strategy: - type: Recreate - selector: - matchLabels: - app: postgres - template: - metadata: - labels: - app: postgres - spec: - containers: - - name: postgres - image: ghcr.io/owl-corp/psql_extended:16 - imagePullPolicy: "Always" - ports: - - name: postgres - containerPort: 5432 - envFrom: - - secretRef: - name: postgres-env - args: ["-c", "config_file=/etc/postgresql/postgresql.conf"] - volumeMounts: - - name: postgres-data - mountPath: /var/lib/postgresql/data - subPath: pgdata - - name: postgres-config - mountPath: /etc/postgresql - - name: dshm - mountPath: /dev/shm - volumes: - - name: postgres-data - persistentVolumeClaim: - claimName: postgres-storage - - name: postgres-config - configMap: - name: postgres-config - - name: dshm - emptyDir: - medium: Memory - sizeLimit: 2Gi diff --git a/kubernetes/namespaces/databases/postgresql/secrets.yaml b/kubernetes/namespaces/databases/postgresql/secrets.yaml deleted file mode 100644 index 68c225e..0000000 Binary files a/kubernetes/namespaces/databases/postgresql/secrets.yaml and /dev/null differ diff --git a/kubernetes/namespaces/databases/postgresql/service.yaml b/kubernetes/namespaces/databases/postgresql/service.yaml deleted file mode 100644 index 446d222..0000000 --- a/kubernetes/namespaces/databases/postgresql/service.yaml +++ /dev/null @@ -1,12 +0,0 @@ -apiVersion: v1 -kind: Service -metadata: - labels: - app: postgres - name: postgres - namespace: databases -spec: - ports: - - port: 5432 - selector: - app: postgres diff --git a/kubernetes/namespaces/databases/postgresql/volume.yaml b/kubernetes/namespaces/databases/postgresql/volume.yaml deleted file mode 100644 index ed1d2d6..0000000 --- a/kubernetes/namespaces/databases/postgresql/volume.yaml +++ /dev/null @@ -1,14 +0,0 @@ -kind: PersistentVolumeClaim -apiVersion: v1 -metadata: - name: postgres-storage - labels: - app: postgres - namespace: databases -spec: - storageClassName: linode-block-storage-retain - accessModes: - - ReadWriteOncePod - resources: - requests: - storage: 25Gi -- cgit v1.2.3