Mercurial > hg > orthanc-book

comparison Sphinx/source/plugins/postgresql.rst @ 358:011b01ccf52d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fixing external hyperlinks
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 30 Mar 2020 18:47:35 +0200
parents a5f7fc9fb611
children 84e3a2612c36
comparison
equal deleted inserted replaced
357:6b432ce3a56e 358:011b01ccf52d
9 The Orthanc project provides two **official** plugins to replace the 9 The Orthanc project provides two **official** plugins to replace the
10 default storage area (on the filesystem) and the default SQLite index 10 default storage area (on the filesystem) and the default SQLite index
11 by a PostgreSQL database. 11 by a PostgreSQL database.
12 12
13 For general information, check out the `official homepage of the 13 For general information, check out the `official homepage of the
14 plugins <http://www.orthanc-server.com/static.php?page=postgresql>`__. 14 plugins <https://www.orthanc-server.com/static.php?page=postgresql>`__.
15 15
16 16
17 17
18 Compilation 18 Compilation
19 ----------- 19 -----------
40 40
41 Microsoft Windows and Apple OS X 41 Microsoft Windows and Apple OS X
42 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 42 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
43 43
44 Pre-compiled binaries for Microsoft Windows `are also available 44 Pre-compiled binaries for Microsoft Windows `are also available
45 <http://www.orthanc-server.com/browse.php?path=/plugin-postgresql>`__. 45 <https://www.orthanc-server.com/browse.php?path=/plugin-postgresql>`__.
46 A package for `Apple's Mac OS X 46 A package for `Apple's Mac OS X
47 <http://www.osimis.io/en/download.html>`__ 47 <https://www.osimis.io/en/download.html>`__
48 is available courtesy of `Osimis <http://osimis.io/>`__. 48 is available courtesy of `Osimis <https://www.osimis.io/>`__.
49 49
50 50
51 .. _postgresql-ubuntu1604: 51 .. _postgresql-ubuntu1604:
52 52
53 Dynamic linking on Ubuntu 16.04 53 Dynamic linking on Ubuntu 16.04
98 98
99 You of course first have to :ref:`install Orthanc <binaries>`, with a 99 You of course first have to :ref:`install Orthanc <binaries>`, with a
100 version above 0.9.5. You then have to **create a database** dedicated 100 version above 0.9.5. You then have to **create a database** dedicated
101 to Orthanc on some PostgreSQL server. Please refer to the `PostgreSQL 101 to Orthanc on some PostgreSQL server. Please refer to the `PostgreSQL
102 documentation 102 documentation
103 <https://www.postgresql.org/docs/current/static/tutorial-createdb.html>`__. 103 <https://www.postgresql.org/docs/current/tutorial-createdb.html>`__.
104 104
105 Once Orthanc is installed and the database is created, you must add a 105 Once Orthanc is installed and the database is created, you must add a
106 section in the :ref:`configuration file <configuration>` that 106 section in the :ref:`configuration file <configuration>` that
107 specifies the address of the **PostgreSQL server together with your 107 specifies the address of the **PostgreSQL server together with your
108 credentials**. You also have to tell Orthanc in which path it can find 108 credentials**. You also have to tell Orthanc in which path it can find
178 178
179 .. highlight:: json 179 .. highlight:: json
180 180
181 Instead of specifying explicit authentication parameters, you can also 181 Instead of specifying explicit authentication parameters, you can also
182 use the `PostgreSQL connection URIs syntax 182 use the `PostgreSQL connection URIs syntax
183 <https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-CONNSTRING>`__. For 183 <https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING>`__. For
184 instance:: 184 instance::
185 185
186 { 186 {
187 "Name" : "MyOrthanc", 187 "Name" : "MyOrthanc",
188 "PostgreSQL" : { 188 "PostgreSQL" : {
197 } 197 }
198 198
199 199
200 **Remark:** The Debian Med project maintains `another useful set of 200 **Remark:** The Debian Med project maintains `another useful set of
201 instructions 201 instructions
202 <https://anonscm.debian.org/viewvc/debian-med/trunk/packages/orthanc-postgresql/trunk/debian/README.Debian?view=markup>`__. 202 <https://salsa.debian.org/med-team/orthanc-postgresql/-/blob/master/debian/README.Debian>`__.
203 203
204 204
205 Advanced options 205 Advanced options
206 ---------------- 206 ----------------
207 207
216 216
217 .. highlight:: json 217 .. highlight:: json
218 218
219 By default, the plugins lock the database (using `PostgreSQL advisory 219 By default, the plugins lock the database (using `PostgreSQL advisory
220 locks 220 locks
221 <https://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS>`__) 221 <https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS>`__)
222 to prevent other instances of Orthanc from using the same PostgreSQL 222 to prevent other instances of Orthanc from using the same PostgreSQL
223 database. If you want several instances of Orthanc to share the same 223 database. If you want several instances of Orthanc to share the same
224 database, set the ``Lock`` option to ``false`` in the configuration 224 database, set the ``Lock`` option to ``false`` in the configuration
225 file:: 225 file::
226 226
278 This probably means the server terminated abnormally before or while processing the request. 278 This probably means the server terminated abnormally before or while processing the request.
279 E0220 06:51:03.924868 PluginsManager.cpp:163] Exception in database back-end: Error in PostgreSQL: no connection to the server 279 E0220 06:51:03.924868 PluginsManager.cpp:163] Exception in database back-end: Error in PostgreSQL: no connection to the server
280 280
281 This is due to a timeout in the PostgreSQL server. Please make sure to 281 This is due to a timeout in the PostgreSQL server. Please make sure to
282 `enable keep-alive 282 `enable keep-alive
283 <http://dba.stackexchange.com/questions/97534/is-there-a-timeout-option-for-remote-access-to-postgresql-database>`__ 283 <https://dba.stackexchange.com/questions/97534/is-there-a-timeout-option-for-remote-access-to-postgresql-database>`__
284 in the configuration of your PostgreSQL server 284 in the configuration of your PostgreSQL server