Limits, pausing and deleting a database
The limits your databases run with, what a pause means and how deleting a database works.
Limits
DB Settings > Engine Parameters & Guard Limits shows the live Statement Timeout, Idle Transaction Timeout, Connection Limit and Query Work Memory for your database. Usage & Billing shows your database count and maximum connections per database. See Usage and the free allowance.
Pausing
You do not pause a database yourself. An account is paused only for payment reasons: the balance ran out, or unpaid invoices passed the grace period. Connections, functions and container traffic stop, but no data or databases are deleted. Adding funds or paying resumes everything. See When your balance runs low or empty.
Delete a database
- Open Databases > DB Settings, Danger Zone: Delete Database.
- Choose Delete Database name....
- Type the database name and confirm.
The dialog says this cannot be undone: all tables, schemas and records and the role credentials are removed. The project and its other resources stay. Download an export first. See Restore, download and import backups.
Good to know
- Deleted databases are not offered back in the Console. If you delete one by mistake, contact support immediately; recovery is not guaranteed.
- Deleting a project needs the database tables removed first. See Project settings.
More guides in Console: databases
Create a database
Add a PostgreSQL database to a project, choose its version and extensions, and manage several databases in one project.
Connection strings, direct and pooled connections
Find your host, port and credentials, choose between the pooled, regular and direct connection, and test that they work.
Your database's own address
Use the per-database address shown on the Connection page, what is faster about it, and how to rename it safely.
The SQL editor
Run queries and scripts against your database from the Console, use templates and history, and understand the safety limits.
Import data into a database
Bring a database over from another host, or upload a .sql or .sql.gz dump, from the Backups page.
Extensions
See which PostgreSQL extensions are available for your database, enable or disable them and understand "needs approval".