The Nxeon Blog
Guides for people who run their own servers.
Straight-talking tutorials and comparisons on VPS hosting, game servers, Linux and security. No fluff, just what actually works. 346 guides from the team that runs the servers.
Search results
16 guides for “postgresql” in Tutorials · Clear search
How to Set Up Health Checks and Auto-Restart for Services
Services crash. With systemd restart policies, watchdogs and simple health checks, yours come back automatically instead of staying down until you notice.
How to Set Up Automated Backups on a VPS
A backup you never tested isn't a backup. Build an automated, offsite, restorable backup routine for files and databases with rsync, cron and the 3-2-1 rule.
How to Self-Host Grafana and Prometheus for Monitoring
The classic open-source monitoring stack. Install Prometheus and Grafana on a VPS with Docker, collect server metrics, and build dashboards that actually help.
How to Self-Host n8n (Workflow Automation) on a VPS
A self-hosted Zapier alternative with no per-task fees. Install n8n on a VPS with Docker and HTTPS and automate anything with hundreds of integrations.
How to Install code-server (VS Code in the Browser)
Run VS Code in your browser from your VPS: install code-server on Ubuntu 24.04, secure it behind Nginx with HTTPS, and code from anywhere.
How to Run Staging and Production on One VPS
Host both a staging and production environment on a single VPS: separate directories, ports, subdomains, databases, and Nginx server blocks.
How to Install Gitea (Self-Hosted Git) on a VPS
Run your own lightweight GitHub alternative: install Gitea on Ubuntu 24.04 with its own user, a database, systemd, and an Nginx reverse proxy.
How to Deploy a Django App to a VPS
Deploy Django on Ubuntu 24.04 for production: Gunicorn, a systemd service, static files with collectstatic, PostgreSQL, and Nginx.
How to Install Redis on a VPS
Install Redis on Ubuntu 24.04, turn on a password and persistence, and use it as a cache or session store for your app.
How to Install MongoDB on Ubuntu
Install MongoDB Community Edition on Ubuntu 24.04 from the official repo, enable authentication, and create your first database and user.
How to Install PostgreSQL on a VPS
Install PostgreSQL 16 on Ubuntu 24.04, understand roles and the postgres user, and create a database and app role with the right privileges.
How to Install and Secure MySQL on Ubuntu
Install MySQL 8 on Ubuntu 24.04, lock it down with mysql_secure_installation, and create an app database and user the right way.
Deploy your first server in under a minute.
Creating an account is free and takes no card details. Every guide here runs on a Nxeon VPS or game server.