database-migrator icon indicating copy to clipboard operation
database-migrator copied to clipboard

Not able to migrate secrets while migrating from sqlite to PostgreSql

Open simplyrahul1 opened this issue 1 year ago • 1 comments
trafficstars

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/[email protected]');

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

simplyrahul1 avatar Mar 14 '24 09:03 simplyrahul1