PostgreSQL, MySQL, MariaDB and Redis from the Marketplace are your own database server, reachable from anywhere over an encrypted (TLS) connection.
Find the connection details
Open your database's page in the portal. Under Connection details on the Overview tab you find:
- Host and Port,
- Database: defaultdb (not for Redis),
- Username and Password (click Show or Copy),
- a Connection string: click Copy with password to paste it straight into your app.
| Database | Port |
|---|---|
| PostgreSQL | 443 |
| Redis | 443 (rediss://, with TLS) |
| MySQL and MariaDB | its own port, shown under Connection details |
Allow only your own addresses
- Under Internet access, keep Allow connections from the internet ticked. TLS and the password are always required.
- Under Only from these IP addresses, enter one address or range per line, such as 203.0.113.7 or 198.51.100.0/24. Leave it empty to allow any address. Add my IP adds the address you're using now.
- Click Save access. It takes about a minute.
Set a new password
Under Password, click Set a new password and confirm. Apps using the old password stop connecting until you update them. Redis restarts for a few seconds; your data is kept.
Good to know
- Backups cover the defaultdb database. You can create more databases and users on your server; keep important data in defaultdb. See How do backups and restores work for my app?
- Redis has a memory limit set from your size. When it's full, writes are refused; no keys are removed.
- Viewers in a shared project see the details but not the password.
