FrankWiles.com
items
3 Posts

postgresql

Post

Installing a specific version of PostgreSQL in your Dockerfile

It's common to need a specific version of PostgreSQL installed for things like pg_dump in a Python docker project (which is often based on Debian). It's not hard, but it's easy to forget the exact steps, so I wanted to walk you through how to do it step by step.

dockerpostgresql
Post

Creating a PostgreSQL database using psycopg

Quotes around your tables got you down? Yeah me too. Creating, dropping or altering PostgreSQL objects with Python and psycopg is a bit tricky when it comes to identifiers like the names of databases, tables, and indexes.

pythonpostgresql
Post

Setting up Grafana to persist in PostgreSQL with Helm

There are tons of Grafana and Helm tutorials out there, but I could not find any that did not use the default option of a Kubernetes persistent volume to store Grafana's data. It wasn't difficult, but wanted to document it here for the next person.

postgresqlmetricskubernetes