Postgres DB .backup files cause syntax issues
Closed this issue · 3 comments
jsachs commented
Running psql indaba < indaba3012.backup
results in the following:
RROR: syntax error at or near "PGDMP"
LINE 1: PGDMP
REVOKE ALL ON SCHEMA public FROM postgres;
^
GRANT
GRANT
ERROR: syntax error at or near ""
LINE 1: 'New',
^
ERROR: syntax error at or near ""
LINE 1: 'New',
^
ERROR: syntax error at or near ""
LINE 1: 'New',
^
ERROR: syntax error at or near ""
LINE 1: 'New',
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: LANGUAGE plpgsql
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: "matrixId" integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: START WITH 240
^
ERROR: syntax error at or near ""
LINE 1: id integer DEFAULT nextval('country_id_seq'::regclass)...
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer DEFAULT nextval('role_id_seq'::regclass) NO...
^
ERROR: syntax error at or near ""
LINE 1: "roleID" bigint NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: id integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: "userID" integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: "essenceId" integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: id integer DEFAULT nextval('"UnitOfAnalysis_id_seq"'::...
^
ERROR: syntax error at or near ""
LINE 1: START WITH 9
^
ERROR: syntax error at or near ""
LINE 1: id smallint DEFAULT nextval('"UnitOfAnalysisClassType_...
^
ERROR: syntax error at or near ""
LINE 1: id smallint NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 9
^
ERROR: syntax error at or near ""
LINE 1: START WITH 9
^
ERROR: syntax error at or near ""
LINE 1: id smallint DEFAULT nextval('"UnitOfAnalysisType_id_se...
^
ERROR: syntax error at or near ""
LINE 1: "userID" bigint NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: "roleID" integer NOT NULL,
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: START WITH 1
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "AccessMatr...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "AccessPermissions_accessMatrixId_roleI...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "AccessPermissoins_pkey" PRIMARY KEY (i...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Countries_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "EntityRoles_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Entity_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "EssenceRoles_essenceId_entityId_userId...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Essences_fileName_key" UNIQUE ("fileNa...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Essences_tableName_key" UNIQUE ("table...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "JSON_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Languages_code_key" UNIQUE (code);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Languages_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Organizations_adminUserId_key" UNIQUE ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Organizations_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Product_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Projects_codeName_key" UNIQUE ("codeNa...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Projects_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Rights_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "SurveyAnswers_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "SurveyAnswers_surveyId_userId_key" UNI...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Translations_pkey" PRIMARY KEY ("essen...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisClassType_pkey" PRIMARY ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisTag_pkey" PRIMARY KEY (i...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisType_pkey" PRIMARY KEY (...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysis_pkey" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Users_email_key" UNIQUE (email);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT id PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "roleRight_pkey" PRIMARY KEY ("roleID",...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "userID" PRIMARY KEY (id);
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "userRights_pkey" PRIMARY KEY ("userID"...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Organizations_adminUserId_...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Products_originalLangId_fkey" FOREIGN ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Projects_accessMatrixId_fkey" FOREIGN ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Projects_adminUserId_fkey" FOREIGN KEY...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Projects_organizationId_fkey" FOREIGN ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Rights_essence_id_fkey" FOREIGN KEY ("...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "RolesRights_roleID_fkey" FOREIGN KEY (...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "SurveyAnswers_surveyId_fkey" FOREIGN K...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "SurveyAnswers_userId_fkey" FOREIGN KEY...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Translations_essence_id_fkey" FOREIGN ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Translations_lang_id_fkey" FOREIGN KEY...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisClassType_langId_fkey" F...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisTag_classTypeId_fkey" FO...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisTag_langId_fkey" FOREIGN...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysisType_langId_fkey" FOREIG...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysis_creatorId_fkey" FOREIGN...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysis_langId_fkey" FOREIGN KE...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysis_ownerId_fkey" FOREIGN K...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "UnitOfAnalysis_unitOfAnalysisType_fkey...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Users_organizationId_fkey" FOREIGN KEY...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "Users_roleID_fkey" FOREIGN KEY ("roleI...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT essence_fkey FOREIGN KEY ("essenceId") ...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT role_fkey FOREIGN KEY ("roleId") REFERE...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT "rolesrights_rightID" FOREIGN KEY ("rig...
^
ERROR: syntax error at or near ""
LINE 1: ADD CONSTRAINT user_fkey FOREIGN KEY ("userId") REFERE...
^
invalid command \F���
invalid command \�
invalid command \��,�{l$`��VjG''M�33,ۼ$���v�
invalid command \�
oL�g��#e��"�%�p��l�l�"?
invalid command \�FO�Xx&�ej�J�/VYH��
ERROR: invalid byte sequence for encoding "UTF8": 0xb9
sbabushkin commented
This backup work great with pgadmin restore option. Please use it
четверг, 31 декабря 2015 г. пользователь Dmitry Kachaev написал:
@jsachs https://github.com/jsachs try _2330 dump it just worked for me
—
Reply to this email directly or view it on GitHub
#2 (comment).
jsachs commented
pgAdmin worked. I think this should be included in the README instructions, as all steps should be reproducible.