changelog 172 KB
Newer Older
1 2 3 4 5 6 7
postgresql-common (178) UNRELEASED; urgency=medium

  * pg_buildext: Don't ask pg_virtualenv for a new network namespace by
    default.

 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 13 Oct 2016 15:32:49 +0200

8
postgresql-common (177) unstable; urgency=medium
9

10
  [ Martin Pitt ]
11 12 13
  * Replace hardcoded Recommends: libreadline6 with a build-time detection of
    the current ABI.

14
  [ Christoph Berg ]
15
  * Team upload.
16 17
  * Mark 9.6 as stable for apt.postgresql.org.

18
 -- Christoph Berg <christoph.berg@credativ.de>  Wed, 28 Sep 2016 11:55:12 +0200
19

20
postgresql-common (176) unstable; urgency=medium
21

22
  * Team upload.
23
  * Bump default PostgreSQL server version to 9.6.
24 25
  * Use C.UTF-8 instead of C when the initial main cluster is created and no
    locale is configured explicitly as system default. (Closes: #790507)
26
  * Support "NN" major version numbers, next version will be PostgreSQL 10.
27 28 29
  * debian/postgresql-common.templates: Properly mark not-to-be-translated
    shell code-only chunk as such using flag:translate. Thanks to Rhonda for
    the pointer! (See: #820756, #832282)
30
  * testsuite: Run with umask 077 only by default.
31
  * t/025_logging.t: Fix tests when grep thinks syslog is a binary file.
32 33
  * t/031_errors_disk_full.t: Raise tmpfs size to account for larger cluster
    footprint observed on ppc64el.
34
  * t/032_ssl_key_permissions.t: Skip tests on 9.0 and earlier.
35
  * pg_createcluster, t/025_logging.t: Skip logging_collector for 8.2.
36 37
  * Ship /etc/postgresql-common/supported_versions even in non-backport
    packages. (Closes: #808353)
38 39
  * pg_createcluster: Error out if provided log file is a directory.
    (Closes: #791556)
40 41
  * pg_upgradecluster: Set dynamic_shared_memory_type from the new
    postgresql.conf instead of defaulting to mmap. (Closes: #823209)
42 43
  * pg_upgradecluster: Use data checksums in the new cluster if the old uses
    them. (Closes: #830228)
44

45
 -- Christoph Berg <christoph.berg@credativ.de>  Fri, 23 Sep 2016 12:32:16 +0200
46

47
postgresql-common (175) unstable; urgency=medium
48 49

  * pg_createcluster, createcluster.conf: Set cluster_name on 9.5+.
50
  * pg_buildext: Don't set any CFLAGS by default.
51 52
  * start.conf: Update documentation/comments to recommend running
    systemctl daemon-reload.
53

54
 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 23 Jun 2016 12:26:27 +0200
55

56
postgresql-common (174) unstable; urgency=medium
57

58
  [ Christoph Berg ]
59 60
  * postgresql-common: Enforce strict version dependency on
    postgresql-client-common to avoid API mismatch bugs in PgCommon.pm.
61
  * maintscripts-functions: Save pg_dump on catversion bumps as well.
62
  * Updated ja translation by Takuma Yamada, thanks! (Closes: #820756)
63 64 65
  * Remove not-to-be-translated shell code-only chunk from
    debian/po/templates.pot. (debconf-updatepo --skip-pot to the rescue!)
    (Closes: #821445)
66

67 68 69
  [ Martin Pitt ]
  * debian/supported-versions: Add Ubuntu 16.10.

70
 -- Christoph Berg <christoph.berg@credativ.de>  Wed, 11 May 2016 15:04:25 +0200
71

72
postgresql-common (173) unstable; urgency=medium
73

74
  [ Christoph Berg ]
75
  * README.Debian: Fix a typo.
76
  * Updated nl translation, thanks Frans Spiesschaert! (Closes: #812353)
77
  * Updated ru translation, thanks Sergey Alyoshin! (Closes: #815596)
78
  * Updated ja translation, thanks Takuma Yamada! (Closes: #816069)
79
  * preinst_check_catversion: Handle missing catalog version file.
80
  * pg_renamecluster: Don't try to rename a non-existing stats directory.
81
  * pg_conftool: Refuse operation on non-existing clusters.
82 83
  * maintscript-functions, templates: Remove '#' characters from upgrade
    instructions on catalog version change for easier cut-and-paste.
84
  * t/032_ssl_key_permissions.t: Validate server snakeoil key checks.
85
  * pgdg/apt.postgresql.org.sh: Add xenial and trusty.
86

87 88 89 90
  [ Adam Conrad ]
  * pgcommon.sh: Adjust for >= xenial using Debian-style locale generation
    methods, and allow fallback to the old Ubuntu method for old releases.

91
 -- Christoph Berg <myon@debian.org>  Wed, 30 Mar 2016 15:08:06 +0200
92

93
postgresql-common (172) unstable; urgency=medium
94

95
  [ Christoph Berg ]
96
  * pg_buildext: Mute diff warning about missing debian/tests/control.in.
97
  * pg_ctlcluster: Skip systemctl redirect with --bindir.
98 99
  * pg_createcluster: Drop warning if /tmp is used as socket directory.
    Instead, just print the socket directory on cluster creation.
100 101
  * Update French debconf translations, thanks Julien Patriarca!
    (Closes: #809800)
102
  * 9.5 released! Setting as default.
103

104 105
  [ Martin Pitt ]
  * debian/supported-versions: Switch Ubuntu 16.04 to 9.5.
106
  * debian/supported-versions: Drop obsolete Ubuntu versions.
107

108
 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 07 Jan 2016 15:13:06 +0100
109

110
postgresql-common (171) unstable; urgency=medium
111

112
  [ Christoph Berg ]
113
  * pgdg: Deprecate 8.4 and 9.0.
114
  * Enable 9.4 for wheezy-backports.
115 116
  * pg_createcluster: Fix stats_temp_directory handling on 8.3, thanks to
    Marco Nenciarini for the inital patch.
117
  * pg_createcluster: Mute verbose chattr output.
118
  * pg_conftool: Don't quote output in '-s'hort mode.
119 120 121 122
  * debian/maintscripts-functions: If the catalog version changes in
    devel/alpha versions, save a minimal copy of the old version binaries in
    the preinst to enable using pg_upgrade. Use debconf in the postinst to
    instruct the user how to proceed with the upgrade.
123 124
  * pg_buildext: Replace multiple occurrences of PGVERSION on the same line,
    and implement replacing for debian/tests/control.in.
125
  * t/015_start_stop.t: Validate pg_ctlcluster/systemctl exit codes.
126 127
  * pg_ctlcluster: Redirect requests to systemd when invoked as root and no
    extra pg_ctl or postgres options are given.
128
    Trying to start already running clusters clusters will return 0 now
129
    (was 2 in the native implementation). (Closes: #784878)
130
  * pg_createcluster, pg_renamecluster: Warn on cluster names with dashes.
131
  * pg_upgradecluster: Deprecate ssl_renegotiation_limit in 9.5.
132

133 134
  [ Martin Pitt ]
  * pg_upgradecluster: Fix "ANALZYE" typo.
135
  * debian/supported-versions: Add Ubuntu 16.04.
136 137
  * Update Turkish debconf translations, thanks Atila KOÇ!
    (Closes: #799274)
138 139
  * t/020_create_sql_remove.t: Skip postmaster OOM killer adjustment when
    running in a container, as these often have restricted privileges.
140

141
 -- Christoph Berg <christoph.berg@credativ.de>  Fri, 18 Dec 2015 16:22:37 +0100
142

143
postgresql-common (170) unstable; urgency=medium
144

145
  [ Christoph Berg ]
146 147 148
  * pg_createcluster, pg_dropcluster: When an auto-started cluster is created/
    dropped by root, notify systemd to update the dependencies of
    postgresql.service.wants.
149
  * pg_dropcluster, pg_renamecluster: Handle stats_temp_directory.
150
  * testsuite, pg_virtualenv: Remove the unshare hack, too much trouble.
151 152
  * pg_buildext, pg_virtualenv: Add PG_VIRTUALENV_NEWPID and
    PG_VIRTUALENV_UNSHARE variables; pg_buildext selects unshare -n by default.
153
  * t/025_logging.t: Improve syslog detection in the test environment.
154 155
  * pg_upgradecluster, t/030_errors.t: Unbreak after we changed the old=new
    error message.
156 157
  * PgCommon.pm: make read_cluster_conf_file read postgresql.auto.conf as well
    (Closes: #787154)
158
  * pg_upgradecluster: Support upgrading tablespaces. (Closes: #772202)
159
  * t/TestLib.pm: New function program_ok().
160 161
  * t/040_upgrade.t: Skip testing pg_upgrade with datallowconn = f, it does
    not support that anymore as of May 2015.
162
  * t/170_extensions.t: Catch warning with chkpass >= 9.5.
163 164
  * debian/maintscripts-functions: Unset all locale-specific environment
    variables when creating the initial database cluster. (Closes: #791526)
165
  * Add /var/log/postgresql to /usr/lib/tmpfiles.d/postgresql.conf.
166
  * Also set OOMScoreAdjust in postgresql@.service.
167
  * pg_ctlcluster: OOM-protect 9.0 as well.
168
  * pg_lsclusters: Color online/down clusters green/red.
169
  * supported-versions: Accept DEB_PG_SUPPORTED_VERSIONS as well.
170
  * Ship /etc/postgresql/ in postgresql-common. (Closes: #801140)
171

172 173 174 175
  [ Martin Pitt ]
  * pg_createcluster: Show the locale selected with --locale instead of the
    current one. (LP: #1467061)

176
 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 08 Oct 2015 13:48:26 +0200
177

178
postgresql-common (169) unstable; urgency=medium
179 180 181

  * t/022_recovery.t: New recovery tests to catch regression in 9.4.2 and
    9.1.16.
182 183
  * pg_upgradecluster: Set default dynamic_shared_memory_type = mmap.
    (Closes: #784005)
184
  * pg_upgradecluster: Complain if --link is used without --method=upgrade.
185 186
  * pg_upgradecluster: Better error message when old and new version are
    equal.
187

188
 -- Christoph Berg <myon@debian.org>  Thu, 04 Jun 2015 12:09:53 +0200
189

190
postgresql-common (168) unstable; urgency=medium
191

192
  [ Martin Pitt ]
193
  * Drop obsolete debian/backport-ppa script.
194 195
  * debian/tests/default-psql: Skip test if default cluster creation is
    disabled in createcluster.conf.
196

197 198 199 200
  [ Christoph Berg ]
  * t/170_extensions.t: Refactor dependency handling and add new extensions
    shipped with 9.5.

201
 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 21 May 2015 11:28:45 +0200
202

203
postgresql-common (167) unstable; urgency=medium
204

205
  [ Christoph Berg ]
206
  * pg_conftool: Fix 'remove' operation. Spotted by François Henry, merci!
207
    (Closes: #778243)
208
  * t/007_pg_conftool.t: Add pg_conftool tests.
209

210 211 212 213 214 215
  [ Martin Pitt ]
  * debian/maintscripts-functions: Avoid package installation failure of -9.1
    due to the pg_basebackup.1 alternative on systems which have both -9.1 and
    a later version installed in parallel. On those, pg_basebackup.1 will
    already be in the psql.1.gz group, thus -9.1 must not try to put it back
    into the postmaster.1.gz group. (LP: #1357682)
216 217
  * Add "default-psql" autopkgtest: Smoketest to verify that installing the
    "postgresql" metapackage results in a running and working cluster.
218 219 220
  * debian/maintscripts-functions, configure_cluster(): When running under
    systemd, do a daemon-reload to re-run the generator and thus create a unit
    for the newly created cluster.
221
  * Move package maintenance to git, update Vcs-* tags accordingly.
222
  * Bump Standards-Version to 3.9.6 (no changes necessary).
223
  * supported-versions: Add Ubuntu 15.10.
224

225
 -- Martin Pitt <mpitt@debian.org>  Wed, 06 May 2015 11:28:26 +0200
226

227
postgresql-common (166) unstable; urgency=medium
228

229 230 231
  * postgresql-common: Breaks: systemd (<< 204). postgresql@.service uses
    reload-related config options that are incompatible with the systemd
    version in wheezy. (Consider upgrading to the wheezy-backports version.)
232
  * pg_renamecluster: New tool to rename clusters.
233
  * pg_upgradecluster: --rename allows renaming the upgraded cluster.
234
  * pg_conftool: Allow to "edit" files.
235 236 237 238
  * PgCommon.pm, pg_lsclusters: Fix thinko which broke logging to
    /var/log/postgresql when log_destination was "syslog,stderr". The default
    logfile is now always used even if logging_collector is enabled; it
    receives the log messages produced before logging_collector is started.
239
  * t/020_create_sql_remove.t: Versions >= 9.0 are OOM-protected.
240

241
 -- Christoph Berg <myon@debian.org>  Thu, 05 Feb 2015 22:19:07 +0100
242

243
postgresql-common (165) unstable; urgency=medium
244 245 246 247

  * Debconf translation updates, thanks!
    + es by Manuel Venturi Porras Peralta. (Closes: #773598)

248
 -- Christoph Berg <myon@debian.org>  Sun, 04 Jan 2015 18:51:31 +0100
249

250
postgresql-common (164) unstable; urgency=medium
251

252 253
  * Init script: Always create /var/run/postgresql on start.
    (Closes: #772824)
254 255
  * Debconf translation updates, thanks!
    + pt by Ricardo Silva. (Closes: #767399)
256 257
  * t/100_upgrade_scripts.t: Incompatible with eatmydata, remove from
    LD_PRELOAD when detected.
258
  * t/170_extensions.t: Catch warning with chkpass on 9.5.
259 260
  * debian/supported-versions: Support jessie in backports and
    apt.postgresql.org, with 9.4 as default.
261
  * pgdg/apt.postgresql.org.sh: Support jessie.
262

263
 -- Christoph Berg <myon@debian.org>  Wed, 17 Dec 2014 20:00:04 +0100
264

265
postgresql-common (163) unstable; urgency=medium
266

Christoph Berg's avatar
Christoph Berg committed
267 268
  [ Martin Pitt ]
  * pg_createcluster: Disable copy-on-write semantics for data directory on
269 270
    btrfs and similar file systems. It eats a lot of performance and isn't
    necessary for data integrity.
271
  * debian/supported-versions: Welcome Ubuntu 15.04!
272

Christoph Berg's avatar
Christoph Berg committed
273 274 275
  [ Christoph Berg ]
  * Update VCS URLs.

276
 -- Martin Pitt <mpitt@debian.org>  Sun, 26 Oct 2014 07:04:48 -0400
277

278
postgresql-common (162) unstable; urgency=medium
279

280
  [ Christoph Berg ]
281
  * Move PgCommon.pm to /usr/share/perl5.
282 283
  * t/020_create_sql_remove.t: Test psql -tx alignment to catch a bug in
    9.4beta2.
284
  * supported-versions: Set 9.4 as pgdg default on Ubuntu 14.10.
285 286
  * Debconf translation updates, thanks!
    + nl by Frans Spiesschaert. (Closes: #762632)
287

288 289 290 291
  [ Peter Michael Green ]
  * Use ID_LIKE to identify deriviatives of Debian and Ubuntu.
    (Closes: #761020)

292 293 294 295
  [ Richard Hughes ]
  * Use Type=forking in postgresql@.service and start before postgresql.
    (Closes: #759725)

296
 -- Christoph Berg <myon@debian.org>  Tue, 07 Oct 2014 21:25:25 +0200
297

298
postgresql-common (161) unstable; urgency=medium
299

300 301
  * pg_ctlcluster: Refuse root operation when config owner does not match
    data owner, and config owner is not root.
302 303 304 305 306 307
  * Stop automatically updating debian/control from debian/control.in in
    pgxs_debian_control.mk. Instead, implement "checkcontrol" and
    "updatecontrol" actions in pg_buildext. checkcontrol is run from
    pgxs_debian_control.mk and will warn if an update is required.
    Backport and pgdg builds will still automatically update.
    (Closes: #758570)
308 309
  * pg_virtualenv, testsuite: Use "ip" to start lo when available.
  * Add iproute2 | net-tools to postgresql-server-dev-all dependencies.
310 311
  * Debconf translation updates, thanks!
    + it by Luca Monducci. (Closes: #759808)
312 313 314

 -- Christoph Berg <myon@debian.org>  Fri, 15 Aug 2014 10:13:51 +0200

315
postgresql-common (160) unstable; urgency=medium
316

317
  [ Martin Pitt ]
318
  * supported-versions: Set 9.4 as default for Ubuntu 14.10.
319 320
  * debian/maintscripts-functions: Call update-alternatives under C locale to
    fix parsing for non-English locales. (LP: #1293596)
321 322
  * pg_createcluster: Fix test if specified owner/group ID is numeric. Thanks
    Sven Berkvens-Matthijsse! (LP: #1329227)
323

324
  [ Christoph Berg ]
325
  * Use dh-systemd to enable postgresql.service on install. (Closes: #757612)
326 327 328
  * Set Multi-Arch: foreign in postgresql-common, postgresql-client-common,
    postgresql-client, and postgresql-doc, and document this in
    doc/dependencies.{dia,png}. (Closes: #757520)
329
  * Update examples in README.Debian for 9.4. (Closes: #756007)
Christoph Berg's avatar
Christoph Berg committed
330
  * Install README.systemd.
331

332
 -- Christoph Berg <christoph.berg@credativ.de>  Mon, 11 Aug 2014 15:39:39 +0200
333

334
postgresql-common (159) unstable; urgency=low
335

336
  * supported-versions: Set 9.4 as default for jessie and unstable.
337
  * systemd unit files are now installed to their proper locations.
338
  * Install /usr/lib/tmpfiles.d/postgresql.conf.
339 340 341
  * pgcommon.sh: New shell function module containing get_release and
    locale_gen. Used by supported-versions and testsuite; also usable by other
    packages.
342
  * pg_ctlcluster, PgCommon.pm: Fix warning on corrupt empty pid files.
343 344
  * pg_ctlcluster: New --stdlog option to be used with --foreground that
    redirects stderr to our standard log files. Used in postgresql@.service.
345
  * pg_ctlcluster: Ignore errors when stat'ing the logfile.
346
  * pg_ctlcluster: use strict.
347 348 349
  * Debconf translation updates, thanks!
    + da by Joe Dalton. (Closes: #753952)

350
 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 24 Jul 2014 11:52:57 +0200
351

352
postgresql-common (158) experimental; urgency=medium
353

354
  * supported-versions: Add 9.4 on Debian/unstable and pgapt (9.3 is still
355
    default).
356
  * Set default log_line_prefix = '%t [%p-%l] %q%u@%d '.
357 358
  * Put stats_temp_directory aka pg_stat_tmp into /var/run/postgresql by
    default. (Closes: #739276)
359 360
  * pg_lsclusters: Print logfile from postgresql.conf when logging_collector
    in use instead of "custom".
361 362
  * Move pg_{create,ctl,upgrade,drop}cluster.8 to section 1, they are in
    /usr/bin anyway.
363 364
  * maintscripts-functions: Configure manpage alternatives in -doc packages
    using SPI_connect.3.gz as master.
365 366
  * pg_upgradecluster: Deprecate krb_srvname in 9.4. Failing upgrade hook
    scripts will fail the upgrade.
367
  * pg_ctlcluster: Configure OOM killer using PG_OOM_ADJUST_FILE in 9.5.
368
  * pg_wrapper: Also accept --cluster=ver/name in a single argument.
369 370
  * testsuite: Also mount /dev/shm; with -s, open shell on failure; -f nnn
    starts tests at this sequence number.
371 372
  * run-upgrade-scripts, t/100_upgrade_scripts.t: Fork and set uid for running
    the upgrade scripts; use su -c for testing.
373 374
  * Start porting the postgresql-common framework to RedHat, backed by the
    PGDG PostgreSQL rpm packages.
375 376
  * Debconf translation updates, thanks!
    + fr by Julien Patriarca. (Closes: #751101)
377
    + ja by victory. (Closes: #751131)
378
  * debian/copyright: Update copyright holders.
379

380
 -- Christoph Berg <myon@debian.org>  Sat, 05 Jul 2014 16:40:16 +0200
381

382
postgresql-common (157) unstable; urgency=medium
383 384

  * Remove createcluster.conf on purge.
385 386
  * Fix testsuite -i to install packages before invoking unshare so apt still
    has network access.
387

388
 -- Christoph Berg <myon@debian.org>  Fri, 30 May 2014 21:31:36 +0200
389

Christoph Berg's avatar
Christoph Berg committed
390
postgresql-common (156) unstable; urgency=medium
391

392
  [ Christoph Berg ]
393 394
  * pg_upgradecluster: Add missing psql -p argument when determining the
    number of tablespaces in the old cluster.
395
  * Link pg_archivecleanup from /usr/bin. (Closes: #740593)
396
  * pg_virtualenv: Use fsync = off for speed.
397
  * pg_buildext: Pass -cios options to pg_virtualenv.
398
  * t/140_pg_config.t: Versions >= 9.3 have multiarch-enabled libpq et al.
Christoph Berg's avatar
Christoph Berg committed
399
  * Bump to dh 9.
400

401 402 403
  [ Martin Pitt ]
  * Fix typo in German debconf translations. Thanks Rhonda for pointing out!

Christoph Berg's avatar
Christoph Berg committed
404
 -- Christoph Berg <myon@debian.org>  Fri, 30 May 2014 00:00:44 +0200
405

406
postgresql-common (155) unstable; urgency=medium
407

408
  [ Christoph Berg ]
409 410 411
  * postgresql-common: Maintain createcluster.conf using ucf, and add a
    debconf question about the default use of ssl (default true, priority
    medium). (Closes: #743918)
412 413
  * Use "mount --make-rprivate /" inside our "unshare -m" calls.
    (See #739593.)
414 415
  * pg_ctlcluster: Add status action, add --foreground option, accept dash
    (and slash) between version and cluster.
416
  * Add systemd unit files as examples (testers welcome!).
417
  * postgresql-client: Wrap pg_recvlogical, introduced in 9.4.
418
  * t/050_encodings.t: 9.4 emits COPY command tags, suppress with psql -q.
419
  * postgresql: Add Suggests: postgresql-doc. (Closes: #743755)
420 421
  * pg_conftool: New script to read and edit PostgreSQL configuration files,
    based on the existing read/edit functions in PgCommon.pm.
422 423
  * pg_upgradecluster: Don't abort the upgrade if the config file symlinks are
    already there.
424
  * testsuite: Fix testsuite where -v does not include the latest version.
425
  * testsuite -v -i will install packages needed for these versions.
426

427 428 429
  [ Martin Pitt ]
  * supported-versions: Welcome, Ubuntu 14.10!

430
 -- Christoph Berg <christoph.berg@credativ.de>  Wed, 21 May 2014 17:34:09 +0200
431

432
postgresql-common (154) unstable; urgency=medium
433

434
  [ Martin Pitt ]
435
  * debian/postgresql-common.preinst: Drop obsolete upgrade migration.
436 437 438 439
  * debian/maintscripts-functions, _link_manpages(): The move of pg_basebackup
    from server to client still affects upgrades from -9.1 to -9.3. Place the
    upgrade fix here instead of postgresql-9.1.preinst (which does not exist
    any more now). (LP: #1270597)
440
  * Update Vcs-Bzr:, bzr.d.o. does not work any more.
441

442 443
  [ Christoph Berg ]
  * t/031_errors_disk_full.t: Drop cluster after tests.
444
  * testsuite: Always umount the tmpfs overlays.
445

446
 -- Christoph Berg <myon@debian.org>  Fri, 21 Feb 2014 08:18:46 +0100
447

448
postgresql-common (153) unstable; urgency=medium
449

450
  [ Christoph Berg ]
451 452 453 454 455
  * Replace the static logrotate configuration by generating the file
    dynamically using ucf, triggered by watching /usr/sbin/logrotate.
    This eases dist-upgrades that upgrade logrotate to >= 3.8 from an older
    version (squeeze->wheezy, precise->trusty).
  * postgresql-common.postinst: Stop debconf later so ucf can use it.
456
  * postgresql-common.postinst: Call su without - to avoid a warning.
457
  * t/003_package_checks.t: Add test case for logrotate.
458 459
  * pg_createcluster, t/001_packages.t: Refactor the ssl cert test, and add
    matching testcases in the testsuite.
460
  * t/020_create_sql_remove.t: Make pipe writes unbuffered.
461
  * pg_buildext: Document the loop action (present since version 141).
462
  * pg_buildext: Add "installcheck" action for use with autopkgtest.
463 464
  * pg_buildext: Support $action-$version when the loop is contained in the
    calling script. (Mostly useful for installcheck-x.y.)
465 466 467
  * postgresql-server-dev-all: Add "make" to depends because pg_buildext is
    mostly useless without it; extensions using autopkgtest would otherwise
    need to include it in their debian/tests/control files.
468 469
  * pgxs_debian_control.mk: Add "clean: debian/control" and
    ".PHONY: debian/control".
470
  * pg_virtualenv: Fix exit code shown with -s.
471
  * pg_createcluster, pg_virtualenv: -o will set postgresql.conf parameters.
472 473
  * postgresql-common: In /usr/share/postgresql-common/pgdg/,
    install apt.postgresql.org.sh to enable activating the pgdg repository.
474

475 476 477 478
  [ Martin Pitt ]
  * testsuite, pg_virtualenv: Don't fail if ifconfig is not installed. We
    don't require it as a dependency, and this breaks e. g. autopkgtests in
    minimal environments.
479 480
  * t/150_tsearch_stemming.t: Add tests for stemming/searching with non-ASCII
    characters. (See #689997)
481 482 483
  * debian/postgresql-common.triggers: Also trigger on
    /usr/share/postgresql/, so that installation of new server versions builds
    the corresponding dictionaries.
484 485
  * init.d-functions, start(): Update SELinux label of /run/postgresql if
    restorecon is installed. Thanks Martin Lang! (Closes: #737661)
486

487
 -- Christoph Berg <christoph.berg@credativ.de>  Thu, 06 Feb 2014 15:21:00 +0100
488

489
postgresql-common (152) unstable; urgency=low
490

491
  [ Martin Pitt ]
492 493
  * debian/backport-ppa: Drop oneiric/quantal for -9.2, only keep
    lucid/precise.
494 495
  * Drop support for obsolete oom_adj, all kernels in all supported
    Debian/Ubuntu releases support oom_score_adj. (See #646245)
496
  * debian/README.Debian: Fix commands to get a postgres user shell.
497 498 499
  * Change all "su" invocations to system user to specify an explicit shell,
    to fix breakage after latest base-passwd 3.5.30 (which changed system
    users to have no shell).
500
  * Bump Standards-Version to 3.9.5 (no changes necessary).
501

502 503
  [ Christoph Berg ]
  * pg_virtualenv: Fix program name in manpage.
504 505
  * pg_createcluster: --start-conf should override the value from
    createcluster.conf.
506
  * testsuite: Also mount a tmpfs on /etc/postgresql-common.
507

508
 -- Martin Pitt <mpitt@debian.org>  Thu, 09 Jan 2014 10:56:12 +0100
509

510
postgresql-common (151) unstable; urgency=low
511

512
  * pg_createcluster: Create /var/run/postgresql when missing.
513
  * pg_virtualenv: Set PG_CONFIG in single version mode.
514 515 516 517 518
  * pg_wrapper: Always use the latest available version of "pg_isready"
    instead of the target cluster's. pg_isready appeared only in 9.3, but is
    usable with older versions as well. Suggested by Peter Eisentraut.
    (Closes: #728599)

519
 -- Christoph Berg <myon@debian.org>  Thu, 05 Dec 2013 16:32:51 +0100
520

521
postgresql-common (150) unstable; urgency=low
522

523
  [ Christoph Berg ]
524 525 526
  * Create the postgres group when missing, and add the postgres user to it.
    Could happen when the postgres user was created manually.

527 528 529
  [ Martin Pitt ]
  * debian/supported-versions: Welcome, Ubuntu 14.04! Support 9.3 there.

530
 -- Martin Pitt <mpitt@debian.org>  Mon, 21 Oct 2013 22:08:20 +0200
531

532
postgresql-common (149) unstable; urgency=low
533

534 535
  * debian/supported-versions: Set default version to 9.3. Drop 9.2 from
    wheezy-backports.
536 537
  * /etc/apt/apt.conf.d/01autoremove-postgresql: Mark ^postgresql- as
    NeverAutoRemove, so upgrading the "postgresql" meta package doesn't
538
    automatically remove access to the old clusters. (Closes: #714725)
539 540
  * pg_wrapper: Print a more informative error message when program to execute
    was not found in /usr/lib/postgresql.
541
  * debian/postgresql-client-common.links: Wrap pg_isready and pg_receivexlog.
542

543
 -- Christoph Berg <myon@debian.org>  Mon, 09 Sep 2013 14:15:18 +0200
544

545
postgresql-common (148) unstable; urgency=low
546

547
  [ Christoph Berg ]
548
  * debian/supported-versions:
549
    + Interface change: The *last* version returned here is the "default" one.
550
    + Wheezy uses "7" in /etc/os-release.
551 552 553 554 555 556 557 558
    + Add 9.3 for pgdg (default on testing/unstable).
  * debian/rules:
    + Set FLAVOR variable for the type of build we are doing. Set
      PG_SUPPORTED_VERSIONS=$FLAVOR for debian/supported-versions so we don't
      pick up configuration from the build environment.
    + Pick the default version from the last line of
      `debian/supported-versions` instead of sorting the output.
  * debian/postgresql-common.config: Sort versions to determine the latest.
559 560 561
  * pg_buildext: Support "X.Y+" and "all" in debian/pgversions so packages do
    not need to hardcode the versions they support, as that's usually not
    necessary.
562 563
  * pgxs_debian_control.mk: Drop the previously redundant grep check on
    debian/pgversions which would now break "X.Y+".
564
  * t: Move $delay to TestLib.pm and increase to 500ms.
565
  * t/005_PgCommon.t: Use twice the delay for waiting for the first nc child.
566

567 568 569
  [ Martin Pitt ]
  * debian/postgresql-common.postinst: Don't restart servers in dict update
    trigger. (Closes: #719282)
570
  * debian/README.Debian: Update examples for -9.1 and -9.3.
571

572
 -- Martin Pitt <mpitt@debian.org>  Tue, 27 Aug 2013 11:07:48 +0200
573

574 575 576 577 578 579
postgresql-common (147) unstable; urgency=low

  * Bump "really142" to "really146" to fix an error on apt.postgresql.org.

 -- Christoph Berg <myon@debian.org>  Thu, 18 Jul 2013 09:11:38 +0200

Christoph Berg's avatar
Christoph Berg committed
580
postgresql-common (146) unstable; urgency=low
581

582
  [ Christoph Berg ]
583
  * debian/supported-versions: Use "7.*" to recognize wheezy; point releases
Christoph Berg's avatar
Christoph Berg committed
584
    now increment the second version number component. (Closes: #712586)
585 586 587
  * pg_virtualenv:
    + On error, show tail of server log file.
    + When no command is given, open a shell.
588
  * pg_createcluster: Add --createclusterconf and --environment options.
589
  * pg_ctlcluster: Create stats_temp_directory when missing.
590
  * pg_ctlcluster: You must run this program as the cluster owner ... or root.
591 592
  * postgresql-common: Demote dependency on logrotate to recommends.
    (Closes: #714982).
593

594 595 596 597
  [ Peter Eisentraut ]
  * PgCommon.pm, pg_createcluster, pg_dropcluster: Don't call external
    programs with full path where not necessary.

Christoph Berg's avatar
Christoph Berg committed
598
 -- Christoph Berg <myon@debian.org>  Tue, 16 Jul 2013 16:11:35 +0200
599

Christoph Berg's avatar
Christoph Berg committed
600
postgresql-common (145) unstable; urgency=low
601

602
  [ Christoph Berg ]
603 604 605
  * pg_ctlcluster: Use "install" instead of File::Path to create
    unix_socket_directory. (Introduced in 141, Closes: #710093)

606 607 608 609 610 611
  [ Martin Pitt ]
  * debian/maintscripts-functions, configure_cluster(): Do not trust the
    locale from the environment, as programs like ssh and sudo propagate
    remote and user locale by default. Instead, only use the locale settings
    from /etc/environment and /etc/default/locale, to prevent trying to
    configure the default cluster with a nonexisting or hard to predict
612
    locale. (LP: #969462, also see Debian #700271)
613

Christoph Berg's avatar
Christoph Berg committed
614
 -- Christoph Berg <myon@debian.org>  Mon, 10 Jun 2013 17:01:01 +0200
615

Christoph Berg's avatar
Christoph Berg committed
616
postgresql-common (144) unstable; urgency=low
617 618

  * testsuite: Allow overriding the list of versions to test (-v).
619 620
  * 040_upgrade: Add a test case for #688960 ("OLD used in query that is not
    in a rule").
621 622 623 624
  * pg_upgradecluster: Add --quote-all-identifiers to the pg_dump(all)
    invocations so pg_dump-style upgrades do not fail when keywords get
    un-reserved. (Closes: #688960; the pg_upgrade part of this will be fixed
    in PostgreSQL upstream.)
625
  * pg_ctlcluster: Add --mode shutdown option.
626
  * pg_virtualenv: Allow running as non-root user.
627

Christoph Berg's avatar
Christoph Berg committed
628
 -- Christoph Berg <myon@debian.org>  Fri, 31 May 2013 21:37:47 -0700
629

Martin Pitt's avatar
Martin Pitt committed
630
postgresql-common (143) unstable; urgency=low
631 632 633

  * debian/supported-versions: Don't explicitly support 9.3 for
    testing/unstable yet, it is still in experimental. (Closes: #707675)
634 635 636
  * debian/rules: Hack the version number of the metapackages to be
    9.3+142really9.1-..., so that they are bigger than the previous botched
    versions. This needs to stay until 9.3 actually goes into unstable.
637

Martin Pitt's avatar
Martin Pitt committed
638
 -- Martin Pitt <mpitt@debian.org>  Fri, 10 May 2013 17:53:49 +0200
639

Martin Pitt's avatar
Martin Pitt committed
640
postgresql-common (142) unstable; urgency=low
641

642
  [ Christoph Berg ]
643 644
  * Make all scripts honor PGSYSCONFDIR (defaulting to
    /etc/postgresql-common).
645
  * The default behavior of pg_createcluster can be configured in
646
    /etc/postgresql-common/createcluster.conf. This also allows to disable the
647 648
    creation of "main" clusters when postgresql server packages are installed,
    and to set parameters in the new postgresql.conf.
649
  * pg_createcluster: Move setting of log_line_prefix to createcluster.conf.
650 651
  * debian/postgresql-common.postgresql.init: Do not die of one cluster fails
    to start. (Closes: #699911)
652 653
  * pg_checksystem: Suppress error message for unavailable filesystems.
    (Closes: #705219)
654 655 656
  * pg_upgradecluster: Use a distinct name (pg_hba.conf.pg_upgradecluster) for
    the pg_hba.conf backup, and handle the case where this file already exists
    gracefully.
657 658
  * pg_upgradecluster: On upgrades to 9.3, rename unix_socket_directory to
    unix_socket_directories.
659 660
  * pg_upgradecluster, t/043_upgrade_ssl_cert.t: Copy server.crt and friends
    in the data directory on upgrade. (Closes: #698958)
661 662 663
  * pg_ctlcluster: Set LANG so non-ascii chars in the server log are not
    replaced by '?'. Thanks to Adrian Vondendriesch for help debugging this.
    (Closes: #671915)
664

665 666
  [ Martin Pitt ]
  * debian/supported-versions: Add 9.3 for testing/unstable.
667
  * debian/supported-versions: Add Ubuntu 13.10.
668
  * Bump Standards-Versio to 3.9.4 (no changes necessary).
669 670
  * pg_upgradecluster: For upgrades to 9.3, migrate "replication_timeout" to
    "wal_sender_timeout".
671 672
  * t/060_obsolete_confparams.t: Add full 9.2 configuration, to test 9.2  9.3
    upgrades.
673

Martin Pitt's avatar
Martin Pitt committed
674
 -- Martin Pitt <mpitt@debian.org>  Tue, 07 May 2013 11:11:58 +0200
675

Christoph Berg's avatar
Christoph Berg committed
676
postgresql-common (141) experimental; urgency=low
677

678
  [ Christoph Berg ]
679 680
  * debian/maintscripts-functions: Fix configure_client_version to call
    _link_manpages correctly, spotted by Kris Shannon. (Closes: #701602)
681 682
  * debian/postgresql-common.sysctl: Note that the file is Linux-specifc and
    do some rewording of the comments.
683 684 685 686
  * debian/supported-versions:
    + Deprecate 8.3 for pgdg builds.
    + Handle missing os-release and lsb_release gracefully, just print a
      warning. (Affects squeeze systems, Introduced by the fix for #697182).
687 688
  * pg_buildext: Deprecate <srcdir> parameter. The docs do not mention it
    anymore, but the script will still accept it.
689 690 691
  * pg_createcluster, pg_upgradecluster: For 9.2 and higher, use the new
    ssl_ca_file option instead of creating a root.crt symlink in the data
    directory. (Related to the fix for #680162 below.)
692 693
  * pg_createcluster: If /etc/postgresql-common/root.crl is present, symlink
    it (<= 9.1), or set ssl_crl_file (>= 9.2).
694
  * pg_ctlcluster: Create (first) unix_socket_directory if missing.
695
  * pg_ctlcluster: Document start.conf by pointing at pg_createcluster(8).
696 697
  * pg_lsclusters: Make output column widths dynamically adjust to contents;
    shorten "Version" in header to "Ver".
698
  * pg_upgradecluster: Get cluster encoding before shutting down the cluster
699 700
    so we don't need to restart it in pg_upgrade mode; temporarily start the
    cluster if needed.
701 702
  * postgresql-client-common: For apt.postgresql.org builds (with "pgdg" in
    the version number), depend on pgdg-keyring.
703
  * Add a "apt.postgresql.org.sh" script to add that archive to sources.list.
704

705 706 707
  [ Martin Pitt ]
  * debian/backport-ppa: Stop building raring packages. The PPA is declared
    deprecated now, moving to apt.postgresql.org.
708 709
  * pg_createcluster: Drop "Moving configuration file.." message as it's not
    all that interesting and we are going to add more status output.
710 711 712
  * pg_createcluster: Print configuration and data directory on separate
    lines, and also show the current locale that the cluster will use.
    (Closes: #700271)
713 714 715
  * pg_updatedicts: Cleanup tsearch data files which do not have a
    corresponding hunspell or myspell dictionary installed any more.
    (Closes: #689996)
716
  * Adjust upgrade tests according to the changed pg_lscluster formatting.
717

718 719 720 721 722 723
  [ Peter Eisentraut ]
  * Add support for pg_upgrade: (Closes: #682938)
    - pg_upgradecluster: Add options to select pg_upgrade instead of
      dump/restore, and call pg_upgrade when selected.
    - t/040_upgrade.t: Test all upgrade methods.

Christoph Berg's avatar
Christoph Berg committed
724
 -- Christoph Berg <myon@debian.org>  Wed, 10 Apr 2013 16:25:06 +0200
725

Christoph Berg's avatar
Christoph Berg committed
726
postgresql-common (140) experimental; urgency=low
727

728
  [ Martin Pitt ]
729
  * t/001_packages.t: Also check that -contrib is installed.
730
  * debian/backport-ppa: Backport -common for Ubuntu 12.10.
731
  * PgCommon.pm: Recognize "include_if_exists" directive. (LP: #1098986)
732 733
  * pg_ctlcluster: Recreate a missing /var/log/postgresql/ if needed.
    (LP: #1009989)
734 735
  * debian/postgresql-client-common.links: Wrap pgbench with pg_wrapper.
    (LP: #1068194)
736

737 738 739
  [ Christoph Berg ]
  * testsuite: The default list of umasks to test (022 077) can be overridden
    by setting the environment variable PG_UMASKS.
740
  * t/003_package_checks.t: Ensure psql is linked against libedit.
741
  * t/005_PgCommon.t: Increase sleep time after netcat launch to 200ms.
742
  * t/020_create_sql_remove.t: Test process title update.
743 744 745
  * pg_createcluster: Allow passing of initdb arguments on the command line.
    If --auth parameters are passed, skip updating the generated pg_hba.conf
    file.
746
  * pg_virtualenv: Allow passing initdb arguments to pg_createcluster.
747 748
  * pg_upgradecluster: Print a helpful message when invoked on the target
    version. Problem seen on #postgresql.
749
  * t/030_errors.t: Adjust testsuite for this.
750 751
  * debian/supported-versions: Handle unset variables from /etc/os-release
    gracefully. Spotted by x4rlos on #postgresql.
752
  * pg_buildext: Set USE_PGXS=1, and srcdir (needed by plr).
753

Christoph Berg's avatar
Christoph Berg committed
754
 -- Christoph Berg <myon@debian.org>  Thu, 31 Jan 2013 10:36:41 +0100
755

Christoph Berg's avatar
Christoph Berg committed
756
postgresql-common (139) experimental; urgency=low
757

758
  [ Christoph Berg ]
759 760
  * pg_virtualenv: New program to create throw-away clusters for running
    regression tests.
761
  * testsuite: unshare needs "--" or else it eats our options.
762
  * testsuite: Require netcat-openbsd to be installed.
763 764
  * testsuite: Move locale generation here from debian/tests/system, also
    generate en_US.utf8 locale; unset LC_ALL.
765
  * Drop debian/tests, moved to the postgresql-* server packages.
766 767
  * testsute 005_PgCommon: Do the ipv4 tests before the ipv6 ones; skip
    the ipv6 for perl <= 5.10 (i.e. on squeeze and lucid).
768
  * PgCommon.pm, pg_ctlcluster, pg_createcluster, t/030_errors.t: 9.3 renames
769
    unix_socket_directory to unix_socket_directories.
770
  * pg_wrapper: Document that PGHOST overrides PGCLUSTER. (Closes: #697291)
771 772
  * pg_wrapper: Skip cluster selection if --host is given on the command line.
    (Closes: #637017) While we are at it, improve --port parsing, too.
773 774
  * t/010_defaultport_cluster.t: Add test cases for the above pg_wrapper
    changes.
775 776
  * t/040_upgrade.t: dup2 psql stderr to suppress warning 'could not change
    directory to "/tmp/pgtest'.
777
  * postgresql-client-common: Add Depends: netbase for getprotobyname() in
778
    PgCommon.pm. (Closes: #697377)
779

780 781 782 783 784
  [ Martin Pitt ]
  * debian/supported-versions: Read /etc/os-release if present, and fall back
    to lsb-release. Exit with a proper error message if neither is present.
    This gets rid of the (currently undeclared) strict dependency on
    lsb-release. (Closes: #697182)
785 786
  * debian/README.Debian: Update versions to 8.4/9.1, as current for Squeeze
    and Wheezy. (Closes: #697239)
787

Christoph Berg's avatar
Christoph Berg committed
788
 -- Christoph Berg <myon@debian.org>  Sun, 06 Jan 2013 10:24:49 +0100
789

Martin Pitt's avatar
Martin Pitt committed
790
postgresql-common (138) experimental; urgency=low
791

792
  [ Christoph Berg ]
793 794
  * testsuite: start localhost interface which is down after unshare -n.

795 796 797
  [ Martin Pitt ]
  * testsuite: Stop currently running clusters, just as the script has done
    until 136.
798
  * testsuite: Use a more elegant way of re-execing ourselves through unshare.
799

Martin Pitt's avatar
Martin Pitt committed
800
 -- Martin Pitt <mpitt@debian.org>  Sun, 16 Dec 2012 18:57:12 +0100
801

Martin Pitt's avatar
Martin Pitt committed
802
postgresql-common (137) experimental; urgency=low
803

804
  [ Martin Pitt ]
805
  * debian/backport-ppa: Disable xz compression for lucid.
806 807
  * debian/backport-ppa: Disable libraries for -9.1/natty as well, built by
    9.2 now.
808 809
  * debian/backport-ppa: Ensure that backport PPA versions are always smaller
    than the versions in -updates.
810 811 812 813 814
  * pg_wrapper: Always use the latest available client version of "psql"
    instead of the target cluster's. psql is backwards compatible to all major
    versions that we support in any release. Update tests to use "createdb"
    instead of "psql" for --version tests, and add a new test for the psql
    special case to t/020_create_sql_remove.t. (Closes: #639108)
815 816 817
  * debian/postgresql-common.triggers: Also watch for changes in
    /usr/share/hunspell/; pg_updatedicts handles these as well.
    (Closes: #689994)
818 819
  * debian/tests/control: Add netcat-openbsd test dependency for the
    next_free_port() tests added below.
820
  * debian/backport-ppa: Drop natty (EOL), add raring for 9.2.
821
  * debian/supported-versions: Add Ubuntu 13.04.
822 823 824 825
  * testsuite: Run with overlaid tmpfses on the postgresql /etc/ and /var
    directories in an unshared namespace. This is more robust against
    protecting existing clusters, always cleans up after itself properly, and
    also speeds up testing.
826 827
  * t/031_errors_disk_full.t: Drop check for existence of unshare, as
    ./testsuite now unconditionally requires it.
828 829 830
  * debian/postgresql-common.postinst: Only chown /var/lib/postgresql if it
    does not already have the correct ownership. This avoids failures when the
    directory is NFS mounted. Thanks Hugh Davenport! (Closes: #693958)
831

832 833
  [ Christoph Berg ]
  * testsuite: Move 'disk full' tests from 030_errors to new file
Martin Pitt's avatar
Martin Pitt committed
834
    031_errors_disk_full.
835 836
  * testsuite: Note that Test::More 0.87 is required for done_testing() in
    170_extensions.
837
  * testsuite 005_PgCommon: Add next_free_port tests (using /bin/nc).
838 839 840 841 842
  * supported-versions: Make output configurable via $PG_SUPPORTED_VERSIONS,
    ~/.pg_supported_versions, and /etc/postgresql-common/supported_versions.
    (Closes: #646700)
  * supported-versions: Add debian-backports and pgdg sections.
    (Closes: #650680)
843 844
  * For bpo and pgdg builds (determined by the version number), create
    /etc/postgresql-common/supported_versions with appropriate content.
845 846 847
  * Replace version string comparisions in perl scripts to use numerical
    operators, so things will continue to work when PostgreSQL 10.0 is
    released.
848
  * debian/rules: Use sort -n for sorting supported-versions output.
849 850
  * debian/rules: Use apt-cache policy instead of apt-cache show to determine
    the "candidate" logrotate version.
851
  * testsuite 020_create_sql_remove: Fix plperl test to work with 8.2.
852
  * testsuite 085_pg_ctl.conf: Skip for 8.2.
853

Martin Pitt's avatar
Martin Pitt committed
854
 -- Martin Pitt <mpitt@debian.org>  Sat, 15 Dec 2012 21:32:30 +0100
855

Martin Pitt's avatar
Martin Pitt committed
856
postgresql-common (136) experimental; urgency=low
857

858
  [ Martin Pitt ]
859 860 861
  * debian/backport-ppa: Do first upload with orig tarball, subsequent ones
    without.
  * debian/backport-ppa: Do not run lintian.
862 863
  * debian/backport-ppa: When building postgresql-9.1 for lucid, drop the
    library packages as they collide with the ones built from postgresql-9.2.
864
  * debian/backport-ppa: Build 9.2 for Quantal and Natty.
865
  * debian/supported-versions: Add Ubuntu 12.10.
866 867 868
  * t/030_errors.t: For the "fails on insufficient disk space test", move from
    setting up a loop device to a tmpfs in unshare -m. This is more robust for
    cleaning up after itself, and faster as well.
869 870
  * pg_ctlcluster: Fix log output to stderr if the log file started out being
    empty. Add test case to t/030_errors.t.
871 872
  * debian/maintscripts-functions: Only try to remove the tsearch_data
    directory  if it already exists. Thanks Peter Palfrader. (Closes: #688105)
873

874 875 876
  [ Christoph Berg ]
  * pg_buildext: Fix supported-versions not to die when the last version is
    not supported.