User for PostgreSQL monitoring

To be able to monitor a PostgreSQL instance, it is necessary to create a monitoring user with restricted permissions.

First we connect to the instance:

 psql "host=host port=5432 dbname=db [email protected] sslmode=require"

We create the user:

 CREATE USER user_readonly LOGIN PASSWORD 'userpassword';

Add read permissions to the user:

 GRANT CONNECT ON DATABASE my_database TO user_readonly;
 GRANT USAGE ON SCHEMA public TO user_readonly;
 GRANT SELECT ON ALL TABLES IN schema public TO user_readonly;