Topic

postgres

A collection of 6 issues

The Ten Commandments for DBAs

I recently read a great blog entry from Fritz Lechnitz, who wrote about the Ten Commandments for a SQL Server DBA. As I am - and mostly was over many years - an Oracle DBA, who had some excursions to other RDBMS (SQL Server, DB/2, Informix, MySQL, PostgreSQL ), I&

PostgreSQL: Use Docker Compose for Pgadmin4

pgAdmin4 is a great tool to manage PostgreSQL databases. It can be installed locally; when you execute it, it starts a local webserver, and you can connect to it. But if there are more than one or two DBAs, it could be a benefit to install a central pgAdmin4. We&

PostgreSQL: Use CheckMk to monitor PostgreSQL

CheckMk is a great tool for monitoring. But it does not only do that for operation systems, you will also be able to monitor your PostgreSQL databases. To do that, you'll need two things: * The PostgreSQL plugin * A configuration file To get the PostgreSQL plugin, you can download

TimescaleDB: Use Docker Compose for TimescaleDB

This time, I'm showing how to use Docker Compose to run TimescaleDB

PostgreSQL: inplace upgrade in Docker container

As I wrote in a older blog entry, we cannot just change the PostgreSQL image of a Docker container to a higher major version. Restarting the container like that will lead to a not running PostgreSQL container, as older data will not start using newer binaries. But there's

PostgreSQL: Using Docker Compose for PostgreSQL

Docker is a great software solution for containerization of other software. I'm using it for my private services, like * Teslamate, a logging and visulalization software for Teslas * NGinx Proxy Manager, a great tool for the management of web services, including certification management * Ghost, a blogging service * and many