MySQL blob type into PostgreSQL for jira and confluence

[Deleted user]

What is the recommended method to switch from MySQL to PostgreSQL for jira and confluence

According to AWS SCT report I see only 6 issues, so that is not so bad. But I am trying to find out how people fix jira blob type when migrated from mysql to postgres. 

Issue 8706: Unable to convert datatypes

Recommended action: To store data of this type in PostgreSQL, use a PostgreSQL-compatible type or use a composite type.

Issue code: 8706 | Number of occurrences: 6 | Estimated complexity: Simple

Schemas.jira.Tables.JQUARTZ_BLOB_TRIGGERS.Columns.BLOB_DATA Schemas.jira.Tables.JQUARTZ_CALENDARS.Columns.CALENDAR Schemas.jira.Tables.JQUARTZ_JOB_DETAILS.Columns.JOB_DATA Schemas.jira.Tables.JQUARTZ_TRIGGERS.Columns.JOB_DATA Schemas.jira.Tables.clusteredjob.Columns.PARAMETERS Schemas.jira.Tables.propertydata.Columns.propertyvalue

I am trying to convert from MySQL 5.7 to PostgreSQL 9.6 using Jira Software DC 8.5.1

AWS SCT suggests this

From MySQL:

CREATE TABLE IF NOT EXISTS jira.propertydata (
ID decimal(18,0) NOT NULL,
propertyvalue blob(65535) DEFAULT NULL,
PRIMARY KEY (ID)
);

TO PostgreSQL:

CREATE TABLE IF NOT EXISTS jira.propertydata(
id numeric(18,0) NOT NULL,
propertyvalue bytea DEFAULT NULL
);

I have those 6 tables with MySQL blob type with similar recommendations to convert to PostgreSQL.

Looking to see how people handled these database incompatibilities.

Thanks

Asif

[Deleted user]

Do I use bytea for postgresql?