Databases
PostgreSQL databases are used to store and manage your application's data, making it accessible and organized for your applications and services.
On the Databases page, you can view and manage your PostgreSQL databases.
The page provides a table containing the users databases, along with options related to them:
- Databases: Here, you can view database sizes and all users assigned to each database.
Available options on the Databases page are:
- View Databases and assigned Users
- Create a new database
- Import or export a database
- Delete a PostgreSQL Database
System databases (postgres, template0, template1) are always listed separately and cannot be deleted or imported into. Use the Show system databases switch to display or hide them in the table.
Create a PostgreSQL Database
To create a new PostgreSQL database, click on the "New Database" button and fill in the name of the new database.
Database Actions
Each database row has these actions:
- Import: only shown if the Import feature is enabled for your account. Opens the Import page with this database pre-selected.
- Export: opens a small panel where you choose the export Format,
SQL(.sql) orGZIP(.sql.gz), and Destination (download to your Browser, or save to a Files path under/var/www/html/), then click Export. The export is made withpg_dumpand can be imported back on the Import page. - Delete: permanently deletes the database.
Bulk Actions
Tick the checkbox of one or more databases, or the checkbox in the table header to select every database shown by the current search. A bar appears at the bottom of the page with the number selected, a Clear link and these actions:
| Action | What it does |
|---|---|
| Export | Exports each selected database as a .sql.gz file to the folder you enter under /var/www/html. |
| Assign user | Gives the user you pick all privileges on the selected databases. |
| Remove user | Removes the user you pick from the selected databases. |
| Delete | Permanently deletes the selected databases. |
System databases can't be selected.
Click an action, confirm it, and it runs on the selected databases one after another. When it's done the page reloads with a notice listing the databases it worked for, or which ones failed and why.
Delete a PostgreSQL Database
To delete an existing PostgreSQL database, click on the "Delete" button next to the database name in the table.
The button turns into Confirm with a 5-second countdown. Click it again before the countdown ends to delete the database; otherwise it reverts to Delete.
⚠️ Deleting a PostgreSQL database will permanently delete all tables and data for that database.
The New Database and Database Wizard actions are only available while the PostgreSQL service is running.