migrate from sqlite to postgresql

[starsareintherose]

I have tried this via pgloader

pgloader /var/lib/maddy/imapsql.db postgres://dnuser:dnuser_passwd@localhost/db_name
2022-06-01T23:36:04.080002+01:00 LOG pgloader version "3.6.62d83f2"
2022-06-01T23:36:04.100002+01:00 LOG Data errors in '/tmp/pgloader/'
2022-06-01T23:36:04.460012+01:00 LOG Migrating from #<SQLITE-CONNECTION sqlite:///var/lib/maddy/imapsql.db {10071B9393}>
2022-06-01T23:36:04.460012+01:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://mail@localhost:5432/maddy {1007381A63}>
2022-06-01T23:36:05.100030+01:00 ERROR Database error 42704: type "longtext" does not exist
QUERY: CREATE TABLE msgs 
(
  mboxid        bigint,
  msgid         bigint,
  date          bigint,
  bodylen       bigint,
  mark          bigint default '0',
  bodystructure longtext,
  cachedheader  longtext,
  extbodykey    text default NULL,
  seen          bigint default '0',
  compressalgo  text
);
2022-06-01T23:36:05.100030+01:00 FATAL Failed to create the schema, see above.
2022-06-01T23:36:05.110031+01:00 LOG report summary reset
       table name     errors       rows      bytes      total time
-----------------  ---------  ---------  ---------  --------------
            fetch          0          0                     0.000s
  fetch meta data          0         20                     0.130s
   Create Schemas          0          0                     0.000s
 Create SQL Types          0          0                     0.020s
    Create tables          0          0                     0.000s
-----------------  ---------  ---------  ---------  --------------
-----------------  ---------  ---------  ---------  --------------

there is a clear error, and when I use it, I must make sslmode disable and I can't see nothing in this PostgreSQL db