Can't restore psql from mysql DB
Created by: pablokbs
Hello
I've followed the guide (http://bit.ly/1tLjaFK) to migrate from mysql to postgress (I'm migrating to omnibus-gitlab) and I can't restore the DB
START TRANSACTION
SET
SET
SET CONSTRAINTS
psql:gitlab.psql:18: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "broadcast_messages_pkey" for table "broadcast_messages"
CREATE TABLE
INSERT 0 4
psql:gitlab.psql:28: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "deploy_keys_projects_pkey" for table "deploy_keys_projects"
CREATE TABLE
psql:gitlab.psql:38: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "emails_pkey" for table "emails"
psql:gitlab.psql:38: NOTICE: CREATE TABLE / UNIQUE will create implicit index "emails_email_key" for table "emails"
CREATE TABLE
psql:gitlab.psql:52: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "events_pkey" for table "events"
CREATE TABLE
INSERT 0 1989
INSERT 0 1341
INSERT 0 1335
INSERT 0 1656
INSERT 0 1560
INSERT 0 78
psql:gitlab.psql:68: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "forked_project_links_pkey" for table "forked_project_links"
psql:gitlab.psql:68: NOTICE: CREATE TABLE / UNIQUE will create implicit index "forked_project_links_forked_to_project_id_key" for table "forked_project_links"
CREATE TABLE
INSERT 0 2
psql:gitlab.psql:87: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "issues_pkey" for table "issues"
psql:gitlab.psql:87: NOTICE: CREATE TABLE / UNIQUE will create implicit index "issues_project_id_iid_key" for table "issues"
CREATE TABLE
INSERT 0 121
psql:gitlab.psql:100: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "keys_pkey" for table "keys"
CREATE TABLE
INSERT 0 25
psql:gitlab.psql:113: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "merge_request_diffs_pkey" for table "merge_request_diffs"
psql:gitlab.psql:113: NOTICE: CREATE TABLE / UNIQUE will create implicit index "merge_request_diffs_merge_request_id_key" for table "merge_request_diffs"
CREATE TABLE
INSERT 0 6
INSERT 0 1
INSERT 0 4
INSERT 0 1
psql:gitlab.psql:119: ERROR: syntax error at or near "NULL"
LINE 1: ...',\n + `comment_date` datetime NOT NULL DEFAULT 'NULL',\...
and several more errors like that, maybe an encoding issue? I'm using utf-8. We have some issues on spanish and portuguese language, maybe some special characters are breaking the DB.
Let me know if you need more info