Linux · PostgreSQL · Self-hosting
Build it. Test it.
Write it down.
Practical Ubuntu, PostgreSQL, and self-hosting guides.
Test environments, reproducible steps, and verified results.
Latest tested tutorials
-
Cloudflare · Caddy
Expose a Test Website with Cloudflare Tunnel and Caddy
Test public HTTPS through a temporary tunnel, preserve the real client IP, reject forged forwarding headers, and close the test entry point.
-
WordPress
Install WordPress Natively under /opt on Ubuntu 24.04
Set up Nginx, PHP-FPM, and MariaDB without Docker, protect core files, and test login, uploads, matched backups, and restoration.
-
systemd
Run Scripts with systemd Services and Timers on Ubuntu 24.04
Use a dedicated account, test a real timer trigger, reproduce an exit-code failure, and verify recovery after reboot.
-
PostgreSQL
Investigate PostgreSQL Slow Queries and Lock Waits
Observe real test queries and blocked transactions, verify slow-query logging, and compare execution plans before and after an index.
-
PostgreSQL
Troubleshoot PostgreSQL 16 Connection Errors
Reproduce peer authentication, incorrect password, and wrong-port errors, then verify recovery using a real application connection.
-
PostgreSQL
Separate PostgreSQL Application and Read-Only Roles
Test table and schema permissions, read-only access, write restrictions, and default privileges for future tables.
-
PostgreSQL
Secure Remote PostgreSQL 16 Connections with TLS and SCRAM
Configure verify-full, restrict source addresses, and test rejection of plaintext, wrong certificates, passwords, and unauthorized clients.
-
PostgreSQL
Migrate PostgreSQL 16 to a New Ubuntu Server
Move a sample database between two isolated Ubuntu servers and verify checksums, rows, ownership, indexes, and reboot persistence.
-
PostgreSQL
Back Up PostgreSQL 16 on Ubuntu 24.04 with systemd
Build a daily logical backup with checksums and locking, verify a separate restore, and plan retention and independent copies.
-
PostgreSQL
Install PostgreSQL 16 on Ubuntu 24.04: Native Setup and Restore Test
Install PostgreSQL 16 without Docker, create an application role, verify SQL access, and restore a backup into a separate database.