Tag: postgresql
All the articles with the tag "postgresql".
PostgreSQL, repmgr and Barman
Updated:Initially, I started work on a Docker container build, but using the docker build provided some challenges with editing configurations to satisfy barman st
PostgreSQL with TLS Client Auth
Updated:Configure postgresql.conf to enable ssl and configure a server key and certificate. Server Certificate Create a self-signed certificate pair. Put them in .
PostgreSQL, SCRAM and TLS
Updated:When setting up a server using v10.1 and trying to connect using psql client v14, I got an error: PGPASSWORD=SecretKey PGSSLMODE=require psql --host 172.16
Fail2ban - PostgreSQL
Updated:We don't often have the need to expose PostgreSQL to a network, let alone the internet. Mostly the instances are enclosed within a Docker container set and
AWS RDS PostgreSQL Passwords
Working on a customer's AWS database instance, I found they didn't have all the passwords. I could get onto administer to AWS RDS database and instance, bu
Keycloak Cluster
Updated:As resilient as our docker build is I'd like to extend it to a clustered instance of Keycloak. This way, I can load balance a pair of docker containers and
Asterisk and PostgreSQL
Updated:I started out wanting a real-time database connection to our existing LDAP server. This went well, but involved importing a schema into the LDAP cn=config
PostgreSQL and Replication
Updated:We do a lot of postgres replication in our environment. Just about every docker postgres instance replicates its data over to a remote site for failover, s
SQL Format
Updated:We've all got SQL that needs tidying up. https://poorsql.com/ or https://sqlformat.org/ or http://sqlformat.darold.net/ It wont fix your syntax but it will
PostGIS Query Optimisation
Updated:I started to do some work on how efficient the spacial SQL queries I was using are. That meant looking at the indexing that is used on the geometry column