changeset 1299:3c2e7b3188a0

PG 11
author Alain Mazy <am@orthanc.team>
date Mon, 21 Sep 2026 09:34:08 +0200
parents bf8c8edded61
children 2b9dfe62324e 4275817a607e
files Sphinx/source/plugins/postgresql.rst
diffstat 1 files changed, 13 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/Sphinx/source/plugins/postgresql.rst	Thu Sep 10 07:55:36 2026 +0200
+++ b/Sphinx/source/plugins/postgresql.rst	Mon Sep 21 09:34:08 2026 +0200
@@ -338,17 +338,24 @@
 +---------------------------+-------------------------------------------+
 | 9.0                       | 6                                         |
 +---------------------------+-------------------------------------------+
-| 10.0 - 10.X               | 10 (skipped 7, 8 and 9 to sync schema     |
+| 10.0 - 10.3               | 10 (skipped 7, 8 and 9 to sync schema     |
 |                           | revision and plugin version)              |
 +---------------------------+-------------------------------------------+
+| 11.0                      | 11                                        |
++---------------------------+-------------------------------------------+
 
 
 Upgrades from one revision to the other is always automatic.  Furthermore, if you are upgrading
-from e.g plugin 3.3 to 10.0, Orthanc will apply all migration steps autonomously.
+from e.g plugin 3.3 to 11.0, Orthanc will apply all migration steps autonomously.
 
 However, if, for some reasons, you would like to reinstall a previous plugin version, the
 older plugin might refuse to start because the revision is newer and unknown to it.
 
+To downgrade from revision 11 to revision 10, one might run this procedure::
+
+  $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev11ToRev10.sql
+  $ psql -U postgres -f Rev10ToRev6.sql
+
 To downgrade from revision 10 to revision 6, one might run this procedure::
 
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql
@@ -396,7 +403,7 @@
 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 6, one might run this procedure on the existing DB (note: make
+To upgrade manually from revision 1 to revision 11, one might run this procedure on the existing DB (note: make
 sur to select the correct DB and schema (By default, Orthanc is using the ``public`` shema))::
 
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev1ToRev2.sql
@@ -405,13 +412,15 @@
   $ 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/Upgrades/Rev5ToRev6.sql
   $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev6ToRev10.sql
+  $ wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Upgrades/Rev10ToRev11.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          # skip this step if you are already in Rev6 or higher
-  $ psql -U postgres -f Rev6ToRev10.sql
+  $ psql -U postgres -f Rev6ToRev10.sql         # skip this step if you are already in Rev10 or higher
+  $ psql -U postgres -f Rev10ToRev11.sql
   $ psql -U postgres -f PrepareIndex.sql
 
 These procedures are identical to the ones performed automatically by Orthanc when it detects that an upgraded is required.