Hello Team,
When I installed the Orthanc I kept the default DB (SQLite) for indexing only not for store, After atwo months I see that the DB growth to be more than 7 GB and the performance slow, so I want to work with PostgreSQL.
How can I migrate or reindexing from SQLite to Postgres ?
Best regards
After a few works, I found the tools PgLoader, I use it and it take around 1 hour to migrate the DB from sqlite to Postgre.
but I notice that some columns name different between sqlite and postgre for example in table attachedfiles the column, compressedMD5 in sqlite and compressedhash in postgres.
by the way the orthanc did not work correctly and can not open the studies, so I roleback to SQLite.
I tried also the pythonscript to scan the folder where the data stored but it did not work because I used “StorageCompression” : true in orthanc.json
any Idea please ?
Hello
The schemas are indeed not compatible between DB engines.
Your best bet is to use the OrthancCloner Python class to transfer all studies from the SQLite Orthanc to the Postgres one. Once everything has been transferred, you can switch to the new Postgres one. You can find the documentation here.
HTH