title: Error: Command was: SELECT pg_catalog.setval
body: <p>I'm unable to restore my backup DB on heroku DB but I don't have any issue if I restore on my local env and I get no errors.</p>
  
  <p>When I try to restore on heroku connect database I get this following error:</p>
  
  <blockquote>
    <p>C:\Program Files\PostgreSQL\9.4\bin\pg_restore.exe --host
    XXXXXX.compute-1.amazonaws.com --port 5432 --username
    "XXXXokwpyzewicl" --dbname "d9uto7paqXXX" --no-password  --verbose</p>
    
    <p>"C:\Users\XXXX\Desktop\loans.backup" </p>
    
    <p>pg_restore: connecting to
    database for restore pg_restore: implied data-only restore </p>
    
    <p>pg_restore: processing data for table "application_denial_reason_types"</p>
    
    <p>pg_restore: [archiver (db)] Error while PROCESSING TOC: </p>
    
    <p>pg_restore: [archiver (db)] Error from TOC entry 5202; 0 16622 TABLE DATA application_denial_reason_types postgres </p>
    
    <p>pg_restore: [archiver (db)] could not execute query: ERROR:  relation "application_denial_reason_types" does not exist 
    Command was: COPY application_denial_reason_types (denial_reason_type_id, denial_reason_type_name, description, active, created_by, creat... pg_restore: executing SEQUENCE SET application_denial_reason_types_denial_reason_type_id_seq </p>
    
    <p>pg_restore: [archiver (db)] Error from TOC entry 5672; 0 0 SEQUENCE SET
    application_denial_reason_types_denial_reason_type_id_seq postgres</p>
    
    <p>pg_restore: [archiver (db)] could not execute query: ERROR:  relation
    "application_denial_reason_types_denial_reason_type_id_seq" does not
    exist LINE 1: SELECT pg_catalog.setval('application_denial_reason_types_de...
                                     ^
        Command was: SELECT pg_catalog.setval('application_denial_reason_types_denial_reason_type_id_seq',
    1, false);</p>
  </blockquote>
  
  <p>How do I fix this error? </p>