Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2014
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. pg_dump -Fc -xO -f o7db.dump o7db
  2.  
  3. $ pg_dump --version
  4. pg_dump (PostgreSQL) 9.3.5
  5.  
  6. $ pg_restore --version
  7. pg_restore (PostgreSQL) 9.3.5
  8.  
  9. pg_restore -d o7db -xO -j3 o7db.dump
  10.  
  11. pg_restore: [archiver (db)] Error from TOC entry 6784; 2606 1182924 FK CONSTRAINT account_account_currency_id_fkey manu
  12. pg_restore: [archiver (db)] could not execute query: ERROR: insert or update on table "account_account" violates foreign key constraint "account_account_currency_id_fkey"
  13. DETAIL: Key (currency_id)=(1) is not present in table "res_currency".
  14. Command was: ALTER TABLE ONLY account_account
  15. ADD CONSTRAINT account_account_currency_id_fkey FOREIGN KEY (currency_id) REFERENCES re..
  16.  
  17. pg_restore: [archiver (db)] Error from TOC entry 8561; 0 1161831 TABLE DATA account_move_line manu
  18. pg_restore: [archiver (db)] COPY failed for table "account_move_line": ERROR: value too long for type character varying(64)
  19. CONTEXT: COPY account_move_line, line 172, column name: "<MASKED DATA HERE....>"
  20.  
  21. pg_restore -d o7db_restore -xO -j3 o7db.dump
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement