Creating a PostgreSQL Database

Creating a Database#

1. In the sidebar, go to PostgreSQL
2. Click Create Database
3. Select the account to create the database under
4. Enter a database name (letters, numbers, underscores only)
5. Click Create Database

Opterius will:

• Prefix the name with your account username (e.g. myuser_yourname) to ensure uniqueness
• Create a matching PostgreSQL user (myuser_yourname_u)
• Grant that user full privileges on the database
• Display the generated password once — copy it immediately

[!WARNING] The database password is shown only once, immediately after creation. There is no way to retrieve it later — you can only reset it on the database details page.

After Creation#

You are redirected to the database details page showing:

• Database name and username
• Connection details (host, port)
• Database size and table count
• A connection string you can paste into your app's config

Changing the Password#

On the database details page, use the Change Password panel on the right. Enter a new password and click Update Password. The change takes effect immediately.

Deleting a Database#

On the database details page, scroll to Danger Zone and click Delete Database. You must confirm your panel password. This permanently drops the PostgreSQL database and its user — all data is gone.

Next Steps#

• Connecting to PostgreSQL
• PostgreSQL Overview