pg_dump_anon: lack of permissions to work with "anon" schema (and tables inside it)
(version: fresh code from the master branch)
I've followed the setup instructions, ending up with this error when trying to use pg_dump_anon:
$ ./bin/pg_dump_anon.sh -U tester_anon -d test_anon -h localhost
ERROR: permission denied for schema anon
LINE 1: SELECT anon.version();
^
ERROR: Anon extension is not installed in this database.
The extension is installed, we just don't have permissions:
$ sudo -u postgres psql test_anon -c 'select anon.version()'
version
---------
0.7
(1 row)
Edited by Nikolay Samokhvalov