database-migrator
database-migrator copied to clipboard
Not able to migrate secrets while migrating from sqlite to PostgreSql
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