Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pg_dump -Fc -xO -f o7db.dump o7db
- $ pg_dump --version
- pg_dump (PostgreSQL) 9.3.5
- $ pg_restore --version
- pg_restore (PostgreSQL) 9.3.5
- pg_restore -d o7db -xO -j3 o7db.dump
- pg_restore: [archiver (db)] Error from TOC entry 6784; 2606 1182924 FK CONSTRAINT account_account_currency_id_fkey manu
- 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"
- DETAIL: Key (currency_id)=(1) is not present in table "res_currency".
- Command was: ALTER TABLE ONLY account_account
- ADD CONSTRAINT account_account_currency_id_fkey FOREIGN KEY (currency_id) REFERENCES re..
- pg_restore: [archiver (db)] Error from TOC entry 8561; 0 1161831 TABLE DATA account_move_line manu
- pg_restore: [archiver (db)] COPY failed for table "account_move_line": ERROR: value too long for type character varying(64)
- CONTEXT: COPY account_move_line, line 172, column name: "<MASKED DATA HERE....>"
- pg_restore -d o7db_restore -xO -j3 o7db.dump
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement