Is it true that it is IMPOSSIBLE to have readonly backup user in Postgresql ? I tried to hack around this as I've been advised on IRC channel that you simply can't have a backup only user with no ownership privileges, but I just find it very strange so I want to make sure I'm not missing something.
Below is what I tried but it doesn't not get me the results - as when I do pg_dump on a given table I'm getting
Permission denied for relation...:
GRANT SELECT ON ALL TABLES IN SCHEMA public TO backup; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO backup; GRANT SELECT, USAGE ON ALL SEQUENCES IN SCHEMA public TO backup; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, USAGE ON SEQUENCES TO backup;
Any help would be greatly appreciated!