Not able to migrate secrets while migrating from sqlite to PostgreSql

[simplyrahul1]

psql:postgres_grafana_v2.sql:62753: ERROR: column "encrypted_data" is of type bytea but expression is of type bit
LINE 1: ...a_keys VALUES('P1lrPhq7k',1,'root','secretKey.v1',X'684f4f43...

Please find the line 62753 from the sql file below :
62753 INSERT INTO data_keys VALUES('P1lrPhq7k',1,'root','secretKey.v1',X'684f4f43#####ec09','2022-06-24 22:52:01','2022-06-24 22:52:01','2022-06-24/root@secretKey.v1');

The same is the case for all the secrets. Due to this no user can log in post-migration as above error repeated for all the user accounts

[julimej]

@simplyrahul1 I did a change on the encrypted data.

Changed X'684F4#####' to E'\x684F4#####'.

Hope it works for you