title: Copy a postgres database without LOCK permissions
body: <p>I need to copy a postgres DB from one server to another, but the credentials I have do not have permission to lock the database so a pg_dump fails.  I have full read/update/insert rights to the DB in question.</p>
  
  <p>How can I make a copy of this database?  I'm not worried about inconsistencies (it is a small database on a dev server, so minimal risks of inconsistencies during the extract)</p>
  
  <p>[edit] Full error:</p>
  
  <pre class="lang-none prettyprint-override"><code>$ pg_dump --username=bob mydatabase &gt; /tmp/dump.sql 
  pg_dump: SQL command failed 
  pg_dump: Error message from server: ERROR:  permission denied for relation sl_node 
  pg_dump: The command was: LOCK TABLE _replication.sl_node IN ACCESS SHARE MODE  
  </code></pre>