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
PostgreSQL
A collection of 14 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
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'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&