Category Archive

PostgreSQL

PostgreSQL guides: installation, upgrades, performance, high availability and migrations.

Shield and padlock in front of a database

PostgreSQL Security Guide: Authentication, Authorization, RLS, Encryption and Auditing

PostgreSQL security in five layers: authentication, the role and privilege model, Row-Level Security, encryption and audit logging with pgAudit, plus...

November 11, 2026

Database with masked record cards

Data Masking in PostgreSQL: Handling Sensitive Data in Test Environments

Static and dynamic data masking in PostgreSQL: finding personal data, masking methods, masking scripts for test environments, view-based masking and...

November 11, 2026

Two databases connected by a data bridge

Migrating from Oracle and SQL Server to PostgreSQL: Cost, Risk and Fit Analysis

When does moving from Oracle or SQL Server to PostgreSQL make sense? License savings versus migration cost, technical differences, complexity...

November 10, 2026

Isometric illustration of an old database cylinder being upgraded to a newer one over a data bridge, symbolising the PostgreSQL 14 end of life upgrade plan

PostgreSQL 14 End of Life (November 2026): Upgrade Plan with pg_upgrade or Logical Replication

PostgreSQL 14 reaches end of life on November 12, 2026. Compare pg_upgrade, logical replication, dump/restore and cloud upgrades, and plan...

November 2, 2026

Isometric illustration of a database installed on a server, a Windows desktop and a container

How to Install PostgreSQL 18 on Ubuntu, Windows and Docker: Step by Step

A step-by-step guide to installing PostgreSQL 18 on Ubuntu 24.04, Windows and Docker, with secure roles, remote access, Turkish ICU...

November 2, 2026

Isometric illustration of a PostgreSQL database with extension modules, a JSON document and a monitoring panel

What Is PostgreSQL? Features, Use Cases and How It Compares with SQL Server

What is PostgreSQL, how does it work and when should you choose it over SQL Server? A guide to its...

November 2, 2026

Autobase ile kurulan üç sunuculu yüksek erişilebilir PostgreSQL kümesi

Building a High-Availability PostgreSQL Environment with Autobase: What to Check Before Production

What to change in the defaults when you build a high-availability PostgreSQL environment with Autobase, Patroni, etcd and PgBouncer: synchronous...

November 2, 2026

PostgreSQL best practices: veritabanı, güvenlik kalkanı ve kontrol listesi

PostgreSQL Best Practices: 10 Core Rules for Production

10 core rules for running PostgreSQL safely and fast in production: tested backups, automatic failover, connection pooling, memory settings, security,...

November 2, 2026