In order to add a database to pgTop you'll have to create a dedicated role with limited privileges (this way you can be sure that pgTop cannot access any of your data). This role will have the public privileges by default, which are assumed to be very limited.

Run the command below in your PostgreSQL database to create the pgTop role:

CREATE role pgtop WITH LOGIN NOINHERIT PASSWORD 'strong-password-goes-here';

The password is auto-generated on this page only. You can reuse it or choose another one.

If you have trouble setting this up get in touch at pgtop@alby.fr

Build your connection URI with the required info. The connection format is: postgres://role:password@url:port/schema.
The role name must be pgtop.