Key Features
Automatic Scaling
Zerops automatically scales your PostgreSQL service based on actual database usage:- Vertical auto-scaling for CPU, RAM, and disk resources
- Configure minimum and maximum resource limits
- Choose between shared or dedicated CPU modes
- Set custom scaling thresholds
High Availability Mode
Run PostgreSQL in highly available mode for production environments:- 3 database containers with automatic failover
- 2 free database proxies for connection management
- Containers distributed across different physical machines
- Redundant data storage in 3 identical copies
- Automatic recovery from container or machine failures
- Dedicated read replica port (5433) for improved performance
Single Container Mode
For development and non-critical environments:- One container with vertical scaling
- Cost-effective for testing and development
- Full PostgreSQL functionality
Automated Backups
- Encrypted backups using
pg_dump - Configurable retention policies
- Manual and scheduled backups
- Protected tags for important snapshots
- Stored in isolated object storage
Built-in Management
- Default database and user created automatically
- Environment variables for easy connection
- Support for PostgreSQL plugins and extensions
- Web-based management tools (AdminerEvo, phpMyAdmin)
- Command-line access via VPN
Supported Versions
Zerops supports multiple PostgreSQL versions. Choose the version that best fits your application requirements when creating the service.Connection Options
Internal Connections
Connect from services within the same Zerops project:- Private network with no SSL/TLS required
- Use service hostname and port 5432
- Environment variables available
- Read replicas on port 5433 (HA mode only)
Remote Connections
Connect from outside Zerops:- VPN access - Secure connection via Zerops VPN
- Direct IP access - TLS-encrypted connections via pgBouncer
- IPv6 available by default, IPv4 with add-on
Quick Start
Create PostgreSQL Service
Create a new PostgreSQL service using Zerops GUI or zCLI.
Get Connection Details
Find connection details in the service dashboard under Peek access details or use environment variables.
Connect Your Application
Use the connection string or individual parameters to connect from your application or management tool.
Manage Users and Databases
Create additional users and databases as needed using management tools.
Next Steps
Create PostgreSQL Service
Set up a new PostgreSQL service with GUI or zCLI
Connect to PostgreSQL
Learn connection methods for internal and remote access
Manage Users & Databases
Manage users, databases, and plugins
Backup & Restore
Configure backups and restore your data