changeset 1038:69a318b7a58e

PG: schema
author Alain Mazy <am@osimis.io>
date Mon, 04 Mar 2024 18:04:12 +0100
parents edd8e2d0eb99
children d57ca05c6478
files Sphinx/source/plugins/postgresql.rst
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/Sphinx/source/plugins/postgresql.rst	Sat Mar 02 16:59:29 2024 +0100
+++ b/Sphinx/source/plugins/postgresql.rst	Mon Mar 04 18:04:12 2024 +0100
@@ -367,7 +367,8 @@
 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::
+To upgrade manually from revision 1 to revision 2, 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