annotate PostgreSQL/NEWS @ 358:1280b40d6696

switch to OpenSSL 3.0.x
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 21 Feb 2022 09:27:40 +0100
parents b783063f51f1
children d2b5d9c92214 b5e2c1e48828
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
1 Pending changes in the mainline
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
2 ===============================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
3
358
1280b40d6696 switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 276
diff changeset
4 * Upgraded dependencies for static builds (notably on Windows and LSB):
1280b40d6696 switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 276
diff changeset
5 - openssl 3.0.1
1280b40d6696 switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 276
diff changeset
6
276
b783063f51f1 OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 269
diff changeset
7
b783063f51f1 OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 269
diff changeset
8 Release 4.0 (2021-04-22)
b783063f51f1 OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 269
diff changeset
9 ========================
b783063f51f1 OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 269
diff changeset
10
253
3bc442765b88 new configuration option: "IndexConnectionsCount"
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 248
diff changeset
11 * New option "IndexConnectionsCount" to control how many simultaneous
3bc442765b88 new configuration option: "IndexConnectionsCount"
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 248
diff changeset
12 connections to the PostgreSQL database are used by the index plugin
266
cc7af42d4f23 Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 253
diff changeset
13 * Support of revisions for metadata and attachments
248
7a4f9bcb0bc2 PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 243
diff changeset
14 * Support of multiple readers/writers, by handling retries from Orthanc SDK 1.9.2
7a4f9bcb0bc2 PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 243
diff changeset
15 * Support of range reads for the storage area, from Orthanc SDK 1.9.0
267
ece4663dedde Fix issue #193
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 266
diff changeset
16 * Fix issue #193 (LSB binaries crash with PostgreSQL + SSL) by changeset
ece4663dedde Fix issue #193
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 266
diff changeset
17 in OrthancFramework: https://hg.orthanc-server.com/orthanc/rev/9a9118406484
269
567761f0c1ea fix issue #151: support of retries in the storage area plugins to deal with multiple writers
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 268
diff changeset
18 * Fix issue #151 (Storage failures when running with two instances and PG_LOCK=false)
195
53bd9022c58b Support of "OrthancPluginRegisterStorageArea2()" from Orthanc SDK 1.9.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 179
diff changeset
19
179
9b500ad566c0 OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 172
diff changeset
20
9b500ad566c0 OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 172
diff changeset
21 Release 3.3 (2020-12-14)
9b500ad566c0 OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 172
diff changeset
22 ========================
9b500ad566c0 OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 172
diff changeset
23
134
cc3dc759c989 Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 132
diff changeset
24 * Added an advisory lock to avoid race conditions during database setup
141
0b3e9ee53c46 Added 'MaximumConnectionRetries' & 'ConnectionRetryInterval' to configure the retries when connecting to the DB at startup
Alain Mazy <alain@mazy.be>
parents: 134
diff changeset
25 * Added "MaximumConnectionRetries" & "ConnectionRetryInterval" to configure
0b3e9ee53c46 Added 'MaximumConnectionRetries' & 'ConnectionRetryInterval' to configure the retries when connecting to the DB at startup
Alain Mazy <alain@mazy.be>
parents: 134
diff changeset
26 the retries when connecting to the DB at startup
156
710537acb488 dynamic linking against the system-wide Orthanc framework library
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 141
diff changeset
27 * Support of dynamic linking against the system-wide Orthanc framework library
172
8c7bb94adff7 trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 156
diff changeset
28 * Upgraded dependencies for static builds (notably on Windows and LSB):
8c7bb94adff7 trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 156
diff changeset
29 - openssl 1.1.1g
268
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 267
diff changeset
30 - libpq 13.1 (replacing libpq 9.6.1)
134
cc3dc759c989 Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 132
diff changeset
31
132
5c69c2a14c97 OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 130
diff changeset
32
5c69c2a14c97 OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 130
diff changeset
33 Release 3.2 (2019-03-01)
5c69c2a14c97 OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 130
diff changeset
34 ========================
5c69c2a14c97 OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 130
diff changeset
35
130
2d2b268799a2 Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 125
diff changeset
36 * Explicit deallocation of prepared statements
2d2b268799a2 Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 125
diff changeset
37
125
b85d672afcb5 OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 121
diff changeset
38
b85d672afcb5 OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 121
diff changeset
39 Release 3.1 (2019-02-08)
b85d672afcb5 OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 121
diff changeset
40 ========================
b85d672afcb5 OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 121
diff changeset
41
103
9263b3de37ed fix build on Debian Buster
jodogne
parents: 100
diff changeset
42 * Fix build on Debian Buster
106
b559af8fe6e0 Remove "ASSERT" in SQL for compatibility with older releases of PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 103
diff changeset
43 * Remove "ASSERT" in SQL for compatibility with older releases of PostgreSQL
117
ca0ecd412988 Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 106
diff changeset
44 * Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
121
0886da5b4816 integration pg-tcp-nodelay->mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 117
diff changeset
45 * Performance: Defining option "TCP_NODELAY" if libpq is linked statically
103
9263b3de37ed fix build on Debian Buster
jodogne
parents: 100
diff changeset
46
100
deab01d8e1c8 set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 82
diff changeset
47
deab01d8e1c8 set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 82
diff changeset
48 Release 3.0 (2019-01-21)
deab01d8e1c8 set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 82
diff changeset
49 ========================
deab01d8e1c8 set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 82
diff changeset
50
81
515a783630df injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 56
diff changeset
51 * New configuration option: "EnableSsl"
80
16df1a6ea452 Fix issue 105 (Unable to connect to PostgreSQL database using SSL)
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 75
diff changeset
52 * Database optimizations by implementing new primitives of Orthanc SDK 1.5.2
81
515a783630df injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 56
diff changeset
53 * Fix issue 105 (Unable to connect to PostgreSQL database using SSL)
56
4f66bc893fc3 Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 48
diff changeset
54 * Fix Debian issue #906771 (Uncaught exception prevents db intialization
4f66bc893fc3 Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 48
diff changeset
55 (likely related to pg_trgm))
48
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 42
diff changeset
56 * Fix: Catching exceptions in destructors
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 42
diff changeset
57
33
860542a0a64b set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 29
diff changeset
58
42
4c3f767ead03 set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 33
diff changeset
59 Release 2.2 (2018-07-16)
33
860542a0a64b set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 29
diff changeset
60 ========================
860542a0a64b set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 29
diff changeset
61
29
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
62 !! Important remark when upgrading from an older version of the plugin:
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
63
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
64 The plugin will create a new index to improve search performance.
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
65 This can take several minutes at the first Orthanc startup. Orthanc
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
66 will not be available during this period. On a PostgreSQL database
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
67 with 100,000 studies, we have observed that updating the index took
2fb9cd42af14 cppcheck
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 19
diff changeset
68 around 10 minutes.
19
38e23471d132 more visibility on the index creation
am@osimis.io
parents: 0
diff changeset
69
0
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
70 * Migration into the "orthanc-databases" repository
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
71 * Full refactoring to share code with MySQL
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
72 * Fix issue 41 (Additional range IdentifierConstraintType in Orthanc)
33
860542a0a64b set version
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 29
diff changeset
73 !! This fix requires Orthanc version >= 1.4.0
0
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
74 * Fix issue 47 (Index improvements for PG plugin)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
75 * Fix issue 76 (PG connection shall reconnect/retry in case it loses
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
76 the connection to the server)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
77
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
78
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
79 Release 2.1 (2018-04-20)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
80 ========================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
81
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
82 * Running transactions in "Serializable" isolation level to avoid
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
83 inconsistencies if multiple Orthanc are writing to the same DB
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
84 * Upgrade to PostgreSQL 9.6.1 client library for static builds
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
85 * Performance warning if runtime debug assertions are turned on
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
86 * Fix issue 62 (use correct type for lo_read() value)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
87 * Fix issue 63 (allow to connect without specifing username and/or port)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
88 * Fix issue 68 (PostgreSQL plugin needs extra flags to compile)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
89 * Resort to Orthanc framework
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
90 * Support of Linux Standard Base, OpenBSD and FreeBSD
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
91
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
92
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
93 Release 2.0 (2015-12-02)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
94 ========================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
95
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
96 => Minimum SDK version: 0.9.5 <=
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
97 => Supported database versions: 5 (upgrade only) and 6 <=
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
98
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
99 * Support version 6 of the database schema
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
100 * The "value" column of tables "MainDicomTags" and "DicomIdentifiers" are now TEXT instead of BYTEA
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
101
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
102
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
103 Release 1.3 (2015-10-07)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
104 ========================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
105
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
106 => Minimum SDK version: 0.9.4 <=
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
107 => Supported database versions: 5 <=
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
108
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
109 * Fix build with Orthanc plugin SDK 0.9.4
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
110 * Implementation of "GetAllPublicIdsWithLimit" extension
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
111 * Implementation of "UpgradeDatabase" extension
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
112
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
113
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
114 Release 1.2 (2015-08-02)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
115 ========================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
116
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
117 => Minimum SDK version: 0.9.1 <=
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
118
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
119 * Inject version information into Windows binaries
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
120 * CMake flag to prevent compiling the unit tests (if no PostgreSQL test server is available)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
121 * Update to Boost 1.58.0 for static and Windows builds
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
122 * Support of OS X compilation
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
123
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
124
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
125 Release 1.1 (2015-07-03)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
126 ========================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
127
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
128 * Fixes
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
129 * Support of Visual Studio 2008
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
130 * Support of FreeBSD thanks Mikhail <mp39590@gmail.com>
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
131
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
132
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
133 Release 1.0 (2015-02-27)
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
134 ========================
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
135
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
136 * Use of advisory locks
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
137 * Support of connection URI in PostgreSQL
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
138 * Options "EnableIndex" and "EnableStorage" to explicitly enable PostgreSQL
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
139
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
140
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
141 2015-02-06
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
142 ==========
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
143
7cea966b6829 initial commit
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
144 * Initial release