Skip to Content
Browse documentation

Create a UAPP PostgreSQL User

Create an account-prefixed PostgreSQL login role with configured server and password, then grant access to a database on that server.

Open Databases → PostgreSQL → Create PostgreSQL User.

FieldRequirement
UsernameRequired suffix with alphanumeric endpoints and letters, digits, underscores or hyphens internally.
PostgreSQL serverRequired offered server; choose the intended database's server.
PasswordRequired strong unique password; retain it securely.

The resulting role is hostinguser_suffix, with a full-name limit of 63 characters. The displayed suffix allowance is 62 minus the hosting-username length. Do not repeat the prefix in the suffix field.

Enter the fields, review the full name/server and submit. Existing recorded usernames are rejected. Check PostgreSQL Users and assign the role to its database before configuring the application.

Creating a role alone does not grant database/object access or open network connections. There is no Access Host field here; server authentication and network policy are separate.

Demo creation still submits

The demo path replaces the supplied password with a generated value and can still create the role. Do not submit a sample merely to preview the form.

After a failure, review actual server and inventory state before retrying. Verify application authentication after setup and keep the password private.