postgres=# \c db
You are now connected to database "db" as user "postgres".
postgres=# GRANT CONNECT ON DATABASE db TO db_reader;
GRANT
postgres=# GRANT USAGE ON SCHEMA public to db_reader;
GRANT
postgres=# GRANT SELECT ON ALL TABLES IN SCHEMA public TO db_reader;