How to create a PostgreSQL database and user

For hosting customers · Updated 2026-10-29

On this page
  1. Steps
  2. Connection details
  3. Good to know
  4. Common questions

Some applications (Django, Rails, Odoo, many Node.js apps) prefer PostgreSQL. It works like MySQL in the panel: create a database, create a user, and add the user to the database.

Steps

  1. Log in to the control panel (https://<server>:2083).
  2. Open PostgreSQL Databases in the menu (section Databases).
  3. Under Create database, enter a name, for example app, and click Create. It is called username_app.
  4. Under Create database user, enter a name and a password (or click Generate), then click Create. Copy the password now.
  5. Under Add user to database, choose the User and the Database and click Grant all privileges.

Connection details

SettingValue
Hostlocalhost (or 127.0.0.1)
Port5432
Databaseusername_app
Userusername_app
Passwordthe user's password

Example connection string:

postgresql://username_app:your-password@localhost:5432/username_app

From the command line (Terminal or SSH):

psql -h localhost -U username_app username_app

Good to know

  • Every user added to a database has full rights on everything in it, whoever created the tables. Several users can share one database without permission problems.
  • Users cannot create databases or other users; do that on this page.
  • Each user can have up to 20 connections at the same time.
  • Names: lowercase letters, digits and _, up to 32 characters after the prefix.
  • MySQL and PostgreSQL databases count together toward your plan's database limit.
  • PostgreSQL databases are reachable only from this server, not from other computers.
  • To remove access, click the × next to the user under Privileged users. Delete next to a database removes it with all its data.

Common questions

How do I browse tables or run a query?

Click Open next to the database for the built-in tool. See PostgreSQL database tool.

My app says "too many connections for role". Why?

The user has 20 connections open at once. Lower your app's connection pool size, or use a second user for another app.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.