Help with Index Migration from SQLite to PostgreSQL using python-orthanc-tools

[alainmazy]

Hi @HenrikPLind

@HenrikPLind

At the moment, I’ve pointed the StorageDirectory in my PostgreSQL Orthanc setup to a new location that’s indexed by the OrthancIndexer.dll plugin via a configured indexer.json file. This symlinked folder is currently being processed, and based on the logs and performance, it looks like the indexing will take approximately a week to complete.

Indexing your own StorageDirectory looks very weird to me and the behaviour might be unpredictable.

As you might have seen, we have just released a new advanced storage plugin that should facilitate this type of migration (full documentation).

Your migration scenario has been described in this Docker setup (you can just reuse the configurations on Windows).

If I understand correctly, you would now have 2 “old storages”, the initial SQLite one and the one for PG that has already received some data → you should therefore start another Orthanc instance with the new plugin and yet another empty StorageDirectory and index these 2 “old” folders.

Hope this helps,

Alain.