<kynn@xxxxxxxxx> writes: > When I run pg_dump I get this error: > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: permission denied for schema test > pg_dump: The command was: LOCK TABLE test.__proc IN ACCESS SHARE MODE > I can't find out what transaction is responsible for this lock. What lock? The error is "permission denied". It looks like whatever user you're running pg_dump as doesn't have USAGE permission on that schema. regards, tom lane
