Hi there,
I want to restore data from a box running V10 in a docker to my local box.
I use
pg_dump -h localhost -U USER -Fc DATABASE > dumpfile
then I restore it with:
dropdb DATABASE
pg_restore -O -U user -d DATABASE dumpfile
doing this then I get these warnings, and many (not all) sequences are not created.
pg_restore: [archiver (db)] Error from TOC entry 15277; 0 0 SEQUENCE SET
selected_event_zone_id_seq odoo
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"selected_event_zone_id_seq" does not exist
LINE 1: SELECT pg_catalog.setval('selected_event_zone_id_seq', 6, tr...
^
Command was: SELECT pg_catalog.setval('selected_event_zone_id_seq', 6, true);
WARNING: errors ignored on restore: 20
how can I fix this.
This procedure never was problematic using postgresql 9.X
thanks
robert