Tag: postgresql
All the articles with the tag "postgresql".
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
PostGIS and geoJson
Updated:On with this current theme of spacial systems and mapping, one of the interesting challenges I faced was querying spacial data. My particular problem was t
DBeaver - SQL GUI
I've used a few SQL GUI's over the years, SQuirreL, DBVisualizer, HeidiSQL, MySQL Workbench, but the one that stands out recently is DBeaver . It's got a c
JIRA Software and Confluence
Installing Atlassian Jira Software onto an in-house or self-hosted server is as simple as following the Jira installation guide . The only thing missing is