Skip to Content
Browse documentation

Manage UAPP PostgreSQL Databases

Inspect PostgreSQL server placement and assigned users, revoke the panel-managed access set and delete databases with recovery precautions.

Open Databases → PostgreSQL → PostgreSQL Databases.

The table shows Database, PostgreSQL Server, Assigned Users and Actions. It reflects account inventory rather than a live database-size or health report.

Remove a user assignment

Inspect the assigned-users controls and select the exact user/database pair. The view checks that both resources are in the account inventory and on the same server. The removal helper revokes privileges on existing tables, sequences and functions in the public schema, the public schema itself and the database.

This removes the panel-managed grants; it does not delete the role or its owned objects. Independently granted privileges, role membership and ownership can affect actual access or cause later role deletion to fail. Verify effective access when those have been managed outside UAPP.

Assignment removal is blocked in demo mode. Use Assign User to Database to grant access deliberately.

Delete a database

  1. Preserve a usable backup and review application dependencies.
  2. Confirm the full prefixed name and server.
  3. Open Delete, review the confirmation and submit.
  4. Check the response and actual resulting state.

Delete is not an access toggle

Dropping a database removes its data. To disconnect a user, use assignment removal instead. This page provides no undo operation.

Demo mode blocks deletion. Server dependencies or active connections can prevent a drop; investigate the reported failure rather than repeatedly retrying. A missing inventory row alone is not an integrity or recovery test.