All topics

PostgreSQL

8 tutorials · 17 guides

Tutorials

Beginner

How to Install PostgreSQL on Ubuntu 24.04

Install PostgreSQL 18 on a Raff Ubuntu 24.04 VM. Add PGDG, create a database role, verify SCRAM, secure port 5432, and test backup and restore safely.

21 min read
PostgreSQLUbuntu 24.04PostgreSQL 18
Intermediate

How to Self-Host Supabase on Ubuntu 24.04 with Docker Compose

Self-host Supabase on Ubuntu 24.04 with the versioned Docker Compose stack, Caddy HTTPS, secure keys, Postgres and Storage backups, restores, and safe updates.

29 min read
SupabaseDocker ComposeUbuntu 24.04
Intermediate

How to Deploy Odoo on Ubuntu 24.04 with Docker Compose

Deploy Odoo 19 on Ubuntu 24.04 with Docker Compose, PostgreSQL 15, Caddy HTTPS, workers, database lockdown, matched backups, restores, and safe updates.

28 min read
Odoo 19Docker ComposeUbuntu 24.04
Intermediate

How to Back Up PostgreSQL to S3 with Restic on Ubuntu 24.04

Back up PostgreSQL to S3-compatible Raff Object Storage with Restic on Ubuntu 24.04. Automate encrypted dumps, retention, checks, and restore tests.

21 min read
PostgreSQLResticObject Storage
Intermediate

How to Self-Host Plausible Analytics on Ubuntu 24.04 with Docker

Self-host Plausible Analytics CE on Ubuntu 24.04 with Docker Compose, automatic HTTPS, protected secrets, health checks, backups, and safe upgrades.

21 min read
Plausible AnalyticsPlausible CEDocker Compose
Intermediate

How to Deploy a Multi-Container App with Docker Compose on Ubuntu 24.04

Deploy a multi-container Docker Compose app on Ubuntu 24.04 with Node.js, PostgreSQL, Redis, secrets, health checks, private networking, backups, and persistence.

19 min read
Docker ComposeUbuntu 24.04Docker
Intermediate

How to Deploy Gitea with Docker Compose on Ubuntu 24.04

Deploy Gitea on Ubuntu 24.04 with Docker Compose, PostgreSQL, Nginx, HTTPS, SSH clone access, backups, upgrades, and verification steps.

18 min read
GiteaDocker ComposeUbuntu 24.04
Intermediate

How to Self-Host n8n on Ubuntu 24.04 with Docker Compose

Self-host n8n on Ubuntu 24.04 with Docker Compose, PostgreSQL, Nginx, HTTPS, safe firewall setup, backups, restore verification, and updates.

20 min read
n8nDocker ComposePostgreSQL

Guides

For: Technical buyers, developers, founders, and platform teams comparing a migration provider, consultant, tool, or destination platform for production PostgreSQL or MySQL workloads.

Database Migration Services: Costs, Process & Provider Checklist

Compare database migration services by scope, cost, downtime, provider responsibilities, validation, and rollback before choosing a migration provider or consultant.

18 min read
Database MigrationManaged DatabasesBuyer Guide
For: Developers, founders, SaaS teams, and small businesses comparing database hosting services for production applications.

Database Hosting Services: How to Choose for Production Apps

Compare database hosting services for production apps by engine support, backups, PITR, HA, private networking, connections, pricing, migration, and support.

15 min read
Database HostingManaged DatabasesPostgreSQL
For: Developers, founders, SaaS teams, and small platform teams choosing between a self-hosted database on a VPS and a managed database service.

VPS Database Hosting: What Small Teams Should Know

Compare VPS database hosting with managed databases, including control, cost, backups, recovery, networking, and operational ownership for small teams.

15 min read
VPS Database HostingDatabase VPSSelf-Hosted Database
For: Developers and platform teams running self-hosted PostgreSQL or MySQL on block storage and deciding how to monitor, size, back up, and recover database volumes.

Database Storage on Block Volumes: Layout, Monitoring, and Recovery

Plan database storage on block volumes for PostgreSQL and MySQL, including layout, capacity headroom, I/O monitoring, backups, and recovery.

15 min read
DatabasesBlock StorageVolumes
For: Developers, founders, and small platform teams planning a production PostgreSQL or MySQL migration to a managed database or another database host.

Database Migration Checklist for Managed Databases

Use this database migration checklist to assess compatibility, prepare the target, prove recovery, synchronize data, control cutover, validate production, and plan rollback.

18 min read
Database MigrationManaged DatabasesCutover
For: Developers, database operators, SaaS teams, and small infrastructure teams designing PostgreSQL availability, backups, PITR, snapshots, failover, and recovery.

PostgreSQL Replication vs Backups vs Snapshots: What Each Protects

Compare PostgreSQL replication, backups, point-in-time recovery, and snapshots by the failure modes each protects and the recovery gaps each leaves.

14 min read
PostgreSQLManaged PostgreSQLBackup
For: Developers, founders, SaaS teams, and small technical teams deciding whether to buy a managed database service or operate PostgreSQL, MySQL, or another database on their own VM.

Managed Database vs Self-Hosted: What Small Teams Should Choose

Compare managed database vs self-hosted across total cost, control, backups, HA, recovery, security, scaling, and operational ownership for production workloads.

14 min read
Managed DatabasesSelf-Hosted DatabaseDatabase Hosting
For: Developers, founders, and technical teams still choosing among MySQL, PostgreSQL, and MongoDB before narrowing to a two-engine comparison.

MySQL vs PostgreSQL vs MongoDB: How to Choose the Right Database

Compare MySQL, PostgreSQL, and MongoDB by data model, ecosystem, performance, scaling, and operations to narrow a three-engine database decision.

11 min read
DatabaseMySQLPostgreSQL
For: Developers and infrastructure teams choosing SQLite, embedded etcd, or an external datastore for self-managed K3s and high-availability clusters.

K3s High Availability: Embedded etcd vs External Database

Learn K3s default datastore behavior and compare SQLite, embedded etcd, and external PostgreSQL/MySQL/etcd for HA, quorum, backups, and recovery.

18 min read
K3sKubernetesHigh Availability
For: Developers and small platform teams tuning PostgreSQL query latency, indexes, vacuum, locks, and capacity

PostgreSQL Performance Tuning: A Framework for Small SaaS Teams

PostgreSQL performance tuning for SaaS teams: query plans, indexes, vacuum, statistics, locks, connection pressure, and capacity decisions.

15 min read
PostgreSQLPerformance TuningQuery Optimization
For: Developers, founders, database operators, and small platform teams designing PostgreSQL high availability, replication, failover, and production continuity.

PostgreSQL High Availability: Architecture, Failover & Replication

Learn PostgreSQL high availability: compare standby replication, automatic failover, fencing, recovery testing, and managed vs self-hosted trade-offs.

18 min read
PostgreSQLHigh AvailabilityPostgreSQL HA
For: Developers, founders, and small platform teams planning PostgreSQL sizing, connection management, recovery, and production ownership for SaaS applications

PostgreSQL for SaaS Apps: Sizing, Connections, and Production Operations

Understand PostgreSQL for SaaS apps across sizing, connections, pooling, backups, high availability, and managed vs self-hosted production ownership.

14 min read
PostgreSQLSaaSManaged Databases
For: Developers, founders, and small platform teams sizing PostgreSQL connection pools across SaaS apps, workers, autoscaling services, and managed databases

PostgreSQL Connection Pooling: PgBouncer, Limits & SaaS Workloads

Understand PostgreSQL connection pooling, PgBouncer modes, pool sizing, max_connections, and how SaaS teams prevent connection storms in production.

15 min read
PostgreSQLPgBouncerConnection Pooling
For: Developers, founders, and technical teams choosing between PostgreSQL and MySQL for a new application, SaaS product, managed database, or database migration.

PostgreSQL vs MySQL: Differences, Performance & Use Cases

Learn PostgreSQL vs MySQL trade-offs in JSON, extensions, transactions, performance, replication, and recovery. Choose by workload, team, and ecosystem fit.

17 min read
PostgreSQLMySQLDatabase Comparison
For: Developers, founders, SaaS teams, and small platform teams comparing managed PostgreSQL hosting with self-hosted PostgreSQL for production applications.

Postgres Hosting: Managed vs Self-Hosted for SaaS

Compare Postgres hosting for SaaS across managed PostgreSQL and self-hosted PostgreSQL, including cost, connections, backups, HA, recovery, and operational ownership.

14 min read
PostgreSQLPostgres HostingPostgreSQL Hosting
For: Developers, founders, SaaS teams, and technical teams choosing MongoDB or PostgreSQL for a new application, backend, production workload, or database migration.

MongoDB vs PostgreSQL: Which Database Fits Your App?

Compare MongoDB vs PostgreSQL across data modeling, JSON, transactions, performance, scaling, and operations to choose the database that fits your application.

15 min read
MongoDBPostgreSQLDatabase Selection
For: Developers, database operators, founders, and small platform teams planning production schema changes or live database cutovers.

Zero-Downtime Database Migrations: What Actually Works for Small Teams

Plan a zero-downtime database migration with expand-contract, staged backfills, replication cutovers, rollback, and PostgreSQL or MySQL safety checks.

16 min read
Database MigrationPostgreSQLMySQL

Learn something new every week

The tutorials, guides, and comparisons we publish, rounded up in one weekly email. Unsubscribe anytime.

Put it into practice

Spin up a Linux or Windows server and follow any tutorial here on real infrastructure. RDP and SSH ready, 14-day money-back guarantee.

Deploy a server