From: robert <robert@redcor.ch>
To: pgsql-admin@postgresql.org
Subject: pg_restore has problems with restoring sequences.
Date: Sun, 4 Feb 2018 16:10:27 +0100
Message-ID: <129cd073-60bf-96db-e129-24bd9a37319e@redcor.ch> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robert@redcor.ch
Subject: Re: pg_restore has problems with restoring sequences.
In-Reply-To: <129cd073-60bf-96db-e129-24bd9a37319e@redcor.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox