PostgreSQL: Update extensions
This is how to update an extension in PostgreSQL
Topic
postgres
A collection of 7 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