8.3.9. PostgreSQL users

Each instance always has the hoster_control system user, which is used to manage the service via the control panel (creating databases, users, etc.).

Users are managed in the "PostgreSQL" section on the "Databases" tab — the list is expanded by the "Users" button:

The list of all users and database binding information is displayed in the "PostgreSQL" section on the "Users" tab:

Create

When you create a database, you can immediately create a user with the same name for it.
  1. On the "Databases" tab in the user list, click "Create user".
  2. Specify login, password and click "Create".

Bind

  1. On the "Databases" tab in the user list, click "Bind existing user".
  2. Select a user from the list of existing users and click "Bind".

Change password

Attention!

User passwords are not stored publicly on the hosting. If you lose your password, you can only set a new one.
  1. On the "Databases" tab, in the user row, click "Change password" or on the "Users" tab, in the user row, click 📝.
  2. Specify a new password and click "Change".

Configure privileges

  1. On the "Databases" tab, in the user row, click "Change".
  2. Select privileges (available CREATE, TEMPORARY, CONNECT) and click "Change".

Delete

Only users who are not associated with any of the databases (not binded or owned) can be deleted.

On the "Databases" tab in the user row, click "Delete access to database" or on the "Users" tab in the user row, click ❌ and confirm the operation.

Content