Mercurial > hg > orthanc-book

changeset 1198:ad089b8324a7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
pg updates
author Alain Mazy <am@orthanc.team>
date Fri, 03 Oct 2025 16:21:24 +0200
parents d0c46b494987
children fc98b7b10d47
files Sphinx/source/plugins/postgresql.rst
diffstat 1 files changed, 6 insertions(+), 27 deletions(-) [+]
line wrap: on
line diff
--- a/Sphinx/source/plugins/postgresql.rst	Thu Oct 02 14:58:30 2025 +0200
+++ b/Sphinx/source/plugins/postgresql.rst	Fri Oct 03 16:21:24 2025 +0200
@@ -372,44 +372,23 @@
 Therefore, in complex setups, it might be simpler/safer to simply shut-down the Orthanc containers, perform the upgrade
 manually and then, restart the Orthanc containers with the newest version of the plugin.
 
-To upgrade manually from revision 1 to revision 2, one might run this procedure on the existing DB (note: make
+To upgrade manually from revision 1 to revision 6, one might run this procedure on the existing DB (note: make
 sur to select the correct DB and schema (Orthanc is using the default ``public`` shema))::
 
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev1ToRev2.sql
-  $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/PrepareIndex.sql
-  $ psql -U postgres -f Rev1ToRev2.sql
-  $ psql -U postgres -f PrepareIndex.sql
-
-To upgrade manually from revision 2 to revision 3::
-
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev2ToRev3.sql
-  $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/PrepareIndex.sql
-  $ psql -U postgres -f Rev2ToRev3.sql
-  $ psql -U postgres -f PrepareIndex.sql
-
-To upgrade manually from revision 3 to revision 4::
-
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev3ToRev4.sql
-  $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/PrepareIndex.sql
-  $ psql -U postgres -f Rev3ToRev4.sql
-  $ psql -U postgres -f PrepareIndex.sql
-
-To upgrade manually from revision 4 to revision 5::
-
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev4ToRev5.sql
-  $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/PrepareIndex.sql
-  $ psql -U postgres -f Rev4ToRev5.sql
-  $ psql -U postgres -f PrepareIndex.sql
-
-To upgrade manually from revision 5 to revision 6::
-
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev5ToRev6.sql
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/PrepareIndex.sql
+  $ psql -U postgres -f Rev1ToRev2.sql          # skip this step if you are already in Rev2 or higher
+  $ psql -U postgres -f Rev2ToRev3.sql          # skip this step if you are already in Rev3 or higher
+  $ psql -U postgres -f Rev3ToRev4.sql          # skip this step if you are already in Rev4 or higher
+  $ psql -U postgres -f Rev4ToRev5.sql          # skip this step if you are already in Rev5 or higher
   $ psql -U postgres -f Rev5ToRev6.sql
   $ psql -U postgres -f PrepareIndex.sql
 
-These procedures are identical to the one performed automatically by Orthanc when it detects that an upgraded is required.
-
+These procedures are identical to the ones performed automatically by Orthanc when it detects that an upgraded is required.
 
 
 Here are typical upgrade durations we have observed, on a DB with around 350.000 studies and more than 150 millions instances