Mercurial > hg > orthanc-book
comparison Sphinx/source/plugins/postgresql.rst @ 270:f29d75bc5c25
more info about database locking
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Sat, 24 Aug 2019 10:53:13 +0200 |
| parents | 39609c9a2c41 |
| children | 6cbcdb965ad3 |
comparison
equal
deleted
inserted
replaced
| 269:182f4fdeeb47 | 270:f29d75bc5c25 |
|---|---|
| 207 | 207 |
| 208 Several advanced options are available as well to fine-tune the | 208 Several advanced options are available as well to fine-tune the |
| 209 configuration of the PostgreSQL plugins. They are documented below. | 209 configuration of the PostgreSQL plugins. They are documented below. |
| 210 | 210 |
| 211 | 211 |
| 212 .. _postgresql-lock: | |
| 213 | |
| 212 Locking | 214 Locking |
| 213 ^^^^^^^ | 215 ^^^^^^^ |
| 214 | 216 |
| 215 .. highlight:: json | 217 .. highlight:: json |
| 216 | 218 |
| 238 | 240 |
| 239 Obviously, one must be very cautious when sharing the same database | 241 Obviously, one must be very cautious when sharing the same database |
| 240 between instances of Orthanc. In particular, all these instances | 242 between instances of Orthanc. In particular, all these instances |
| 241 should share the same configuration. | 243 should share the same configuration. |
| 242 | 244 |
| 245 Furthermore, the core of Orthanc does not currently support the replay | |
| 246 of database transactions, which is necessary to deal with conflicts | |
| 247 between several instances of Orthanc that would simultaneously write | |
| 248 to the database. | |
| 249 | |
| 250 As a consequence, as of Orthanc 1.5.7, when connecting multiple | |
| 251 Orthanc to a single database by setting ``Lock`` to ``false``, there | |
| 252 should only be one instance of Orthanc acting as a writer and all the | |
| 253 other instances of Orthanc acting as readers only. Be careful to set | |
| 254 the option ``SaveJobs`` to ``false`` in the configuration file of all | |
| 255 the instances of Orthanc acting as readers. | |
| 256 | |
| 257 A refactoring is needed to improve the core of Orthanc in that | |
| 258 respect, for which we are looking for funding/donation from the | |
| 259 industry. Some issues reported in our bug tracker call for this | |
| 260 refactoring: `issue 83 | |
| 261 <https://bitbucket.org/sjodogne/orthanc/issues/83/>`__, `issue 121 | |
| 262 <https://bitbucket.org/sjodogne/orthanc/issues/121/>`__, `issue 151 | |
| 263 <https://bitbucket.org/sjodogne/orthanc/issues/151/>`__. | |
| 264 | |
| 265 | |
| 243 | 266 |
| 244 Keep-alive | 267 Keep-alive |
| 245 ^^^^^^^^^^ | 268 ^^^^^^^^^^ |
| 246 | 269 |
| 247 .. highlight:: text | 270 .. highlight:: text |