Docker: Meilisearch database version incompatible
This is a quick and dirty solution to upgrade a Mailisearch container in Docker to a new version
Topic
PostgreSQL
A collection of 11 issues
CrateDB: Use Docker Compose for CrateDB
"CrateDB is a distributed SQL database management system that integrates a fully searchable document-oriented data store."
To see if CrateDB fulfills your needs, the easiest way is to use create a Docker container using Docker Compose. Here's how I do that:
services:
db:
image: crate
hostname:
PostgreSQL: Use Docker Compose for PostgreSQL 18 beta 1
This is how to use Docker Compose to start a PostgreSQL container using the 18beta1 version
PostgreSQL: Update extensions
This is how to update an extension in PostgreSQL
Oracle: Database Appliance (ODA) used for other things
My thoughts on what you could also do with your ODA
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