PostgreSQL read-only user for pg_dumpall
Backups from a normal user are a nightmare. If you're using PostgreSQL on Linux, I'd recommend relying on sudo (and the /etc/sudoers file) to accomplish this, so that a given specific user can sudo -u postgres pg_dumpall &lt;params&gt; with specific parameters, so that's all they can do as user postgres (and therefore have no write access to the database).