Postgres healthcheck in Docker Compose
The pg_isready healthcheck block for the official postgres image, why a socket probe lies on first boot, the TCP fix, and depends_on with service_healthy.
#postgres
Filtering by topic #postgres · clear
Is Supabase free? Cloud limits vs self-hosted
Supabase has a real free plan: 500 MB of database and a project that pauses after a week idle. Compare it with self-hosting the stack on your own VPS.
pgvector HNSW on a small VPS: how much RAM?
Size a pgvector HNSW index before you build it: the byte arithmetic, maintenance_work_mem, ef_search, and what to do when it stops fitting in RAM.
Managed Postgres vs self-hosting on a VPS
Managed Postgres or your own VPS: the four jobs that transfer, backups, upgrades, failover and monitoring, and how to work out where the cost crosses over.
Self-host Zitadel on a VPS with Docker
Zitadel wants 4 cores and 8GB. Set up Postgres, the masterkey, TLS, SMTP and backups on one VPS, and learn what an upgrade does to your database.
Postgres connection pooling on a VPS
Every Postgres connection is a process with its own memory, so a 4 GB VPS runs out of RAM long before max_connections. What a pooler fixes, and what it breaks.
Self-host Planka: open-source Kanban board
Deploy Planka on a VPS with Docker Compose: Postgres, Traefik, the admin bootstrap variables, and the BASE_URL setting that breaks your logins.
Back up and restore Immich on a VPS
What an Immich backup must contain, why copying the Postgres data directory is not a backup, and the restore mistake that leaves a timeline empty.
Self-host Supabase on a VPS with Docker
Run the official Supabase Docker stack on a server you own: the secrets you must replace, what the fourteen services do, RAM needs, backups, and updates.
Self-hosted URL shortener with Shlink
Run your own URL shortener on a VPS with Shlink and Docker Compose: short domain DNS, Postgres, API keys, the web client, QR codes and click stats.
Listmonk: self-host your newsletter on a VPS
Install Listmonk on Ubuntu 24.04 with Postgres, config.toml, a systemd unit and TLS, then connect SMTP and understand what deliverability really costs.
Run Nextcloud on a VPS: Docker, TLS, backups
Run Nextcloud on your own VPS with Docker Compose, Postgres, Redis and a TLS reverse proxy, plus the backup and upgrade steps that keep your data recoverable.