Nous utilisons des cookies pour vous garantir la meilleure expérience sur notre site. Si vous continuez à utiliser ce dernier, nous considèrerons que vous acceptez l'utilisation des cookies. J'ai compris ! ou En savoir plus !.
Nom d'utilisateur    Mot de passe              Toujours pas inscrit ?   Mot de passe oublié ?

Annonce

Tous à Arras les 2 et 3 juillet (2019), aux Geodatadays !

#1 Mon 25 March 2019 16:33

tevrard
Membre
Date d'inscription: 23 May 2016
Messages: 214

Restauration de schemas tables et vues manquantes

Bonjour,

Je souhaite déplacer des schémas de ma bdd. J'utilise donc via pgadmin les outils sauvegarder / restaurer (soit pg_dump / pg_restore).

Mais certaines de mes tables et vues ne suivent pas, il semble qu'elles partent en erreur lors de la restauration.

Pour essayer de comprendre les choses j'ai tenté un import sur un seul schéma, qui contient 9 tables et 9 séquences. Si les 9 séquences se retrouvent à l'arrivée, seules 2 tables ne partent pas en erreur.

Ayant du mal à comprendre le pourquoi du comment à partir des logs, je m'en remets à la communauté en espérant que quelqu'un puisse éclairer ma lanterne.

Code:

C:\Program Files (x86)\pgAdmin III\1.22\pg_dump.exe --host 185.65.81.158 --port 5432 --username "dynmappg" --role "dynmappg" --no-password  --format custom --blobs --section pre-data --section data --section post-data --encoding UTF8 --verbose --file "D:\p_online_crci_b_baseco_bourgogne_25032019.backup" --schema "baseco_bourgogne" "P_ONLINE_CRCI_B"
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "baseco_bourgogne.cci_app_mapping"
pg_dump: finding default expressions of table "baseco_bourgogne.cci_app_mapping"
pg_dump: finding check constraints for table "baseco_bourgogne.cci_app_mapping"
pg_dump: finding the columns and types of table "baseco_bourgogne.cci_app_mapping_2018_06"
pg_dump: finding default expressions of table "baseco_bourgogne.cci_app_mapping_2018_06"
pg_dump: finding check constraints for table "baseco_bourgogne.cci_app_mapping_2018_06"
pg_dump: finding the columns and types of table "baseco_bourgogne.communes_bfc"
pg_dump: finding default expressions of table "baseco_bourgogne.communes_bfc"
pg_dump: finding check constraints for table "baseco_bourgogne.communes_bfc"
pg_dump: finding the columns and types of table "baseco_bourgogne.communes_f"
pg_dump: finding default expressions of table "baseco_bourgogne.communes_f"
pg_dump: finding check constraints for table "baseco_bourgogne.communes_f"
pg_dump: finding the columns and types of table "baseco_bourgogne.departement"
pg_dump: finding default expressions of table "baseco_bourgogne.departement"
pg_dump: finding check constraints for table "baseco_bourgogne.departement"
pg_dump: finding the columns and types of table "baseco_bourgogne.departement_bfc"
pg_dump: finding default expressions of table "baseco_bourgogne.departement_bfc"
pg_dump: finding check constraints for table "baseco_bourgogne.departement_bfc"
pg_dump: finding the columns and types of table "baseco_bourgogne.etablissements"
pg_dump: finding default expressions of table "baseco_bourgogne.etablissements"
pg_dump: finding check constraints for table "baseco_bourgogne.etablissements"
pg_dump: finding the columns and types of table "baseco_bourgogne.region"
pg_dump: finding default expressions of table "baseco_bourgogne.region"
pg_dump: finding check constraints for table "baseco_bourgogne.region"
pg_dump: finding the columns and types of table "baseco_bourgogne.za_b"
pg_dump: finding default expressions of table "baseco_bourgogne.za_b"
pg_dump: finding check constraints for table "baseco_bourgogne.za_b"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "baseco_bourgogne.cci_app_mapping"
pg_dump: reading indexes for table "baseco_bourgogne.cci_app_mapping_2018_06"
pg_dump: reading indexes for table "baseco_bourgogne.communes_bfc"
pg_dump: reading indexes for table "baseco_bourgogne.communes_f"
pg_dump: reading indexes for table "baseco_bourgogne.departement"
pg_dump: reading indexes for table "baseco_bourgogne.departement_bfc"
pg_dump: reading indexes for table "baseco_bourgogne.etablissements"
pg_dump: reading indexes for table "baseco_bourgogne.region"
pg_dump: reading indexes for table "baseco_bourgogne.za_b"
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading rewrite rules
pg_dump: reading policies
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: dumping contents of table "baseco_bourgogne.cci_app_mapping"
pg_dump: dumping contents of table "baseco_bourgogne.cci_app_mapping_2018_06"
pg_dump: dumping contents of table "baseco_bourgogne.communes_bfc"
pg_dump: dumping contents of table "baseco_bourgogne.communes_f"
pg_dump: dumping contents of table "baseco_bourgogne.departement"
pg_dump: dumping contents of table "baseco_bourgogne.departement_bfc"
pg_dump: dumping contents of table "baseco_bourgogne.etablissements"
pg_dump: dumping contents of table "baseco_bourgogne.region"
pg_dump: dumping contents of table "baseco_bourgogne.za_b"

Le process a retourné le code de sortie 0.

NB : logs pg_restore en Pièces Jointes (mais impossible de mettre deux fichiers ?)

Hors ligne

 

#2 Mon 25 March 2019 16:38

tevrard
Membre
Date d'inscription: 23 May 2016
Messages: 214

Re: Restauration de schemas tables et vues manquantes

@Modération

désolé pour le doublon de topic, je génère une erreur (index fetch error de mémoire) lorsque je clique sur envoyer.

Les pièces jointes n'ont pas l'air de fonctionner (impossibilté de sélectionner deux fichiers simultanément, et le fichier en PJ n'apparait pas sur le topic)


Voici le log du pg_restore (bien que ce soit pas super lisible comme ça hmm)

Code:

C:\Program Files (x86)\pgAdmin III\1.22\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "base_test" --role "dynmappg" --no-password  --section pre-data --section data --section post-data --clean --schema baseco_bourgogne --verbose "D:\p_online_crci_b_baseco_bourgogne_25032019.backup"
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] Error while INITIALIZING:
pg_restore: [archiver (db)] could not execute query: ERREUR:  paramètre de configuration « lock_timeout » non reconnu
    Command was: SET lock_timeout = 0;

pg_restore: [archiver (db)] could not execute query: ERREUR:  paramètre de configuration « row_security » non reconnu
    Command was: SET row_security = off;

pg_restore: dropping INDEX za_b_geom_idx
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 9129; 1259 420779 INDEX za_b_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « za_b_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.za_b_geom_idx;

pg_restore: dropping INDEX region_geom_idx
pg_restore: [archiver (db)] Error from TOC entry 9126; 1259 420778 INDEX region_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « region_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.region_geom_idx;

pg_restore: dropping INDEX etablissements_geom_idx
pg_restore: [archiver (db)] Error from TOC entry 9123; 1259 420777 INDEX etablissements_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « etablissements_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.etablissements_geom_idx;

pg_restore: dropping INDEX departement_geom_idx
pg_restore: [archiver (db)] Error from TOC entry 9117; 1259 420776 INDEX departement_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « departement_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.departement_geom_idx;

pg_restore: dropping INDEX departement_bfc_geom_idx
pg_restore: [archiver (db)] Error from TOC entry 9120; 1259 420775 INDEX departement_bfc_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « departement_bfc_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.departement_bfc_geom_idx;

pg_restore: dropping INDEX communes_f_geom_idx
pg_restore: [archiver (db)] Error from TOC entry 9114; 1259 420774 INDEX communes_f_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « communes_f_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.communes_f_geom_idx;

pg_restore: dropping INDEX communes_bfc_geom_idx
pg_restore: [archiver (db)] Error from TOC entry 9111; 1259 420773 INDEX communes_bfc_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  l'index « communes_bfc_geom_idx » n'existe pas
    Command was: DROP INDEX baseco_bourgogne.communes_bfc_geom_idx;

pg_restore: dropping CONSTRAINT za_b_pk
pg_restore: [archiver (db)] Error from TOC entry 9131; 2606 418578 CONSTRAINT za_b_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.za_b » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.za_b DROP CONSTRAINT za_b_pk;

pg_restore: dropping CONSTRAINT region_pk
pg_restore: [archiver (db)] Error from TOC entry 9128; 2606 418576 CONSTRAINT region_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.region » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.region DROP CONSTRAINT region_pk;

pg_restore: dropping CONSTRAINT etablissements_pk
pg_restore: [archiver (db)] Error from TOC entry 9125; 2606 418574 CONSTRAINT etablissements_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.etablissements » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.etablissements DROP CONSTRAINT etablissements_pk;

pg_restore: dropping CONSTRAINT departement_pk
pg_restore: [archiver (db)] Error from TOC entry 9119; 2606 418572 CONSTRAINT departement_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.departement » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.departement DROP CONSTRAINT departement_pk;

pg_restore: dropping CONSTRAINT departement_bfc_pk
pg_restore: [archiver (db)] Error from TOC entry 9122; 2606 418570 CONSTRAINT departement_bfc_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.departement_bfc » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.departement_bfc DROP CONSTRAINT departement_bfc_pk;

pg_restore: dropping CONSTRAINT communes_f_pk
pg_restore: [archiver (db)] Error from TOC entry 9116; 2606 418568 CONSTRAINT communes_f_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.communes_f » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.communes_f DROP CONSTRAINT communes_f_pk;

pg_restore: dropping CONSTRAINT communes_bfc_pk
pg_restore: [archiver (db)] Error from TOC entry 9113; 2606 418566 CONSTRAINT communes_bfc_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.communes_bfc » n'existe pas
    Command was: ALTER TABLE ONLY baseco_bourgogne.communes_bfc DROP CONSTRAINT communes_bfc_pk;

pg_restore: dropping CONSTRAINT baseco_bourgogne.cci_app_mapping_save_pk
pg_restore: dropping CONSTRAINT baseco_bourgogne.cci_app_mapping_pk
pg_restore: dropping SEQUENCE SET za_b_db_fid_seq
pg_restore: dropping TABLE DATA za_b
pg_restore: dropping SEQUENCE SET region_db_fid_seq
pg_restore: dropping TABLE DATA region
pg_restore: dropping SEQUENCE SET etablissements_db_fid_seq
pg_restore: dropping TABLE DATA etablissements
pg_restore: dropping SEQUENCE SET departement_db_fid_seq
pg_restore: dropping SEQUENCE SET departement_bfc_db_fid_seq
pg_restore: dropping TABLE DATA departement_bfc
pg_restore: dropping TABLE DATA departement
pg_restore: dropping SEQUENCE SET communes_f_db_fid_seq
pg_restore: dropping TABLE DATA communes_f
pg_restore: dropping SEQUENCE SET communes_bfc_db_fid_seq
pg_restore: dropping TABLE DATA communes_bfc
pg_restore: dropping SEQUENCE SET cci_app_mapping_save_map_id_seq
pg_restore: dropping SEQUENCE SET cci_app_mapping_map_id_seq
pg_restore: dropping TABLE DATA cci_app_mapping_2018_06
pg_restore: dropping TABLE DATA cci_app_mapping
pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9104; 2604 382080 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.za_b » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.za_b ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9101; 2604 382079 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.region » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.region ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9098; 2604 382078 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.etablissements » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.etablissements ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9095; 2604 382077 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.departement_bfc » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.departement_bfc ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9092; 2604 382076 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.departement » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.departement ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9089; 2604 382075 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.communes_f » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.communes_f ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT db_fid
pg_restore: [archiver (db)] Error from TOC entry 9086; 2604 382074 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « baseco_bourgogne.communes_bfc » n'existe pas
    Command was: ALTER TABLE baseco_bourgogne.communes_bfc ALTER COLUMN db_fid DROP DEFAULT;

pg_restore: dropping DEFAULT map_id
pg_restore: dropping DEFAULT map_id
pg_restore: dropping SEQUENCE OWNED BY za_b_db_fid_seq
pg_restore: dropping SEQUENCE za_b_db_fid_seq
pg_restore: dropping TABLE za_b
pg_restore: [archiver (db)] Error from TOC entry 214; 1259 373616 TABLE za_b dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « za_b » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.za_b;

pg_restore: dropping SEQUENCE OWNED BY region_db_fid_seq
pg_restore: dropping SEQUENCE region_db_fid_seq
pg_restore: dropping TABLE region
pg_restore: [archiver (db)] Error from TOC entry 212; 1259 373606 TABLE region dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « region » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.region;

pg_restore: dropping SEQUENCE OWNED BY etablissements_db_fid_seq
pg_restore: dropping SEQUENCE etablissements_db_fid_seq
pg_restore: dropping TABLE etablissements
pg_restore: [archiver (db)] Error from TOC entry 210; 1259 373596 TABLE etablissements dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « etablissements » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.etablissements;

pg_restore: dropping SEQUENCE OWNED BY departement_db_fid_seq
pg_restore: dropping SEQUENCE departement_db_fid_seq
pg_restore: dropping SEQUENCE OWNED BY departement_bfc_db_fid_seq
pg_restore: dropping SEQUENCE departement_bfc_db_fid_seq
pg_restore: dropping TABLE departement_bfc
pg_restore: [archiver (db)] Error from TOC entry 207; 1259 373584 TABLE departement_bfc dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « departement_bfc » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.departement_bfc;

pg_restore: dropping TABLE departement
pg_restore: [archiver (db)] Error from TOC entry 206; 1259 373576 TABLE departement dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « departement » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.departement;

pg_restore: dropping SEQUENCE OWNED BY communes_f_db_fid_seq
pg_restore: dropping SEQUENCE communes_f_db_fid_seq
pg_restore: dropping TABLE communes_f
pg_restore: [archiver (db)] Error from TOC entry 204; 1259 373566 TABLE communes_f dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « communes_f » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.communes_f;

pg_restore: dropping SEQUENCE OWNED BY communes_bfc_db_fid_seq
pg_restore: dropping SEQUENCE communes_bfc_db_fid_seq
pg_restore: dropping TABLE communes_bfc
pg_restore: [archiver (db)] Error from TOC entry 202; 1259 373556 TABLE communes_bfc dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la table « communes_bfc » n'existe pas
    Command was: DROP TABLE baseco_bourgogne.communes_bfc;

pg_restore: dropping SEQUENCE OWNED BY cci_app_mapping_save_map_id_seq
pg_restore: dropping SEQUENCE cci_app_mapping_save_map_id_seq
pg_restore: dropping SEQUENCE OWNED BY cci_app_mapping_map_id_seq
pg_restore: dropping SEQUENCE cci_app_mapping_map_id_seq
pg_restore: dropping TABLE cci_app_mapping_2018_06
pg_restore: dropping TABLE cci_app_mapping
pg_restore: creating TABLE "baseco_bourgogne.cci_app_mapping"
pg_restore: creating TABLE "baseco_bourgogne.cci_app_mapping_2018_06"
pg_restore: creating SEQUENCE "baseco_bourgogne.cci_app_mapping_map_id_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.cci_app_mapping_map_id_seq"
pg_restore: creating SEQUENCE "baseco_bourgogne.cci_app_mapping_save_map_id_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.cci_app_mapping_save_map_id_seq"
pg_restore: creating TABLE "baseco_bourgogne.communes_bfc"
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE communes_bfc (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_insee character varying(5),
...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_bfc » n'existe pas
    Command was: ALTER TABLE communes_bfc OWNER TO dynmappg;


pg_restore: creating SEQUENCE "baseco_bourgogne.communes_bfc_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.communes_bfc_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9770; 0 0 SEQUENCE OWNED BY communes_bfc_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_bfc » n'existe pas
    Command was: ALTER SEQUENCE communes_bfc_db_fid_seq OWNED BY communes_bfc.db_fid;



pg_restore: creating TABLE "baseco_bourgogne.communes_f"
pg_restore: [archiver (db)] Error from TOC entry 204; 1259 373566 TABLE communes_f dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE communes_f (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_insee character varying(5),
  ...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_f » n'existe pas
    Command was: ALTER TABLE communes_f OWNER TO dynmappg;


pg_restore: creating SEQUENCE "baseco_bourgogne.communes_f_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.communes_f_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9771; 0 0 SEQUENCE OWNED BY communes_f_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_f » n'existe pas
    Command was: ALTER SEQUENCE communes_f_db_fid_seq OWNED BY communes_f.db_fid;



pg_restore: creating TABLE "baseco_bourgogne.departement"
pg_restore: [archiver (db)] Error from TOC entry 206; 1259 373576 TABLE departement dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE departement (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_dep character varying(2),
   ...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement » n'existe pas
    Command was: ALTER TABLE departement OWNER TO dynmappg;


pg_restore: creating TABLE "baseco_bourgogne.departement_bfc"
pg_restore: [archiver (db)] Error from TOC entry 207; 1259 373584 TABLE departement_bfc dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE departement_bfc (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_dep character varying(2),...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement_bfc » n'existe pas
    Command was: ALTER TABLE departement_bfc OWNER TO dynmappg;


pg_restore: creating SEQUENCE "baseco_bourgogne.departement_bfc_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.departement_bfc_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9772; 0 0 SEQUENCE OWNED BY departement_bfc_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement_bfc » n'existe pas
    Command was: ALTER SEQUENCE departement_bfc_db_fid_seq OWNED BY departement_bfc.db_fid;



pg_restore: creating SEQUENCE "baseco_bourgogne.departement_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.departement_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9773; 0 0 SEQUENCE OWNED BY departement_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement » n'existe pas
    Command was: ALTER SEQUENCE departement_db_fid_seq OWNED BY departement.db_fid;



pg_restore: creating TABLE "baseco_bourgogne.etablissements"
pg_restore: [archiver (db)] Error from TOC entry 210; 1259 373596 TABLE etablissements dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE etablissements (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    siret character varying,
    lo...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « etablissements » n'existe pas
    Command was: ALTER TABLE etablissements OWNER TO dynmappg;


pg_restore: creating SEQUENCE "baseco_bourgogne.etablissements_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.etablissements_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9774; 0 0 SEQUENCE OWNED BY etablissements_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « etablissements » n'existe pas
    Command was: ALTER SEQUENCE etablissements_db_fid_seq OWNED BY etablissements.db_fid;



pg_restore: creating TABLE "baseco_bourgogne.region"
pg_restore: [archiver (db)] Error from TOC entry 212; 1259 373606 TABLE region dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE region (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_reg character varying(2),
    nom_...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « region » n'existe pas
    Command was: ALTER TABLE region OWNER TO dynmappg;


pg_restore: creating SEQUENCE "baseco_bourgogne.region_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.region_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9775; 0 0 SEQUENCE OWNED BY region_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « region » n'existe pas
    Command was: ALTER SEQUENCE region_db_fid_seq OWNED BY region.db_fid;



pg_restore: creating TABLE "baseco_bourgogne.za_b"
pg_restore: [archiver (db)] Error from TOC entry 214; 1259 373616 TABLE za_b dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE za_b (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_za character varying(4),
    nom_za ...
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « za_b » n'existe pas
    Command was: ALTER TABLE za_b OWNER TO dynmappg;


pg_restore: creating SEQUENCE "baseco_bourgogne.za_b_db_fid_seq"
pg_restore: creating SEQUENCE OWNED BY "baseco_bourgogne.za_b_db_fid_seq"
pg_restore: [archiver (db)] Error from TOC entry 9776; 0 0 SEQUENCE OWNED BY za_b_db_fid_seq dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « za_b » n'existe pas
    Command was: ALTER SEQUENCE za_b_db_fid_seq OWNED BY za_b.db_fid;



pg_restore: creating DEFAULT "baseco_bourgogne.map_id"
pg_restore: creating DEFAULT "baseco_bourgogne.map_id"
pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9086; 2604 382074 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_bfc » n'existe pas
    Command was: ALTER TABLE ONLY communes_bfc ALTER COLUMN db_fid SET DEFAULT nextval('communes_bfc_db_fid_seq'::regclass);



pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9089; 2604 382075 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_f » n'existe pas
    Command was: ALTER TABLE ONLY communes_f ALTER COLUMN db_fid SET DEFAULT nextval('communes_f_db_fid_seq'::regclass);



pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9092; 2604 382076 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement » n'existe pas
    Command was: ALTER TABLE ONLY departement ALTER COLUMN db_fid SET DEFAULT nextval('departement_db_fid_seq'::regclass);



pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9095; 2604 382077 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement_bfc » n'existe pas
    Command was: ALTER TABLE ONLY departement_bfc ALTER COLUMN db_fid SET DEFAULT nextval('departement_bfc_db_fid_seq'::regclass);



pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9098; 2604 382078 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « etablissements » n'existe pas
    Command was: ALTER TABLE ONLY etablissements ALTER COLUMN db_fid SET DEFAULT nextval('etablissements_db_fid_seq'::regclass);



pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9101; 2604 382079 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « region » n'existe pas
    Command was: ALTER TABLE ONLY region ALTER COLUMN db_fid SET DEFAULT nextval('region_db_fid_seq'::regclass);



pg_restore: creating DEFAULT "baseco_bourgogne.db_fid"
pg_restore: [archiver (db)] Error from TOC entry 9104; 2604 382080 DEFAULT db_fid dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « za_b » n'existe pas
    Command was: ALTER TABLE ONLY za_b ALTER COLUMN db_fid SET DEFAULT nextval('za_b_db_fid_seq'::regclass);



pg_restore: processing data for table "baseco_bourgogne.cci_app_mapping"
pg_restore: processing data for table "baseco_bourgogne.cci_app_mapping_2018_06"
pg_restore: executing SEQUENCE SET cci_app_mapping_map_id_seq
pg_restore: executing SEQUENCE SET cci_app_mapping_save_map_id_seq
pg_restore: processing data for table "baseco_bourgogne.communes_bfc"
pg_restore: [archiver (db)] Error from TOC entry 9750; 0 373556 TABLE DATA communes_bfc dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_bfc » n'existe pas
    Command was: COPY communes_bfc (db_fid, the_geom, code_insee, nom_comune, bta_cob) FROM stdin;

pg_restore: executing SEQUENCE SET communes_bfc_db_fid_seq
pg_restore: processing data for table "baseco_bourgogne.communes_f"
pg_restore: [archiver (db)] Error from TOC entry 9752; 0 373566 TABLE DATA communes_f dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_f » n'existe pas
    Command was: COPY communes_f (db_fid, the_geom, code_insee, nom_com, code_cant, code_arr, code_dept, code_reg) FROM stdin;

pg_restore: executing SEQUENCE SET communes_f_db_fid_seq
pg_restore: processing data for table "baseco_bourgogne.departement"
pg_restore: [archiver (db)] Error from TOC entry 9754; 0 373576 TABLE DATA departement dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement » n'existe pas
    Command was: COPY departement (db_fid, the_geom, code_dep, nom_dep, code_reg, nom_reg) FROM stdin;

pg_restore: processing data for table "baseco_bourgogne.departement_bfc"
pg_restore: [archiver (db)] Error from TOC entry 9755; 0 373584 TABLE DATA departement_bfc dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement_bfc » n'existe pas
    Command was: COPY departement_bfc (db_fid, the_geom, code_dep, nom_dep, code_reg, nom_reg) FROM stdin;

pg_restore: executing SEQUENCE SET departement_bfc_db_fid_seq
pg_restore: executing SEQUENCE SET departement_db_fid_seq
pg_restore: processing data for table "baseco_bourgogne.etablissements"
pg_restore: [archiver (db)] Error from TOC entry 9758; 0 373596 TABLE DATA etablissements dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « etablissements » n'existe pas
    Command was: COPY etablissements (db_fid, the_geom, siret, longitude, latitude) FROM stdin;

pg_restore: executing SEQUENCE SET etablissements_db_fid_seq
pg_restore: processing data for table "baseco_bourgogne.region"
pg_restore: [archiver (db)] Error from TOC entry 9760; 0 373606 TABLE DATA region dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « region » n'existe pas
    Command was: COPY region (db_fid, the_geom, code_reg, nom_reg, nom_reg_min) FROM stdin;

pg_restore: executing SEQUENCE SET region_db_fid_seq
pg_restore: processing data for table "baseco_bourgogne.za_b"
pg_restore: [archiver (db)] Error from TOC entry 9762; 0 373616 TABLE DATA za_b dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « za_b » n'existe pas
    Command was: COPY za_b (db_fid, the_geom, code_za, nom_za) FROM stdin;

pg_restore: executing SEQUENCE SET za_b_db_fid_seq
pg_restore: creating CONSTRAINT "baseco_bourgogne.baseco_bourgogne.cci_app_mapping_pk"
pg_restore: creating CONSTRAINT "baseco_bourgogne.baseco_bourgogne.cci_app_mapping_save_pk"
pg_restore: creating CONSTRAINT "baseco_bourgogne.communes_bfc_pk"
pg_restore: [archiver (db)] Error from TOC entry 9113; 2606 418566 CONSTRAINT communes_bfc_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_bfc » n'existe pas
    Command was: ALTER TABLE ONLY communes_bfc
    ADD CONSTRAINT communes_bfc_pk PRIMARY KEY (db_fid);



pg_restore: creating CONSTRAINT "baseco_bourgogne.communes_f_pk"
pg_restore: [archiver (db)] Error from TOC entry 9116; 2606 418568 CONSTRAINT communes_f_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_f » n'existe pas
    Command was: ALTER TABLE ONLY communes_f
    ADD CONSTRAINT communes_f_pk PRIMARY KEY (db_fid);



pg_restore: creating CONSTRAINT "baseco_bourgogne.departement_bfc_pk"
pg_restore: [archiver (db)] Error from TOC entry 9122; 2606 418570 CONSTRAINT departement_bfc_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement_bfc » n'existe pas
    Command was: ALTER TABLE ONLY departement_bfc
    ADD CONSTRAINT departement_bfc_pk PRIMARY KEY (db_fid);



pg_restore: creating CONSTRAINT "baseco_bourgogne.departement_pk"
pg_restore: [archiver (db)] Error from TOC entry 9119; 2606 418572 CONSTRAINT departement_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement » n'existe pas
    Command was: ALTER TABLE ONLY departement
    ADD CONSTRAINT departement_pk PRIMARY KEY (db_fid);



pg_restore: creating CONSTRAINT "baseco_bourgogne.etablissements_pk"
pg_restore: [archiver (db)] Error from TOC entry 9125; 2606 418574 CONSTRAINT etablissements_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « etablissements » n'existe pas
    Command was: ALTER TABLE ONLY etablissements
    ADD CONSTRAINT etablissements_pk PRIMARY KEY (db_fid);



pg_restore: creating CONSTRAINT "baseco_bourgogne.region_pk"
pg_restore: [archiver (db)] Error from TOC entry 9128; 2606 418576 CONSTRAINT region_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « region » n'existe pas
    Command was: ALTER TABLE ONLY region
    ADD CONSTRAINT region_pk PRIMARY KEY (db_fid);



pg_restore: creating CONSTRAINT "baseco_bourgogne.za_b_pk"
pg_restore: [archiver (db)] Error from TOC entry 9131; 2606 418578 CONSTRAINT za_b_pk dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « za_b » n'existe pas
    Command was: ALTER TABLE ONLY za_b
    ADD CONSTRAINT za_b_pk PRIMARY KEY (db_fid);



pg_restore: creating INDEX "baseco_bourgogne.communes_bfc_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9111; 1259 420773 INDEX communes_bfc_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_bfc » n'existe pas
    Command was: CREATE INDEX communes_bfc_geom_idx ON communes_bfc USING gist (the_geom);



pg_restore: creating INDEX "baseco_bourgogne.communes_f_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9114; 1259 420774 INDEX communes_f_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « communes_f » n'existe pas
    Command was: CREATE INDEX communes_f_geom_idx ON communes_f USING gist (the_geom);



pg_restore: creating INDEX "baseco_bourgogne.departement_bfc_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9120; 1259 420775 INDEX departement_bfc_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement_bfc » n'existe pas
    Command was: CREATE INDEX departement_bfc_geom_idx ON departement_bfc USING gist (the_geom);



pg_restore: creating INDEX "baseco_bourgogne.departement_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9117; 1259 420776 INDEX departement_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « departement » n'existe pas
    Command was: CREATE INDEX departement_geom_idx ON departement USING gist (the_geom);



pg_restore: creating INDEX "baseco_bourgogne.etablissements_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9123; 1259 420777 INDEX etablissements_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « etablissements » n'existe pas
    Command was: CREATE INDEX etablissements_geom_idx ON etablissements USING gist (the_geom);



pg_restore: creating INDEX "baseco_bourgogne.region_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9126; 1259 420778 INDEX region_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « region » n'existe pas
    Command was: CREATE INDEX region_geom_idx ON region USING gist (the_geom);



pg_restore: creating INDEX "baseco_bourgogne.za_b_geom_idx"
pg_restore: [archiver (db)] Error from TOC entry 9129; 1259 420779 INDEX za_b_geom_idx dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  la relation « za_b » n'existe pas
    Command was: CREATE INDEX za_b_geom_idx ON za_b USING gist (the_geom);



pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.cci_app_mapping"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.cci_app_mapping_2018_06"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.cci_app_mapping_map_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.cci_app_mapping_map_id_seq"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.cci_app_mapping_save_map_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.cci_app_mapping_save_map_id_seq"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.communes_bfc"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.communes_bfc_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.communes_bfc_db_fid_seq"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.communes_f"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.communes_f_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.communes_f_db_fid_seq"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.departement"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.departement_bfc"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.departement_bfc_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.departement_bfc_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.departement_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.departement_db_fid_seq"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.etablissements"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.etablissements_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.etablissements_db_fid_seq"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.region"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.region_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.region_db_fid_seq"
pg_restore: setting owner and privileges for TABLE "baseco_bourgogne.za_b"
pg_restore: setting owner and privileges for SEQUENCE "baseco_bourgogne.za_b_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "baseco_bourgogne.za_b_db_fid_seq"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.map_id"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.map_id"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for DEFAULT "baseco_bourgogne.db_fid"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.cci_app_mapping"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.cci_app_mapping_2018_06"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.cci_app_mapping_map_id_seq"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.cci_app_mapping_save_map_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.communes_bfc"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.communes_bfc_db_fid_seq"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.communes_f"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.communes_f_db_fid_seq"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.departement"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.departement_bfc"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.departement_bfc_db_fid_seq"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.departement_db_fid_seq"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.etablissements"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.etablissements_db_fid_seq"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.region"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.region_db_fid_seq"
pg_restore: setting owner and privileges for TABLE DATA "baseco_bourgogne.za_b"
pg_restore: setting owner and privileges for SEQUENCE SET "baseco_bourgogne.za_b_db_fid_seq"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.baseco_bourgogne.cci_app_mapping_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.baseco_bourgogne.cci_app_mapping_save_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.communes_bfc_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.communes_f_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.departement_bfc_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.departement_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.etablissements_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.region_pk"
pg_restore: setting owner and privileges for CONSTRAINT "baseco_bourgogne.za_b_pk"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.communes_bfc_geom_idx"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.communes_f_geom_idx"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.departement_bfc_geom_idx"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.departement_geom_idx"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.etablissements_geom_idx"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.region_geom_idx"
pg_restore: setting owner and privileges for INDEX "baseco_bourgogne.za_b_geom_idx"
WARNING: errors ignored on restore: 79

Le process a retourné le code de sortie 1.

Hors ligne

 

#3 Wed 27 March 2019 12:00

tumasgiu
Membre
Lieu: Ajaccio
Date d'inscription: 5 Jul 2010
Messages: 852

Re: Restauration de schemas tables et vues manquantes

Salut,

Il ne semble pas que vous ayez installé postgis dans votre base cible.

Hors ligne

 

#4 Wed 27 March 2019 13:52

tevrard
Membre
Date d'inscription: 23 May 2016
Messages: 214

Re: Restauration de schemas tables et vues manquantes

Je n'ai pas de postgis, sur aucune des deux bases.
Les géométries sont utilisées par dynmap in fine.

Hors ligne

 

#5 Wed 27 March 2019 13:56

tumasgiu
Membre
Lieu: Ajaccio
Date d'inscription: 5 Jul 2010
Messages: 852

Re: Restauration de schemas tables et vues manquantes

Le dump contient pourtant bien des définitions de colonnes géo,
cf. votre log d'erreur de restore :

Code:

pg_restore: creating TABLE "baseco_bourgogne.za_b"
pg_restore: [archiver (db)] Error from TOC entry 214; 1259 373616 TABLE za_b dynmappg
pg_restore: [archiver (db)] could not execute query: ERREUR:  le type « public.geometry » n'existe pas
LINE 3:     the_geom public.geometry,
                     ^
    Command was: CREATE TABLE za_b (
    db_fid integer NOT NULL,
    the_geom public.geometry,
    code_za character varying(4),
    nom_za ...

Hors ligne

 

Pied de page des forums

Powered by FluxBB

Partagez  |