Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1eiLwB-0005Uk-DA
	for pgsql-admin@arkaria.postgresql.org; Sun, 04 Feb 2018 15:10:35 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1eiLwA-00020v-Gy
	for pgsql-admin@arkaria.postgresql.org; Sun, 04 Feb 2018 15:10:34 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <robert@redcor.ch>)
	id 1eiLwA-00020f-3v
	for pgsql-admin@lists.postgresql.org; Sun, 04 Feb 2018 15:10:34 +0000
Received: from susanne.redcor.ch ([178.63.103.72])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <robert@redcor.ch>)
	id 1eiLw6-0001N5-UF
	for pgsql-admin@postgresql.org; Sun, 04 Feb 2018 15:10:32 +0000
Received: from [192.168.0.100] (84-72-41-168.dclient.hispeed.ch
 [84.72.41.168])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(No client certificate requested)
	(Authenticated sender: robert@redcor.ch)
	by susanne.redcor.ch (Postfix) with ESMTPSA id 92C64A01D5
	for <pgsql-admin@postgresql.org>; Sun,  4 Feb 2018 16:10:27 +0100 (CET)
To: pgsql-admin@postgresql.org
From: robert <robert@redcor.ch>
Subject: pg_restore has problems with restoring sequences.
Message-ID: <129cd073-60bf-96db-e129-24bd9a37319e@redcor.ch>
Date: Sun, 4 Feb 2018 16:10:27 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-GB
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

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