Docker: Run PgBouncer using Docker Compose
Connecting to a PostgreSQL directly is the easiest way. But sometimes, you need a Connection Pool. This is how you can use PgBouncer in Docker Compose.
Topic
postgres
A collection of 13 issues
Oracle: Access PostgreSQL from Oracle
I'll show how to access PostgreSQL databases from Oracle
PostgreSQL: Upgrade to version 18 in-place
This is how I update my PostgreSQL instances to 18 using Docker Compose and PgAutoUpgrade
Docker: Meilisearch database version incompatible
This is a quick and dirty solution to upgrade a Mailisearch container in Docker to a new version
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
PostgreSQL: Use Docker Compose for PostgreSQL 18 beta 1 [Update: or the first Release Candidate RC1]
This is how to use Docker Compose to start a PostgreSQL container using the 18beta1 version (or 18rc1)
PostgreSQL: Update extensions
This is how to update an extension in PostgreSQL
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'd
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