pg_restore has problems with restoring sequences.
От | robert |
---|---|
Тема | pg_restore has problems with restoring sequences. |
Дата | |
Msg-id | 129cd073-60bf-96db-e129-24bd9a37319e@redcor.ch обсуждение исходный текст |
Ответы |
Re: pg_restore has problems with restoring sequences.
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: