Author: admin

Deploy PostgreSQL HA (Patroni, etcd, HAproxy) on Ubuntu servers using Ansible

Published on Author admin

Deploy PostgreSQL HA (Patroni, etcd, HAproxy) on Ubuntu servers using Ansible Architecture Verify commands #etcd etcdctl --endpoints=http://10.10.10.111:2379,http://10.10.10.112:2379,http://10.10.10.113:2379 member list etcdctl --endpoints=http://10.10.10.111:2379,http://10.10.10.112:2379,http://10.10.10.113:2379 endpoint health etcdctl --endpoints=http://10.10.10.111:2379,http://10.10.10.112:2379,http://10.10.10.113:2379 endpoint status #patroni patronictl -c /etc/patroni/patroni.yml topology ls /var/lib/postgresql/18/main -l /usr/lib/postgresql/18/bin/pg_controldata /var/lib/postgresql/18/main #haproxy watch 'echo "show stat" | nc -U /var/lib/haproxy/stats | cut -d "," -f 1,2,5-11,18,24,27,30,36,50,37,56,57,62 | column -s,… Continue reading Deploy PostgreSQL HA (Patroni, etcd, HAproxy) on Ubuntu servers using Ansible →

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

Published on Author admin

Append YAML file with docker-compose definition for new PostgreSQL 18 database:   nextcloud-postgres18:     container_name: nextcloud-postgres18     hostname: nextcloud-postgres18     image: postgres:18-alpine     restart: always     volumes:       - /data/nextcloud-postgresql18-data64:/var/lib/postgresql     environment:       - POSTGRES_PASSWORD=       - POSTGRES_DB=nextcloud       - POSTGRES_USER=nextcloud… Continue reading Nextcloud - Upgrading PostgreSQL database running as Docker container from 17 to 18 →

Running nested VMware ESXi 9.0 host under KVM hypervisor

Published on Author admin

Prerequisites: hardware support for VT-x enabled nested virtualization for KVM Use below command to create KVM virtual machine containing VMware ESXi: virt-install --virt-type=kvm --name=vmware-esxi9 \ --ram 8192 --vcpus=4 \ --virt-type=kvm --hvm \ --cdrom /home/pawel/ISO/VMware/VMware-VMvisor-Installer-9.0.0.0.24755229.x86_64.iso \ --network network:default,model=vmxnet3 \ --graphics vnc --video qxl \ --disk pool=default,size=32,sparse=true,bus=sata,format=qcow2 \ --boot cdrom,hd --noautoconsole --force \ --cpu host-passthrough --os-variant linux2020… Continue reading Running nested VMware ESXi 9.0 host under KVM hypervisor →

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 →