title: pg_dump query LOCK_TABLE on Hasura
body: <p>I'm trying to get a backup of my database using
  <a href="https://devcenter.heroku.com/articles/heroku-postgres-backups" rel="nofollow noreferrer">https://devcenter.heroku.com/articles/heroku-postgres-backups</a></p>
  <p>But when I run this command heroku pg:backups:capture --app [app_name], I get the following error:</p>
  <pre class="lang-none prettyprint-override"><code> ▸    An error occurred and the backup did not finish.
   ▸
   ▸    waiting for upload to complete
   ▸    pg_dump: error: query was: LOCK TABLE &quot;topology&quot;.&quot;topology&quot; IN ACCESS SHARE MODE
   ▸    upload finished successfully
   ▸    waiting for pg_dump to complete
   ▸    pg_dump finished with errors
  </code></pre>
  <p>When I look at the logs, I get the following:</p>
  <pre class="lang-none prettyprint-override"><code>=== Backup Logs
  2020-07-15 20:39:51 +0000 pg_dump: last built-in OID is 16383
  2020-07-15 20:39:51 +0000 pg_dump: reading extensions
  2020-07-15 20:39:51 +0000 pg_dump: identifying extension members
  2020-07-15 20:39:51 +0000 pg_dump: reading schemas
  2020-07-15 20:39:51 +0000 pg_dump: reading user-defined tables
  2020-07-15 20:39:51 +0000 pg_dump: error: query failed: ERROR:  permission denied for schema topology
  2020-07-15 20:39:51 +0000 waiting for upload to complete
  2020-07-15 20:39:51 +0000 pg_dump: error: query was: LOCK TABLE &quot;topology&quot;.&quot;topology&quot; IN ACCESS SHARE MODE
  2020-07-15 20:39:52 +0000 upload finished successfully
  2020-07-15 20:39:52 +0000 waiting for pg_dump to complete
  2020-07-15 20:39:52 +0000 pg_dump finished with errors
  </code></pre>
  <p>I don't have a table called &quot;topology&quot;, which is why I'm confused why I'm having this error. I really would like to get backups using Heroku rather than pg_dump, because then I can simply plug the backup's Database URL into a new Hasura GraphQL engine instance.</p>
  <p>Does anyone know why I might be getting this error&gt;</p>