Install this app
In your Cloudron dashboard, open the App Store, choose "Community apps" and paste this URL:
https://git.cloudron.io/playground/postgresql-app/-/raw/master/CloudronVersions.json
Description
About
A standalone PostgreSQL 18 server for clients outside of Cloudron, with a web panel to manage roles and databases.
- Connections are TLS 1.3 only, using the app domain's certificate
- Passwords use SCRAM-SHA-256 and are generated by the panel
- Remote access is blocked until a network is added to the allowlist
- Each role only gets access to the databases it owns
- Sign in with Cloudron. Admins manage roles, databases and allowed networks. Roles are owned by Cloudron users and groups, every owner has an own login
- Users can create, download and restore snapshots of their databases
- Users can upload pg_dump archives and import them into their databases
- Backups are logical dumps taken by Cloudron's backup, snapshots stay on the server and are not part of them
Recent Changes
Initial version with PostgreSQL 18.6
Remote access over TLS 1.3 with SCRAM-SHA-256, blocked until a network is added to the allowlist
Admin panel with Cloudron login: roles, databases, allowed networks, audit log
Roles are owned by Cloudron users and groups. Every owner has an own login, it is removed when the user is no longer an owner
Owners can create databases up to a limit set by the admin
Snapshots on demand and on a schedule, download as .dump or .sql, restore into a staging database that is swapped in
Import of uploaded pg_dump archives with SHA-256 checks
Progress display for snapshots, restores and imports