Mercurial > hg > orthanc-book
comparison Sphinx/source/plugins/postgresql.rst @ 1036:b5f57cec7190
PG upgrades on large DB
| author | Alain Mazy <am@osimis.io> |
|---|---|
| date | Sat, 02 Mar 2024 16:38:17 +0100 |
| parents | bbcec5f44c34 |
| children | edd8e2d0eb99 |
comparison
equal
deleted
inserted
replaced
| 1035:9a7d252e1656 | 1036:b5f57cec7190 |
|---|---|
| 349 To downgrade from revision 2 to revision 1, one might run this procedure:: | 349 To downgrade from revision 2 to revision 1, one might run this procedure:: |
| 350 | 350 |
| 351 $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql | 351 $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql |
| 352 $ psql -U postgres -f Rev2ToRev1.sql | 352 $ psql -U postgres -f Rev2ToRev1.sql |
| 353 | 353 |
| 354 Note for large databases and multiple Orthanc instances: | |
| 355 """""""""""""""""""""""""""""""""""""""""""""""""""""""" | |
| 356 | |
| 357 When upgrading from revision 1 to revision 2, the upgrade might take quite some time. E.g, we have observed the upgrade | |
| 358 taking 17 minutes on a DB with 300.000 studies and 150 millions instances. Orthanc will not respond during the upgrade. Therefore, | |
| 359 if you have enabled autohealing (automatic restart in case Orthanc is not responsive), you should likely disable it | |
| 360 during the first start with the PostgreSQL plugin v6.0. | |
| 361 | |
| 362 Also note that, if you have multiple containers connected to the same DB, all containers will try to acquire an exclusive lock | |
| 363 to perform the upgrade of the DB. Only one of them will actually perform the upgrade. Also note that you should not perform a | |
| 364 rolling updates of the Orthanc containers when performing a DB upgrade. All Orthanc containers should use the same version of the | |
| 365 plugin, the one that is compatible with the current revision. | |
| 366 | |
| 367 Therefore, in complex setups, it might be simpler/safer to simply shut-down the Orthanc containers, perform the update | |
| 368 manually and then, restart the Orthanc containers with the newest version of the plugin. | |
| 369 | |
| 370 To upgrade manually from revision 1 to revision 2, one might run this procedure:: | |
| 371 | |
| 372 $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev1ToRev2.sql | |
| 373 $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/PrepareIndex.sql | |
| 374 $ psql -U postgres -f Rev1ToRev2.sql | |
| 375 $ psql -U postgres -f PrepareIndex.sql | |
| 376 | |
| 354 | 377 |
| 355 Troubleshooting | 378 Troubleshooting |
| 356 --------------- | 379 --------------- |
| 357 | 380 |
| 358 SCRAM authentication | 381 SCRAM authentication |