Hey,
I faced the same issue and decided to do my migration “by hand”
I installed a new container with frappe v14 on a side, backuped my v13 database through bench backup
.
I restored the database with command psql mytable < mybackup
V14 comes with new tables, so I created it with this script:
-- Table: public."tabDocType State"
-- DROP TABLE public."tabDocType State";
CREATE TABLE public."tabDocType State"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
title character varying(140) COLLATE pg_catalog."default",
color character varying(140) COLLATE pg_catalog."default" DEFAULT 'Blue'::character varying,
custom smallint NOT NULL DEFAULT 0,
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabDocType State_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabDocType State"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabData Import Log"
-- DROP TABLE public."tabData Import Log";
CREATE TABLE public."tabData Import Log"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
data_import character varying(140) COLLATE pg_catalog."default",
row_indexes text COLLATE pg_catalog."default",
success smallint NOT NULL DEFAULT 0,
docname character varying(140) COLLATE pg_catalog."default",
messages text COLLATE pg_catalog."default",
exception text COLLATE pg_catalog."default",
log_index bigint NOT NULL DEFAULT 0,
_user_tags text COLLATE pg_catalog."default",
_comments text COLLATE pg_catalog."default",
_assign text COLLATE pg_catalog."default",
_liked_by text COLLATE pg_catalog."default",
CONSTRAINT "tabData Import Log_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabData Import Log"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabDocument Share Key"
-- DROP TABLE public."tabDocument Share Key";
CREATE TABLE public."tabDocument Share Key"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
reference_doctype character varying(140) COLLATE pg_catalog."default",
reference_docname character varying(140) COLLATE pg_catalog."default",
key character varying(140) COLLATE pg_catalog."default",
expires_on date,
_user_tags text COLLATE pg_catalog."default",
_comments text COLLATE pg_catalog."default",
_assign text COLLATE pg_catalog."default",
_liked_by text COLLATE pg_catalog."default",
CONSTRAINT "tabDocument Share Key_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabDocument Share Key"
OWNER to _2de17b05f9ed9da2;
-- Index: reference_docname
-- DROP INDEX public.reference_docname;
CREATE INDEX reference_docname
ON public."tabDocument Share Key" USING btree
(reference_docname COLLATE pg_catalog."default")
TABLESPACE pg_default;
-- Table: public."tabIMAP Folder"
-- DROP TABLE public."tabIMAP Folder";
CREATE TABLE public."tabIMAP Folder"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
folder_name character varying(140) COLLATE pg_catalog."default",
append_to character varying(140) COLLATE pg_catalog."default",
uidvalidity character varying(140) COLLATE pg_catalog."default",
uidnext character varying(140) COLLATE pg_catalog."default",
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabIMAP Folder_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabIMAP Folder"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabLogs To Clear"
-- DROP TABLE public."tabLogs To Clear";
CREATE TABLE public."tabLogs To Clear"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
ref_doctype character varying(140) COLLATE pg_catalog."default",
days bigint NOT NULL DEFAULT 30,
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabLogs To Clear_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabLogs To Clear"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabNewsletter Attachment"
-- DROP TABLE public."tabNewsletter Attachment";
CREATE TABLE public."tabNewsletter Attachment"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
attachment text COLLATE pg_catalog."default",
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabNewsletter Attachment_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabNewsletter Attachment"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabPackage"
-- DROP TABLE public."tabPackage";
CREATE TABLE public."tabPackage"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
package_name character varying(140) COLLATE pg_catalog."default",
readme text COLLATE pg_catalog."default",
license_type character varying(140) COLLATE pg_catalog."default",
license text COLLATE pg_catalog."default",
_user_tags text COLLATE pg_catalog."default",
_comments text COLLATE pg_catalog."default",
_assign text COLLATE pg_catalog."default",
_liked_by text COLLATE pg_catalog."default",
CONSTRAINT "tabPackage_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabPackage"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabPackage Import"
-- DROP TABLE public."tabPackage Import";
CREATE TABLE public."tabPackage Import"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
attach_package text COLLATE pg_catalog."default",
activate smallint NOT NULL DEFAULT 0,
force smallint NOT NULL DEFAULT 0,
log text COLLATE pg_catalog."default",
_user_tags text COLLATE pg_catalog."default",
_comments text COLLATE pg_catalog."default",
_assign text COLLATE pg_catalog."default",
_liked_by text COLLATE pg_catalog."default",
CONSTRAINT "tabPackage Import_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabPackage Import"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabPackage Release"
-- DROP TABLE public."tabPackage Release";
CREATE TABLE public."tabPackage Release"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
"package" character varying(140) COLLATE pg_catalog."default",
publish smallint NOT NULL DEFAULT 0,
path text COLLATE pg_catalog."default",
major bigint NOT NULL DEFAULT 0,
minor bigint NOT NULL DEFAULT 0,
patch bigint NOT NULL DEFAULT 0,
release_notes text COLLATE pg_catalog."default",
_user_tags text COLLATE pg_catalog."default",
_comments text COLLATE pg_catalog."default",
_assign text COLLATE pg_catalog."default",
_liked_by text COLLATE pg_catalog."default",
CONSTRAINT "tabPackage Release_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabPackage Release"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabPrint Format Field Template"
-- DROP TABLE public."tabPrint Format Field Template";
CREATE TABLE public."tabPrint Format Field Template"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
document_type character varying(140) COLLATE pg_catalog."default",
field character varying(140) COLLATE pg_catalog."default",
template_file character varying(140) COLLATE pg_catalog."default",
module character varying(140) COLLATE pg_catalog."default",
standard smallint NOT NULL DEFAULT 0,
template text COLLATE pg_catalog."default",
_user_tags text COLLATE pg_catalog."default",
_comments text COLLATE pg_catalog."default",
_assign text COLLATE pg_catalog."default",
_liked_by text COLLATE pg_catalog."default",
CONSTRAINT "tabPrint Format Field Template_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabPrint Format Field Template"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabWeb Form List Column"
-- DROP TABLE public."tabWeb Form List Column";
CREATE TABLE public."tabWeb Form List Column"
(
name bigint NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
fieldname character varying(140) COLLATE pg_catalog."default",
fieldtype character varying(140) COLLATE pg_catalog."default",
label character varying(140) COLLATE pg_catalog."default",
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabWeb Form List Column_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabWeb Form List Column"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabWorkflow Action Permitted Role"
-- DROP TABLE public."tabWorkflow Action Permitted Role";
CREATE TABLE public."tabWorkflow Action Permitted Role"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
role character varying(140) COLLATE pg_catalog."default",
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabWorkflow Action Permitted Role_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabWorkflow Action Permitted Role"
OWNER to _2de17b05f9ed9da2;
-- Table: public."tabWorkspace Quick List"
-- DROP TABLE public."tabWorkspace Quick List";
CREATE TABLE public."tabWorkspace Quick List"
(
name character varying(140) COLLATE pg_catalog."default" NOT NULL,
creation timestamp(6) without time zone,
modified timestamp(6) without time zone,
modified_by character varying(140) COLLATE pg_catalog."default",
owner character varying(140) COLLATE pg_catalog."default",
docstatus smallint NOT NULL DEFAULT '0'::smallint,
idx bigint NOT NULL DEFAULT '0'::bigint,
document_type character varying(140) COLLATE pg_catalog."default",
label character varying(140) COLLATE pg_catalog."default",
quick_list_filter text COLLATE pg_catalog."default",
parent character varying(140) COLLATE pg_catalog."default",
parentfield character varying(140) COLLATE pg_catalog."default",
parenttype character varying(140) COLLATE pg_catalog."default",
CONSTRAINT "tabWorkspace Quick List_pkey" PRIMARY KEY (name)
)
TABLESPACE pg_default;
ALTER TABLE public."tabWorkspace Quick List"
OWNER to _2de17b05f9ed9da2;