Category: PostgreSQL

Tune PostgreSQL and PHP settings for Nextcloud inside Docker container on RPi 5

Published on Author admin

Tune PostgreSQL and PHP settings for Nextcloud inside Docker container on RPi 5 PostgreSQL settings change variables inside PG_DATA/postgresql.conf config file shared_buffers = 256MB work_mem = 8MB restart PostgreSQL database: docker restart nextcloud-postgres verify: docker exec -it nextcloud-postgres psql -U nextcloud -d nextcloud -c "SHOW shared_buffers" docker exec -it nextcloud-postgres psql -U nextcloud -d nextcloud… Continue reading Tune PostgreSQL and PHP settings for Nextcloud inside Docker container on RPi 5 →

Generic HA Architecture - App servers + PostgreSQL Patroni cluster

Published on Author admin

Generic HA Architecture - App servers + PostgreSQL Patroni cluster Keepalived + HAproxy used as Load Balancers   Key components: HAproxy - TCP/HTTP Load Balancer Keepalived - Virtual IP for HAproxy Patroni - HA template for PostgreSQL database (cluster with streaming replication) etcd - Distributed Configuration Store for Patroni   Architecture diagram:

Nextcloud - Upgrading PostgreSQL database running as Docker container from 16 to 17

Published on Author admin

Stop and remove current Nextcloud docker services: docker stop nextcloud-app docker stop nextcloud-www docker stop nextcloud-postgres docker stop nextcloud-redis docker rm nextcloud-app docker rm nextcloud-www docker rm nextcloud-postgres docker rm nextcloud-redis Run only old PostgreSQL database container using "docker compose --build" docker compose -f /root/docker-compose-nextcloud.yml up --build nextcloud-postgres -d Dump old PostgreSQL database content to… Continue reading Nextcloud - Upgrading PostgreSQL database running as Docker container from 16 to 17 →