Databases
PostgreSQL
Versions, defaults, connection addresses, data directory and backups for PostgreSQL.
Updated
Cloud runs PostgreSQL from the official postgres image, at the major version you choose. Databases covers creating, the Connection card, passwords and public access for every engine; this page holds what is particular to PostgreSQL.
| Setting | PostgreSQL |
|---|---|
| Versions offered | 18, 17, 16, 15. The form lists them as "PostgreSQL 18" and so on, newest first, and chooses 18 |
| Port inside the project | 5432 |
| Database name | app, unless you choose another before the first start |
| User | app, unless you choose another before the first start |
| Password | Generated as 32 letters and digits, or your own of 12 to 128 letters, digits, dots, hyphens, underscores or tildes |
| Address scheme | postgresql:// |
| Data directory | /var/lib/postgresql/18/docker on version 18, /var/lib/postgresql/data on 17, 16 and 15 |
Connection addresses
Copy both from the Connection card, which fills in the password, the host and the public port for you.
postgresql://app:<password>@<internal host>:5432/apppostgresql://app:<password>@<public address>:<public port>/appWith another database name or user, those take the place of app in the address. The public port is one from 20000 to 29999.
Choosing the version
The version, the database name and the user are written into the data at the first start and cannot change after it. Choose them on the create form, or on the Connection card before you press Deploy for the first time.
Backups
Automatic backup is Daily by default where platform backup storage is available, and can be Weekly, Monthly or No automatic backup. The dump covers the database named at creation.
Backup before deployment, on the database's Storage section, takes a dump before each deployment of the database.
A dump downloads as a gzip file named after the service and the time of the backup, ending in
.sql.gz.
Backups covers schedules and downloads. The console's Restore is not available yet; Back up a database and restore it gives the manual path.