#1 Mon 25 March 2019 16:33
- tevrard
- Participant assidu
- Date d'inscription: 23 May 2016
- Messages: 320
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
- Participant assidu
- Date d'inscription: 23 May 2016
- Messages: 320
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 )
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: 1143
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
- Participant assidu
- Date d'inscription: 23 May 2016
- Messages: 320
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: 1143
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