Postgresus is a modern self-hosted tool designed for convenient and secure management of PostgreSQL backups and monitoring. It is suitable for developers, system administrators, and DevOps engineers who want centralized control over their databases and to ensure data safety without relying on cloud services or third-party platforms.
Main Features
- Scheduled backups for PostgreSQL versions 13–18.
- Notifications in Telegram, Slack, and Discord in case of backup failures or database unavailability.
- Backup storage locally, on S3, or Google Drive.
- Database health check every 60 seconds for quick detection of issues.
- Fully open-source Apache 2.0 license, allowing you to use and modify the tool to fit your needs.
Practical Use
Postgresus is useful in a variety of scenarios:
- For startups and small teams: automates backups and status notifications, saving time and reducing the risk of data loss.
- For DevOps engineers and administrators: allows monitoring multiple databases, tracking errors, and integrating notifications into familiar team communication channels.
- For educational projects and lab environments: Postgresus can be deployed locally via Docker and used for safe testing and experiments with PostgreSQL databases.
Example: If you are running a project with PostgreSQL 15 and want to ensure that backups are created every 6 hours, with instant Telegram notifications in case of failure, Postgresus allows you to set this up in just a few minutes.
Installation
The easiest way to run Postgresus is via Docker. Launch command:
--name postgresus
-p 4005:4005
-v ./postgresus-data:/postgresus-data
--restart unless-stopped
rostislavdugin/postgresus:latest
After this, the web interface will be available at http://localhost:4005, where you can configure database sources, backup schedules, notifications, and storage locations.
Potential Issues and How to Solve Them
Database Unavailability: Postgresus checks the database status every 60 seconds and notifies of any issues. In case of an outage, check the PostgreSQL connection and settings.
Cloud Storage Access Issues: When using S3 or Google Drive, ensure API keys and access permissions are configured correctly.
Docker Container Failures: The container automatically restarts on failure (--restart unless-stopped), but you should monitor host resources.
FAQ
- Q: Which PostgreSQL versions are supported?
A: Versions 13–18. - Q: Can Postgresus be used on production servers?
A: Yes, the tool is designed for working databases, but it is recommended to verify access permissions and host security. - Q: Where are backups stored?
A: Locally, on S3, or Google Drive, depending on your configuration. - Q: Is a separate server required for Postgresus?
A: No, a single host or Docker container with access to the target databases is sufficient. - Q: Can notifications be integrated with other messengers?
A: Currently, Telegram, Slack, and Discord are supported, but functionality can be extended through the Postgresus API.
Cheat Sheet
| Action | Command / Interface | Description |
|---|---|---|
| Start Postgresus | docker run ... | Runs the container with web interface and automatic recovery on failure |
| Check database status | Web Interface → Health Check | Displays availability of all connected databases and recent errors |
| Create a backup task | Web Interface → Backup → Add | Configure source, schedule, and storage location for backups |
| Set up notifications | Web Interface → Notifications | Sends messages to Telegram, Slack, Discord if a backup fails or database is unavailable |
| Backup storage | Local / S3 / Google Drive | Select storage location and configure access permissions |
Conclusion
Postgresus is a convenient self-hosted tool for automating PostgreSQL backup and monitoring. It enables quick setup of regular backups, provides notifications on failures, supports storage both locally and in the cloud, and allows real-time monitoring of database health. With Docker deployment and an open-source Apache 2.0 license, Postgresus is suitable for personal projects as well as corporate servers, ensuring reliable and secure data storage.