Hetzner PostgreSQL One‑Click: Quick Setup Guide

By Azon Vault On May 10, 2026

Hetzner PostgreSQL One‑Click: A Complete Beginner’s Guide

Setting up a reliable PostgreSQL database can feel daunting, especially when you’re juggling a new project or migrating from a legacy system. Hetzner’s One‑Click PostgreSQL service removes most of the hassle, letting you launch a fully managed database instance in minutes. In this guide we’ll walk through every step, share best‑practice tips, and answer the most common questions.

Why Choose Hetzner’s One‑Click PostgreSQL?

Speed: Deploy a ready‑to‑use PostgreSQL server in under five minutes.
Reliability: Built on Hetzner’s high‑performance SSD storage and redundant network.
Scalability: Easily adjust CPU, RAM, and storage as your workload grows.
Security: Automatic firewall rules, encrypted connections, and regular backups.

Step‑by‑Step Setup

1. Log in to the Hetzner Cloud Console

Navigate to cloud.hetzner.com and sign in with your account. If you don’t have an account yet, create one – you’ll receive €20 credit for testing.

2. Create a New Server

Click "Create Server" on the dashboard.
Choose a location (e.g., Falkenstein or Helsinki) closest to your users for lower latency.
Select the "One‑Click App" tab.
Find PostgreSQL in the list and click "Select".

3. Configure Resources

Pick a server size that matches your expected load. For small projects, the cx21 (2 vCPU, 4 GB RAM, 40 GB SSD) is usually sufficient. You can always resize later.

4. Set Authentication Details

Root password: Choose a strong, unique password. This will be used for the postgres super‑user.
SSH key (optional but recommended): Add your public SSH key for secure, password‑less access.

5. Launch the Instance

Click "Create & Deploy". Hetzner will provision the VM, install PostgreSQL, and start the service automatically. You’ll receive an IP address and login details on the server list page.

Post‑Deployment Checklist

Secure the Database

Log in via SSH: ssh root@YOUR_SERVER_IP
Switch to the PostgreSQL user: sudo -i -u postgres
Set a new password for the postgres role: psql -c "ALTER USER postgres WITH PASSWORD 'new_strong_password';"
Enable pg_hba.conf to require md5 authentication for remote connections.
Open port 5432 only to trusted IPs using Hetzner’s firewall rules.

Enable Automated Backups

Hetzner offers snapshot backups. Schedule a daily snapshot via the "Backups" tab. Store snapshots in a separate project for extra safety.

Performance Tuning Basics

shared_buffers: Set to 25% of total RAM (e.g., shared_buffers = 1GB for a 4 GB instance).
work_mem: Start with 16 MB per connection; adjust based on query complexity.
maintenance_work_mem: Allocate 256 MB for VACUUM/CREATE INDEX operations.

Common Use Cases

Web applications needing a relational DB (e.g., Django, Ruby on Rails, Laravel).
Data‑analytics pipelines that require ACID compliance.
Development and testing environments where fast provisioning is essential.

FAQ

Do I need to install PostgreSQL manually?: No. The One‑Click image comes with PostgreSQL 15 pre‑installed and configured.
Can I upgrade PostgreSQL version later?: Yes. Create a new One‑Click server with the desired version, dump the old database, and restore it.
How much does it cost?: Pricing follows the underlying server size. For example, a cx21 costs €6.90 per month plus optional backup fees.
Is my data encrypted at rest?: Hetzner stores data on encrypted SSDs, and you can enable TLS for client connections.
Can I connect from multiple applications?: Absolutely. Just ensure each app’s IP is allowed in the firewall and use the same PostgreSQL credentials.

Conclusion & Next Steps

Hetzner PostgreSQL One‑Click delivers a fast, secure, and scalable database with minimal setup effort. By following the checklist above you’ll have a production‑ready instance in minutes, ready to support your application’s growth.

Ready to launch? Create your Hetzner server now and start building with PostgreSQL today!

External Reference

For detailed PostgreSQL configuration options, refer to the official PostgreSQL documentation.