Category: Databases

Migrating PostgreSQL Databases Between Servers Using Docker

September 12, 2025

Migrating PostgreSQL databases between servers can be tricky when client and server versions don’t align. Using Docker, you can run the exact PostgreSQL client version you need for pg_dump and pg_restore without installing multiple versions on your system. This guide walks through installing Docker, checking versions, performing dumps and restores without creating roles or databases, and using automated version-smart scripts for smooth migrations.

Quick Reference Guide to PostgreSQL Commands

September 12, 2025

A quick reference guide to essential PostgreSQL commands. Learn how to list databases, users, tables, schemas, and check environment details directly from the psql shell.

How to Run PostgreSQL in Docker on a Plesk Server

September 11, 2025

Learn how to run PostgreSQL 17 in a Docker container on your Plesk server with persistent storage, secure connections, and simple backups. This step-by-step guide covers both the Plesk UI and Docker CLI so you can choose the workflow that fits your needs.

How to Enable and Use the Slow Query Log on Aurora MySQL Serverless

September 6, 2025

Enabling the slow query log in Amazon Aurora MySQL Serverless is one of the easiest ways to diagnose performance bottlenecks. With just a few parameter changes, you can capture queries that run longer than expected and send them to either a MySQL table for quick analysis or to CloudWatch Logs for dashboards and alerts. In this guide, we’ll walk through enabling the feature, viewing results, and using CloudWatch Logs Insights to surface your top slow queries.

PostgreSQL 17 + pgvector on Plesk (Docker): A Practical Setup Guide

September 3, 2025

TL;DR: Build a small derived Docker image that layers the pgvector extension onto the official postgres:17 image, deploy it with the Plesk Docker extension, persist data to the host, then CREATE EXTENSION vector; in your database. You’ll be up and running in minutes—with clean upgrades, backups, and security baked in. What You’ll Build A PostgreSQL 17 container on a Plesk server (Ubuntu 22.04 assumed) The pgvector extension installed and available to all databases Persistent storage on the host at /var/lib/postgres/pg17-data A repeatable, pinned build (no “latest” surprises) Estimated time: 20–30 minutes Prerequisites Plesk Obsidian with the Docker extension installed SSH access with sudo privileges Docker engine available on the host Basic familiarity with Plesk’s Docker UI (Add Container, environment variables, volumes, ports) Why a derived image? We pin the Postgres major version and the pgvector version for reproducibility and security. You can rebuild the image at any time