Create a readonly user in Postgres

CREATE USER backup_user with ENCRYPTED PASSWORD ' qux94874 '; GRANT CONNECT on DATABASE foo_db to Backup_user; GRANT CONNECT on the DATABASE bar_db to backup_user;\c foogrant USAGE on the SCHEMA public to Backup_user; GRANT SELECT on all sequences in the SCHEMA public to Backup_user; GRANT SELECT on all TABLES the schema public to backup_user;\c Bargrant USAGE on the schema public to Backup_user; GRANT SELECT on all sequences in the SCHEMA public to Backup_user; GRANT SELECT on all TABLES in the SCHEMA public to Backup_user;

Create a readonly user in Postgres