Change log for postgresql-common package in Debian

postgresql-common (260) unstable; urgency=medium

  * t/020_create_sql_remove.t: Skip plpython3 tests on 9.x and Python 3.12+.

 -- Christoph Berg <email address hidden>  Thu, 09 May 2024 17:10:04 +0200

Available diffs

• diff from 257build1 (in Ubuntu) to 260 (7.3 KiB)
• diff from 259 to 260 (2.2 KiB)

postgresql-common (259) unstable; urgency=medium

  * pg_backupcluster, pg_restorecluster: Let `pg_restore --create` handle
    database creation and restore of database options and grants.
    (Removes databases.sql from dumps.)
  * PgCommon.pm get_db_encoding: Refactor for dropped daticulocale in 17.
  * pg_buildext: Pass PG_VIRTUALENV_ARGS to pg_virtualenv.

 -- Christoph Berg <email address hidden>  Mon, 15 Apr 2024 14:09:12 +0200

postgresql-common (258) unstable; urgency=medium

  * server/postgresql.mk: Add Build-Profile pkg.postgresql.nollvm to disable
    JIT.

 -- Christoph Berg <email address hidden>  Mon, 18 Mar 2024 17:10:46 +0100

postgresql-common (225+deb11u1) bullseye; urgency=medium

  * t/085_pg_ctl.conf.t: sudo and salsa-ci set the core file size hard limit
    to 0 by default, undo that. (Salsa: postgresql/postgresql#2)
  * testsuite: Run all tests even when one is failing.

 -- Christoph Berg <email address hidden>  Mon, 02 Oct 2023 10:20:47 +0200

postgresql-common (257) unstable; urgency=medium

  * Move systemd unit files to /usr on releases that support it.
  * debian/maintscripts-functions: More carefully build update-alternatives
    command line. Hopefully fixes "link and path can't be the same" errors.
  * debian/maintscripts-functions: Remove empty /usr/share/man/ directories.
  * pg_backupcluster: Add hostname, machine-id, and machine-deployment (from
    /etc/machine-info) to backup status; use machine-readable timestamps for
    starttime/endtime; sort keys.
  * pg_upgradecluster: Skip upgrade scripts when --no-start is given.
  * pg_upgradecluster: Pass --jobs to analyze script. (Closes: #1054179)
  * debian/po/sv.po: Updated Swedish translation by Martin Bagge and Anders
    Jonsson, thanks! (Closes: #1059169)

 -- Christoph Berg <email address hidden>  Thu, 08 Feb 2024 13:32:31 +0100

Available diffs

• diff from 256 to 257 (13.2 KiB)

postgresql-common (256) unstable; urgency=medium

  * pg_upgradecluster: Remove old_snapshot_threshold in PG17.
  * Install pg_bsd_indent and pgindent into server-dev in PG17.
  * pg_buildext: words containing PGVERSIONS are replaced by a list of
    words with versions filled in. Most useful in Build-Depends.
  * pg_buildext: Add actions run and run_installed.
  * server/postgresql.mk: Grab LLVM version from B-D instead of autodetecting.

 -- Christoph Berg <email address hidden>  Wed, 08 Nov 2023 16:25:17 +0100

Available diffs

• diff from 253 to 256 (12.0 KiB)
• diff from 255 to 256 (4.4 KiB)

postgresql-common (255) unstable; urgency=medium

  * PgCommon.pm: Set defined path in prepare_exec. Thanks Niko Tyni!
  * debian/supported-versions: Add 16 as default version.

 -- Christoph Berg <email address hidden>  Thu, 14 Sep 2023 10:35:53 +0200

Available diffs

• diff from 254 to 255 (1.6 KiB)

postgresql-common (254) unstable; urgency=medium

  * /etc/postgresql-common/pg_upgradecluster.d/analyze: Automatically analyze
    databases after upgrade.
  * pg_upgradecluster: drop hard-coded analyze used in dump mode only.
  * server: Ignore test results on ia64 and sh4.
  * pg_upgradecluster: Honor --keep-on-error not just for failing upgrade
    scripts; properly start old cluster again after errors. On PG15+, move
    pg_upgrade output from pg_upgrade_output.d to /var/log/postgresql/.
    Remove force_parallel_mode in PG16+.
  * Thanks to Dagfinn Ilmari Mannsåker for helping with the patches!
  * Remove /usr/share/postgresql-common/upgrade-scripts, upgrade scripts for
    postgresql-common itself. I believe this functionality was never used.
  * pgdg/apt.postgresql.org.sh: Set umask 022.

 -- Christoph Berg <email address hidden>  Thu, 07 Sep 2023 11:12:30 +0200

postgresql-common (253) unstable; urgency=medium

  * pg_upgradecluster: Remove db_user_namespace in PG17.
  * t/045_backup.t: Relax analyze_count check that's flaky on s390x.
  * pgdg/apt.postgresql.org.sh: Allow multiple versions in -v.

 -- Christoph Berg <email address hidden>  Wed, 09 Aug 2023 11:51:21 +0200

Available diffs

• diff from 248 to 253 (15.2 KiB)

postgresql-common (252) unstable; urgency=medium

  * pg_upgradecluster: Add --keep-on-error option.
  * PgCommon get_db_locales: PG16 removes lc_ctype and lc_collate GUCs, query
    pg_database instead.
  * t/050_encodings.t: Revert back to old LC_ALL=C behavior.

 -- Christoph Berg <email address hidden>  Sat, 01 Jul 2023 20:45:40 +0200

postgresql-common (251) unstable; urgency=medium

  * Refresh pgdg/apt.postgresql.org.sh.

 -- Christoph Berg <email address hidden>  Fri, 30 Jun 2023 12:42:37 +0200

postgresql-common (250) experimental; urgency=medium

  * server/postgresql.mk: Fix ignoring test failures on alpha; ignore test
    results on hppa and sparc64.
  * pg_upgradecluster: Remove vacuum_defer_cleanup_age in PG16.

 -- Christoph Berg <email address hidden>  Wed, 24 May 2023 10:41:06 +0200

postgresql-common (249) experimental; urgency=medium

  * Merge postmaster.1.gz alternatives into psql.1.gz link group.
  * Test-Depend on postgresql-doc to test the man3 alternatives.
  * Depend on sysvinit-utils alternatively to obsolete lsb-base.
  * server/postgresql.mk: Allow setting MAJOR_PKG for custom server packages.
  * server/catversion: Also extract catalog file version number.
  * debian/maintscripts-functions: Support flavored server packages.
  * testsuite: Support flavored server packages (testsuite -F ee).
  * pg_upgradecluster: Copy encryption_key_command from old cluster to support
    PostgreSQL TDE.
  * pg_backupcluster, t/045_backup.t: Handle icu-encoded clusters and
    databases.
  * pg_backupcluster: Support passing --checkpoint=fast to pg_basebackup.
  * pg_restorecluster: Pass extra pg_createcluster arguments after --.
  * t/050_encodings.t: Accept en_US_POSIX-encoded cluster with LANG=C on PG16.
  * pg_upgradecluster, t/052_upgrade_encodings.t: Preserve ICU locale when
    upgrading from PG15+.
  * debian/tests/default-psql: Mark as skippable and honor createcluster.d.

 -- Christoph Berg <email address hidden>  Wed, 10 May 2023 21:11:56 +0200

postgresql-common (248) unstable; urgency=medium

  [ Christoph Berg ]
  * Update ro debconf translation, mulțumesc Remus-Gabriel Chelu!

  [ Athos Ribeiro ]
  * Fix set_conffile_value comment parsing regular expression.

 -- Christoph Berg <email address hidden>  Tue, 14 Mar 2023 15:19:01 +0100

Available diffs

• diff from 247 to 248 (3.9 KiB)
• diff from 247ubuntu1 (in Ubuntu) to 248 (3.5 KiB)

postgresql-common (247) unstable; urgency=medium

  [ Christoph Berg ]
  * Update pt_BR debconf translation, thanks Paulo Henrique de Lima Santana!
    (Closes: #1024197)
  * postgresql.mk: Ignore test failures on alpha.
  * pgdg/apt.postgresql.org.sh: Fix version comparisons for 9.x.
  * pg_upgradecluster: Remove promote_trigger_file in PG16.
  * t/200_maintscripts.t: Run apt-get update before reinstalling pg-common.

  [ Dennis Schwan ]
  * Fix pgsql-XX isn't numeric in numeric comparison. (Salsa #31)

 -- Christoph Berg <email address hidden>  Thu, 09 Feb 2023 11:28:43 +0100

Available diffs

• diff from 246 to 247 (4.0 KiB)

postgresql-common (246) unstable; urgency=medium

  * pg_buildext: If PGVERSION appears outside the package name only, fill in
    the newest supported version.
  * pg_wrapper: Select cluster based on port number as well.
  * t/020_create_sql_remove.t: Fix pgwrapper+psql version test on pre-9.2.
  * pgdg: Include .asc and .gpg keys from pgdg-keyring; upgrade
    apt.postgresql.org.sh to write pgdg.sources instead of pgdg.list.

 -- Christoph Berg <email address hidden>  Thu, 10 Nov 2022 15:06:56 +0100

Available diffs

• diff from 242ubuntu1 (in Ubuntu) to 246 (24.8 KiB)
• diff from 242ubuntu2 (in Ubuntu) to 246 (24.8 KiB)

postgresql-common (245) unstable; urgency=medium

  [ Marco Nenciarini ]
  * pgdg: fix unbound variable error with empty PGVERSION.

  [ Christoph Berg ]
  * server/postgresql.mk: EXCLUDE_PACKAGES to skip building libs, used now for
    postgresql-14 in bookworm when postgresql-15 has already been uploaded.
  * server/postgresql.mk: Skip building -doc package when nodoc is selected.

 -- Christoph Berg <email address hidden>  Sat, 22 Oct 2022 14:46:03 +0200

postgresql-common (244+nmu1) unstable; urgency=medium

  * Non-maintainer upload.
  * No source change upload to rebuild with debhelper 13.10.

 -- Michael Biebl <email address hidden>  Sat, 15 Oct 2022 12:38:30 +0200

postgresql-common (244) unstable; urgency=medium

  * debian/supported-versions: Bump default version to 15.
  * dh_install{init,systemd}: Use --no-stop-on-upgrade and to not restart any
    services on postgresql-common upgrades. (Closes: #1011067)
  * debian/maintscripts-functions: Add -v to pg_upgradecluster template to
    stay on the same major version on catversion upgrades.
  * pg_upgradecluster: Fix port handling when --rename is used.

 -- Christoph Berg <email address hidden>  Fri, 14 Oct 2022 10:59:12 +0200

postgresql-common (200+deb10u5) buster; urgency=medium

  * pg_virtualenv: Write temporary password file before chowning the file.
    (Closes: #933569)
  * t/135_pg_virtualenv.t: Import test from master.

 -- Christoph Berg <email address hidden>  Wed, 22 Jun 2022 13:11:44 +0200

postgresql-common (243) unstable; urgency=medium

  * pg_backupcluster: Enable gzip compression with pg_receivewal.
  * next_free_port: Set SO_REUSEADDR and listen() on sockets created.
  * t/TestLib.pm check_clean: Use ss from iproute2 instead of netstat.
  * debian/supported-versions: Don't look at the OS release, we'll just ship
    the matching file in that release.
  * Test-depend on locales-all.
  * pgcommon.sh: Remove, dropping get_release and locale_gen.
  * postgresql.service: Improve comment explaining the relation to
    postgresql@.service.
  * testsuite: Run all tests even when one is failing.
  * pg_wrapper: If the cluster version is older than 9.2, consider psql only
    up to version 14 instead of the newest version.
  * Use grep -E instead of egrep.
  * debian/rules: Use DEB_VERSION instead of dpkg-parsechangelog.

 -- Christoph Berg <email address hidden>  Thu, 08 Sep 2022 15:34:54 +0200

postgresql-common (242) unstable; urgency=medium

  * server/postgresql.mk: Tell pg_upgrade to create sockets in /tmp.
  * pg_virtualenv: Unset PGHOSTADDR PGPORT PGSERVICE.

 -- Christoph Berg <email address hidden>  Thu, 11 Aug 2022 11:25:31 +0200

postgresql-common (241) unstable; urgency=medium

  * Remove stats_temp_directory in PG 15.
  * server/postgresql.mk: Fix detection of latest llvm version.
  * server/postgresql.mk: Remove builddir prefix from generated pg_config.
  * t/045_backup.t: Accept new PG15 psql -l output.

 -- Christoph Berg <email address hidden>  Wed, 11 May 2022 15:57:04 +0200

Available diffs

• diff from 240 to 241 (3.5 KiB)

postgresql-common (240) unstable; urgency=medium

  * t/085_pg_ctl.conf.t: Honor systemd hard core file size limit.

 -- Christoph Berg <email address hidden>  Mon, 14 Mar 2022 12:12:02 +0100

postgresql-common (239) unstable; urgency=medium

  * t/085_pg_ctl.conf.t: sudo and salsa-ci set the core file size hard limit
    to 0 by default, undo that. (Salsa: postgresql/postgresql#2)

 -- Christoph Berg <email address hidden>  Fri, 11 Mar 2022 12:03:17 +0100

postgresql-common (238) unstable; urgency=medium

  * pg_restorecluster: Correctly detect errors on restore.
  * pg_restorecluster: Support uncompressed backups and bz2/xz compression.
  * supported-versions: Unsupport PG 9.6 for apt.postgresql.org.
  * t/180_ecpg.t: Enable debug output and run program in pg_virtualenv.

 -- Christoph Berg <email address hidden>  Thu, 10 Feb 2022 11:02:57 +0100

Available diffs

• diff from 237 to 238 (1.7 KiB)

postgresql-common (237) unstable; urgency=medium

  * postgresql.mk: Mute dpkg error on empty version fields in debian/control.

 -- Christoph Berg <email address hidden>  Tue, 04 Jan 2022 11:44:42 +0100

Available diffs

• diff from 236 to 237 (596 bytes)

postgresql-common (236) unstable; urgency=medium

  * pg_buildext: Generate postgresql:Depends substvar and depend on
    postgresql-$version-jit-llvm (>= $llvm_version).

 -- Christoph Berg <email address hidden>  Mon, 03 Jan 2022 16:19:56 +0100

Available diffs

• diff from 235 to 236 (1.7 KiB)

postgresql-common (235) unstable; urgency=medium

  [ Christian Ehrhardt ]
  * server/postgresql.mk: avoid gcc 11 ICE on armhf and armel.

 -- Christoph Berg <email address hidden>  Mon, 20 Dec 2021 18:13:44 +0100

Available diffs

• diff from 234 to 235 (618 bytes)

postgresql-common (234) unstable; urgency=medium

  * server/postgresql.mk: Fix OS detection in override_dh_auto_test.

 -- Christoph Berg <email address hidden>  Mon, 06 Dec 2021 10:51:35 +0100

Available diffs

• diff from 226 to 234 (25.8 KiB)
• diff from 233 to 234 (996 bytes)

postgresql-common (233) unstable; urgency=medium

  * pg_virtualenv.1: Document -p and extension_destdir.
  * server: Centralize server packages debian/rules logic here.

 -- Christoph Berg <email address hidden>  Fri, 03 Dec 2021 09:50:31 +0100

Available diffs

• diff from 232 to 233 (5.2 KiB)

postgresql-common (232) unstable; urgency=medium

  * pg_backupcluster: Preserve wal file timestamps with compresswal.
  * t/006_next_free_port.t: Sleep longer after nc startup.
  * t/020_create_sql_remove.t: Sleep a bit after stopping clusters to
    hopefully fix a race condition seen on ci.debian.net.
  * t/180_ecpg.t: Print error messages to console.
  * dh_make_pgxs/debian/watch: Look at tags instead of releases.

 -- Christoph Berg <email address hidden>  Thu, 11 Nov 2021 17:17:49 +0100

Available diffs

• diff from 231 to 232 (2.4 KiB)

postgresql-common (231) unstable; urgency=medium

  * supported-versions: Set PG 14 as default.
  * pg_createcluster: Avoid "auth is trust" initdb warning on pre-9.2 servers.

 -- Christoph Berg <email address hidden>  Thu, 30 Sep 2021 13:12:36 +0200

postgresql-common (230) unstable; urgency=medium

  * dh_installinit, dh_installsystemd: Use --no-start to prevent all actions
    on postgresql.service at postgresql-common install/upgrade time.
  * t/012_maintscripts.t: Compare pid files instead of using ps.

 -- Christoph Berg <email address hidden>  Tue, 28 Sep 2021 13:15:59 +0200

postgresql-common (229) unstable; urgency=medium

  * postgresql-common.maintscript: We mistakenly tried to remove
    /etc/apt/apt.conf.d/01autoremove instead of 01autoremove-postgresql.
    Fix, and bump version to retry the removal.
  * pg_updateaptconfig: Switch to 02autoremove-postgresql since dpkg 1.20.6's
    new built-in remove-conffile-on-upgrade logic doesn't like the file
    reappearing as non-conffile.
  * pg_createcluster: Add --no-status option for suppressing status message.
  * pg_createcluster: Use scram-sha-256 by default in PG14+.
  * t/020_create_sql_remove.t: Check pg_hba.conf auth methods.
  * pg_upgradecluster: Migrate old files to new cluster before upgrading.
  * pg_wrapper: Skip LD_PRELOAD logic in PG13+.
  * postgresql-client-common: Stop recommending libreadline.
  * postgresql-server-dev-all: Mark dependency on make as :any.
  * Depend on ${perl:Depends}.
  * dh_installsystemd: Use -r to prevent restarting postgresql.service.
  * t/012_maintscripts.t: New maintainer scripts test.
  * pgdg/apt.postgresql.org.sh: Try /etc/os-release first and add some
    precautionary checks to the other methods.

 -- Christoph Berg <email address hidden>  Sat, 25 Sep 2021 21:43:00 +0200

postgresql-common (228) unstable; urgency=medium

  * postgresql-server-dev-all: Move to Arch: any, M-A: same to allow
    cross-compiling.
  * pg_buildext.pod: Use `B-D: postgresql-all <!nocheck>` in example.
  * Update doc/dependencies.* and install as .svg.
  * pg_virtualenv, postgresql-common.postrm: Use `command -v` instead of
    deprecated `which`.
  * Upgrade to debhelper 13; packaging still compatible with DH10 in stretch.
  * Add ${misc:Pre-Depends} to postgresql-common.
  * Install pg_backupcluster.1, pg_restorecluster.1, and pg_getwal.1 manpages.
  * Remove /etc/sysctl.d/30-postgresql-shm.conf, obsolete with current
    kernels and PG versions.

 -- Christoph Berg <email address hidden>  Thu, 16 Sep 2021 18:44:15 +0200

postgresql-common (227) unstable; urgency=medium

  * pgdg/apt.postgresql.org.sh, t/020_create_sql_remove.t: Support PG15.
  * pgxs.pm: Enable tests on hurd, it can run PostgreSQL now.

 -- Christoph Berg <email address hidden>  Tue, 31 Aug 2021 17:33:54 +0200

postgresql-common (226) experimental; urgency=medium

  [ Christoph Berg ]
  * pg_backupcluster, pg_restorecluster: New front-ends to pg_basebackup,
    pg_receivewal and pg_dump with systemd service/timer integration.
  * pg_dropcluster: Disable cluster and backup services on drop.
  * pg_upgradecluster: Deprecate vacuum_cleanup_index_scale_factor in 14.
  * Promote libjson-perl to Depends.
  * Move cluster owner verification from pg_ctlcluster to new PgCommon.pm
    function validate_cluster_owner and use it in pg_upgradecluster,
    pg_renamecluster, pg_dropcluster. (Extends the CVE-2019-3466 fix.)
  * PgCommon.pm: documentation converted to POD, many thanks to Pablo Valdés
    for the excellent patch!
  * PgCommon.pm error: Use die() instead of exit().
  * supported-versions: Drop support for 9.5 on apt.postgresql.org.

  [ Hanefi Onaldi ]
  * pg_buildext build: Move extra_cflags from command line arguments to COPT
    so Makefile.global CFLAGS are not overridden

  [ Bryce Harrington ]
  * d/postinst: Only add postgres to group ssl-cert if it isn't
    already a member of that group. (Closes: #984473, LP: #1690432)

 -- Christoph Berg <email address hidden>  Wed, 12 May 2021 17:16:38 +0200

Available diffs

• diff from 225ubuntu1 (in Ubuntu) to 226 (22.7 KiB)

postgresql-common (225) unstable; urgency=medium

  * pg_lsclusters, cluster_info: Show cluster managed by pacemaker or patroni.
  * pg_ctlcluster: Fix "use systemctl instead" context.
  * pg_createcluster: In 14+, use initdb --no-instructions.
  * pg_upgradecluster: Deprecate password_encryption as boolean in 14.
  * t: Accept changed connection error messages from libpq 14.

 -- Christoph Berg <email address hidden>  Tue, 02 Feb 2021 15:40:25 +0100

Available diffs

• diff from 224 to 225 (6.0 KiB)

postgresql-common (224) unstable; urgency=medium

  * pg_wrapper, PgCommon: When looking for the newest version, consider the
    name of the binary (psql, postgres) asked for.
  * pg_buildext: Fix typo in the psql/virtualenv exit code handling.
  * pg_ctlcluster: Fix starting of md5-only clusters on 8.2/8.3.
  * t/025_logging.t: Sleep a bit for the log tests to make test more stable.
  * postgresqlrc.5, user_clusters.5: Mention file locations more prominently.
  * pg_upgradecluster: Deprecate operator_precedence_warning in PG14.

 -- Christoph Berg <email address hidden>  Thu, 14 Jan 2021 16:23:51 +0100

Available diffs

• diff from 223 to 224 (6.7 KiB)

postgresql-common (223) unstable; urgency=medium

  * pg_ctlcluster: Refuse to start root-owned clusters with a sensible error
    message.
  * pgdg/apt.postgresql.org.sh: Add groovy, remove archived distributions.

 -- Christoph Berg <email address hidden>  Thu, 12 Nov 2020 12:37:57 +0100

Available diffs

• diff from 216 to 223 (27.6 KiB)
• diff from 222 to 223 (1.3 KiB)

postgresql-common (222) unstable; urgency=medium

  [ Michael Banck ]
  * pg_upgradecluster: set max_wal_senders along with wal_level in ugprade
    mode.

  [ Christoph Berg ]
  * Drop t/003_package_checks.t, psql can be linked with readline now.
    http://meetbot.debian.net/debian-ftp/2020/debian-ftp.2020-03-13-20.02.html
  * Remove PostgreSQL 13 transition Breaks, problems were testsuite-only.

 -- Christoph Berg <email address hidden>  Mon, 26 Oct 2020 11:46:34 +0100

postgresql-common (221) unstable; urgency=medium

  [ Christoph Berg ]
  * pg_virtualenv: Skip build-time package tests if the PG server is missing
    extension_destdir support.
  * Test-depend on debhelper for the pg_buildext tests.
  * Skip pg_buildext tests when invoked from postgresql-NN server tests.
  * dh_make_pgxs: Support running with older debhelper versions.
  * pgdg/apt.postgresql.org.sh: Bump devel version to 14, thanks to Aaron
    Pavely for spotting!
  * pg_updateaptconfig: Fix not to emit duplicated version entries.
  * Add Breaks on regressing packages with the move to PG13.

  [ Dominik George ]
  * pg_buildext: Fail late on builds and tests to logs for all versions.

 -- Christoph Berg <email address hidden>  Tue, 13 Oct 2020 23:27:27 +0200

postgresql-common (220) unstable; urgency=medium

  * dh_make_pgxs: Use dh --with pgxs in template.
  * dh_make_pgxs: Add `R³: no` to control.in template.
  * debhelper: Use dpkg_architecture_value() instead of hostarch() because
    Dh_Lib.pm on stretch and xenial doesn't have the latter yet.
  * Add t/190_pg_buildext.t covering pg_buildext and debhelper integration.

 -- Christoph Berg <email address hidden>  Mon, 12 Oct 2020 23:21:52 +0200

postgresql-common (219) unstable; urgency=medium

  * postgresql-server-dev-all: Depend on strict postgresql-common version.
  * pg_virtualenv: Export PGVERSION with the PostgreSQL major version.
  * pg_virtualenv: Add -p option to set extension_destdir.
  * pg_buildext: Add "virtualenv" action that loops over shells for testing.
  * pg_buildext: Fix "installed-versions" for empty package name suffixes.
  * pg_buildext: Don't update debian/control if debian/control.in is missing.
  * Move dh_pgxs_test after dh_link so we have the links in the install trees.
  * Skip invoking dh_pgxs_test if nocheck is set, or when on hurd-i386.

 -- Christoph Berg <email address hidden>  Tue, 06 Oct 2020 23:26:00 +0200

postgresql-common (218) unstable; urgency=medium

  * pg_buildext installcheck: Set DESTDIR during build-time tests.
  * pg_buildext clean: Do not assume Makefile to be present. (Closes: #971517)

 -- Christoph Berg <email address hidden>  Fri, 02 Oct 2020 12:49:44 +0200

postgresql-common (217) unstable; urgency=medium

  * Set PostgreSQL 13 as default version.
  * pg_upgradecluster: Rename wal_keep_segments to wal_keep_size on upgrades
    to PG 13.
  * pg_createcluster: Add option --quiet to suppress initdb output and make
    pg_virtualenv use it.
  * pg_createcluster: Allow -o --pgoption to override createcluster.conf
    settings.
  * t/060_obsolete_confparams.t: Generate full config files dynamically.
  * dh_make_pgxs: Use current debhelper version instead of the oldest one,
    support setting homepage, general template copy-editing.
  * Implement extension building as `dh $@ --with pgxs` and pgxs_loop, backed
    by `--buildsystem=pgxs` and pgxs_loop. We also run `make installcheck` at
    extension build time now via dh_pgxs_test and our PostgreSQL
    extension_destdir patch. Previously extensions could only be tested at
    runtime via autopkgtest.
  * pg_buildext loop: Clean after building instead of before.
  * Add `pg_buildext psql` action for extensions that use psql for testing.
  * Drop the PG major prefix from postgresql-all version number so extensions
    can declare sensible versioned dependencies on it.
  * Updated it debconf translation by Luca Monducci, thanks! (Closes: #969220)

 -- Christoph Berg <email address hidden>  Wed, 30 Sep 2020 21:54:23 +0200

postgresql-common (200+deb10u4) buster; urgency=medium

  * t/170_extensions.t: Don't drop plpgsql before testing extensions.
    A recent security fix in the PostgreSQL server (CVE-2020-14350) makes use
    of plpgsql DO blocks in various extension creation scripts without
    declaring a formal dependency on it, so change tests not to drop plpgsql.

 -- Christoph Berg <email address hidden>  Fri, 14 Aug 2020 14:54:15 +0200

postgresql-common (216) unstable; urgency=medium

  * Updated es debconf translation by Camaleón, thanks! (Closes: #960994)
  * apt.postgresql.org.sh: Install contrib package with -i.
  * pg_virtualenv: Show PostgreSQL backtrace when coredumps are found and gdb
    is installed.
  * pg_ctlcluster: Fix cluster start in 8.2/3.
  * pg_virtualenv: 8.2 doesn't have pg_ctl -c yet.
  * t/170_extensions.t: Don't drop plpgsql before testing extensions.
  * t/TestLib.pm: Fix deb_installed to only recognize fully installed
    packages.

 -- Christoph Berg <email address hidden>  Wed, 12 Aug 2020 15:10:25 +0200

Available diffs

• diff from 215 to 216 (5.7 KiB)

postgresql-common (215) unstable; urgency=medium

  * Mark only the packages as apt NeverAutoRemove for which PostgreSQL
    clusters exist. /etc/apt/apt.conf.d/01autoremove-postgresql is updated
    when clusters are created and dropped. (Closes: #948728)
  * t/TestLib.pm: Add os_release function.
  * t/020_create_sql_remove.t: Verify server libssl linkage.

 -- Christoph Berg <email address hidden>  Thu, 14 May 2020 16:36:50 +0200

Available diffs

• diff from 214 to 215 (4.1 KiB)

postgresql-common (214) unstable; urgency=medium

  * check_pidfile_running: Read /proc/$pid/cmdline instead of calling /bin/ps.
    (Works around #952572)

 -- Christoph Berg <email address hidden>  Thu, 27 Feb 2020 13:22:52 +0100

Available diffs

• diff from 213 to 214 (973 bytes)

postgresql-common (213) unstable; urgency=medium

  [ Christian Ehrhardt ]
  * t/020_create_sql_remove.t: fix file clear with procps 3.16. (LP: #1864423)

  [ Christoph Berg ]
  * pg_lsclusters: List clusters even if the corresponding PostgreSQL
    binaries are missing; include "binaries_missing" in status column.
    (Salsa #13)
  * Reload systemd on install since we don't do that automatically via
    dh_installinit. Problem reported by velix, thanks! (Salsa #12)
  * debian/maintscripts-functions: Save full bin and lib dirs on catversion
    bump. Problem reported by Komzzpa, thanks! (Salsa #9)
  * debian/maintscripts-functions: Suppress errors from pg_controldata, the
    control file might be missing if the cluster was pg_upgraded. Spotted by
    Michael Banck, thanks! (Salsa #6)
  * pg_wrapper: Reword docs to better describe clusters on the local system.
    Reported by James Coleman, thanks! (Closes: #950149)
  * pg_wrapper: Document that `ALTER SYSTEM SET port` will interact badly with
    cluster selection. (Closes: #919385)

 -- Christoph Berg <email address hidden>  Mon, 24 Feb 2020 16:20:14 +0100

Available diffs

• diff from 211 to 213 (4.1 KiB)

postgresql-common (181+deb9u3) stretch-security; urgency=medium

  * pg_ctlcluster: Drop privileges before creating socket and stats temp
    directories outside /var/run/postgresql. The default configuration is not
    affected by this change. Users with directories on volatile storage
    (tmpfs) in other locations have to make sure the parent directory is
    writable for the cluster owner. (CVE-2019-3466, discovered by Rich Mirch)

 -- Christoph Berg <email address hidden>  Tue, 12 Nov 2019 15:00:36 +0100

postgresql-common (200+deb10u3) buster-security; urgency=medium

  * pg_ctlcluster: Drop privileges before creating socket and stats temp
    directories outside /var/run/postgresql. The default configuration is not
    affected by this change. Users with directories on volatile storage
    (tmpfs) in other locations have to make sure the parent directory is
    writable for the cluster owner. (CVE-2019-3466, discovered by Rich Mirch)

 -- Christoph Berg <email address hidden>  Tue, 12 Nov 2019 15:00:36 +0100

postgresql-common (211) unstable; urgency=medium

  [ Dagfinn Ilmari Mannsåker ]
  * pg_createcluster, pg_updatedicts: Enable strict and warnings.

 -- Christoph Berg <email address hidden>  Mon, 27 Jan 2020 14:57:59 +0100

Available diffs

• diff from 210 to 211 (4.9 KiB)

postgresql-common (210) unstable; urgency=medium

  * pg_ctlcluster: Drop privileges before creating socket and stats temp
    directories outside /var/run/postgresql. The default configuration is not
    affected by this change. Users with directories on volatile storage
    (tmpfs) in other locations have to make sure the parent directory is
    writable for the cluster owner. (CVE-2019-3466, discovered by Rich Mirch)

 -- Christoph Berg <email address hidden>  Thu, 14 Nov 2019 13:23:42 +0100

Available diffs

• diff from 204ubuntu1 (in Ubuntu) to 210 (13.9 KiB)
• diff from 209 to 210 (1.2 KiB)

postgresql-common (209) unstable; urgency=medium

  * pg_buildext: Fix installcheck for packages that don't have
    debian/control.in (pg-sphere).
  * PgCommon.pm cluster_info: Recognize standby.signal and recovery.signal for
    PG12 clusters instead of recovery.conf.

 -- Christoph Berg <email address hidden>  Thu, 07 Nov 2019 15:09:18 +0100

Available diffs

• diff from 208 to 209 (1.3 KiB)

postgresql-common (208) unstable; urgency=medium

  [ Christoph Berg ]
  * gitlab/gitlab-ci.yml: Too many packages fail because reprotest runs the
    build as root, disable for now.
  * README.Debian: Redirect reference to architecture.html to README.md.gz.
    (Closes: #942021)
  * README.Devel: Remove, bzr is long obsolete.
  * Remove dependency on dctrl-tools; rewrite control file updating in perl.
    As a side effect, generated debian/control files will no longer have a
    trailing empty line. Die if no supported versions were found.
  * pg_upgradecluster: Accept -m link and -m clone for simplicity.
  * debian/supported-versions: Add 12 as default version and for Ubuntu 20.04.
  * pg_createcluster: Add note on security implications of using --auth-host
    and --auth-local.
  * postgresql-all: Don't depend on postgresql-plpython-12, it doesn't exist.
  * pg_buildext: New action "installed-versions" reporting the list of
    PostgreSQL major versions used by packages built from a source package.
  * pg_buildext: "installcheck" uses "installed-versions" now.

  [ Tilman Koschnick ]
  * pg_upgradecluster: Support passing --clone to pg_upgrade.

 -- Christoph Berg <email address hidden>  Mon, 28 Oct 2019 15:04:12 +0100

Available diffs

• diff from 204ubuntu1 (in Ubuntu) to 208 (13.0 KiB)

postgresql-common (207) unstable; urgency=medium

  * PgCommon.pm: Fix infinite recursion in get_program_path if
    /usr/lib/postgresql/ contains a non-version directory.
    Patch by ITANI Eiichiro, thanks! (Closes: #940220)

 -- Christoph Berg <email address hidden>  Fri, 20 Sep 2019 14:24:23 +0200

postgresql-common (206) unstable; urgency=medium

  * pg_ctlcluster, pg_upgradecluster: Always use latest psql.
  * t/135_pg_virtualenv.t: Run pg_virtualenv on all versions.
  * gitlab/gitlab-ci.yml: Include salsa-ci pipeline instead of our own.

 -- Christoph Berg <email address hidden>  Thu, 12 Sep 2019 15:49:10 +0200

postgresql-common (200+deb10u2) buster; urgency=high

  DATA LOSS WARNING: pg_upgradecluster from postgresql-common 200,
  200+deb10u1, 201, and 202 will corrupt the data_directory setting when used
  *twice* to upgrade a cluster (e.g. 9.6 -> 10 -> 11). This update fixes the
  original problem, and also heals affected clusters on the next upgrade. No
  additional steps are required.

  https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=931635

  * pg_upgradecluster: Don't accidentally set (the wrong!) data_directory in
    postgresql.auto.conf. (Closes: #931635)
  * PgCommon.pm: Ignore data_directory when set in postgresql.auto.conf.
  * pg_upgradecluster: Delete data_directory from postgresql.auto.conf in new
    cluster.

 -- Christoph Berg <email address hidden>  Thu, 25 Jul 2019 23:04:54 +0200

postgresql-common (205) unstable; urgency=medium

  * Disable plpython2 packages by default. (Closes: #937310)
  * testsuite: Prefer PgCommon.pm from current directory.
  * pgcommon.sh: Remove obsolete Ubuntu code in locale_gen function.
  * Drop lsb-release dependencies, we prefer /etc/os-release anyway.
  * apt.postgresql.org.sh: Parse VERSION_CODENAME in /etc/os-release.

 -- Christoph Berg <email address hidden>  Wed, 04 Sep 2019 08:38:08 +0200

postgresql-common (204) unstable; urgency=medium

  * dh_installinit: Add -ppostgresql-common to work around debhelper #932073.
  * dh_make_pgxs: Add debian/watch template (with a github pattern).
  * pgdg/apt.postgresql.org.sh: Add options to choose PostgreSQL version, and
    to optionally install packages automatically.
  * Move pg_buildext from postgresql-server-dev-all to postgresql-common. Many
    use-cases do not need the header files and compiler dependencies
    installed.
  * debian/supported-versions: Use PG11 on Bullseye.
  * pg_virtualenv: Write temporary password file before chowning the file.
    (Closes: #933569)

 -- Christoph Berg <email address hidden>  Thu, 08 Aug 2019 12:48:00 +0200

Available diffs

• diff from 203 to 204 (6.6 KiB)

postgresql-common (203) unstable; urgency=medium

  DATA LOSS WARNING: pg_upgradecluster from postgresql-common 200 .. 202 will
  corrupt the data_directory setting when used *twice* to upgrade a cluster
  (e.g. 9.6 -> 10 -> 11). This update fixes the original problem, and also
  heals affected clusters on the next upgrade. No additional steps are required.

  https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=931635

  * pg_createcluster: Allow clusters with owner gid 0. (salsa-ci uses that.)
  * pg_createcluster: If there are --auth options in createcluster.conf's
    initdb_options, don't update pg_hba.conf.
  * pg_upgradecluster: Don't accidentally set (the wrong!) data_directory in
    postgresql.auto.conf. (Closes: #931635)
  * PgCommon.pm: Ignore data_directory when set in postgresql.auto.conf.
  * pg_upgradecluster: Delete data_directory from postgresql.auto.conf in new
    cluster.
  * pg_upgradecluster: Use a tempfile instead of replacing the original
    pg_hba.conf file during upgrades.
  * pg_upgradecluster: With --keep-port, leave old cluster on original port.
    (Closes: #507133)
  * pg_ctlcluster: For consistency with systemctl, also accept action before
    cluster name: "pg_ctlcluster start 11 main".
  * pg_ctlcluster: Use `psql -w` to avoid flooding the log with errors when
    the cluster was configured for password authentication on local
    connections. Patch by Evgeny, thanks!
  * debian/tests: Do full testsuite run. Previously the full testsuite was
    only running from the postgresql-NN server package.
  * t/135_pg_virtualenv.t: Don't fail if fakeroot is not present.

 -- Christoph Berg <email address hidden>  Tue, 09 Jul 2019 16:16:57 +0200

Available diffs

• diff from 200+deb10u1ubuntu1 (in Ubuntu) to 203 (16.9 KiB)
• diff from 202 to 203 (10.7 KiB)

postgresql-common (202) unstable; urgency=medium

  * pg_ctlcluster: Close extra log filedescriptor. Thanks Andrey Borodin!
    (Closes: #930728)
  * pg_virtualenv: Disable fakeroot while creating clusters so we don't end up
    running as root.
  * t/135_pg_virtualenv.t: New test file.
  * t/TestLib.pm: Restrict check_clean to LISTENing sockets.
  * gitlab/gitlab-ci.yml: Run blhc; fail on lintian errors.

 -- Christoph Berg <email address hidden>  Tue, 02 Jul 2019 14:39:56 +0200

Available diffs

• diff from 200+deb10u1ubuntu1 (in Ubuntu) to 202 (7.4 KiB)

postgresql-common (201) experimental; urgency=medium

  [ Christoph Berg ]
  * Disable ssl on older server versions. (Versions up to 9.1 support
    OpenSSL 1.0 only, which has been removed from Debian unstable.)
  * pg_upgrade: Fix 'sameuser' handling in pg_hba when upgrading from pre-8.4
    versions.
  * gitlab/gitlab-ci.yml: Ignore skipped tests, and packages without tests; install
    pristine-tar; install via dh_make_pgxs.
  * Move .gitlab-ci.yml to debian/gitlab-ci.yml; add buster and stretch,
  * remove jessie. (Not to be confused with gitlab/gitlab-ci.yml.)
  * dh_make_pgxs: Set debhelper compat level to 9, highest version supported
    by jessie and trusty.

  [ Andreas Hasenack ]
  * Set Ubuntu 19.10 default PostgreSQL version to 11.

 -- Christoph Berg <email address hidden>  Thu, 09 May 2019 10:02:05 +0200

postgresql-common (200+deb10u1) unstable; urgency=medium

  * When upgrading from stretch to buster, all text indexes need to be
    reindexed. Warn users about that in NEWS.Debian.

 -- Christoph Berg <email address hidden>  Fri, 12 Apr 2019 14:32:52 +0200

postgresql-common (200) unstable; urgency=medium

  * pg_createcluster: Don't refuse explicit -p argument even when port is
    already in use. (Closes: #653870)
  * pg_createcluster: Override suggested cluster start command in initdb.
    (Closes: #872660)
  * pg_upgradecluster, t/052_upgrade_encodings.t: pg_dumpall 11 retains the
    database encoding, so switching encodings via dump-restore does not work
    anymore.
  * pg_upgradecluster: Deprecate 'replacement_sort_tuples' in version 11.
  * pg_upgradecluster: Migrate postgresql.auto.conf to new cluster.
    (Closes: #810615)
  * pg_ctlcluster: Die early if logfile is not available. (Closes: #891234)
  * pg_ctlcluster: Die early if pg_ctl cannot be found. (See: #918784)
  * pg_ctlcluster: Document --skip-systemctl-redirect, and skip redirect if
    --foreground is requested.
  * pg_renamecluster: Notify systemd. (Closes: #839954)
  * pg_renamecluster: Document that cluster_name is updated as well.
  * pg_dropcluster: Delete tablespace directories. (Closes: #916449)
  * pg_dropcluster: Silence warning if data_directory is already gone.
    Spotted by Jean-Christophe Arnu, merci!
  * get_cluster_port: Fall back to 5432 if port is not defined in config.
    (Closes: #920248)
  * read_cluster_conf_file: Use cluster_data_directory instead of hardcoding
    /var/lib/postgresql.
  * postgresql@.service: Add After=network.target to ensure the server is
    stopped before networking goes down on shutdown. Thanks Elrond!
    (Closes: #910991)
  * postgresql@.service: Drop /var prefix from PIDFile, systemd complained
    about legacy directory /var/run/postgresql.
  * postgresql-generator: Don't attempt to auto-start removed versions.
    (Closes: #918784)

 -- Christoph Berg <email address hidden>  Fri, 01 Mar 2019 20:47:06 +0100

postgresql-common (199) unstable; urgency=medium

  [ Antti Salmela ]
  * pg_upgradecluster: Pass --jobs to pg_upgrade when using upgrade method.

  [ Christoph Berg ]
  * supported-versions: Drop support for 9.3 on apt.postgresql.org.

 -- Christoph Berg <email address hidden>  Mon, 28 Jan 2019 16:27:27 +0100

Available diffs

• diff from 198 to 199 (2.3 KiB)

postgresql-common (198) unstable; urgency=medium

  [ Christoph Berg ]
  * Add gitlab-ci.yml file to be included in all PostgreSQL team packages.
  * testsuite: Stop postgresql@* explicitly. (Workaround for #759725)

  [ Michael Banck ]
  * pg_buildext: Add support for passing Makefile variables via the new -m
    option. (Closes: #915953)

 -- Christoph Berg <email address hidden>  Sun, 16 Dec 2018 11:55:10 +0100

Available diffs

• diff from 197 to 198 (2.6 KiB)

postgresql-common (197) unstable; urgency=medium

  * dh_make_pgxs: Update Maintainer address and package URLs.
  * pg_buildext: Fix problem with substitution pattern occurring multiple
    times.
  * pg_buildext: Set PG_REGRESS_DIFF_OPTS for unified diffs from pg_regress.

 -- Christoph Berg <email address hidden>  Thu, 22 Nov 2018 11:59:06 +0100

Available diffs

• diff from 196 to 197 (1.3 KiB)

postgresql-common (196) unstable; urgency=medium

  [ Christoph Berg ]
  * Replace version 10 in examples by version 11. (Closes: #911391)
  * Replace -X.Y version number template in examples by -NN.
  * Updated Turkish translation by Atila Koç, thanks! (Closes: #912322)
  * read_conf_file: Accept '+' in unquoted values for floats like 1.5+e3.
    Thanks to David Barbion for spotting!
  * pg_buildext: Handle multiple overlapping substitutions in
    debian/tests/control.in better.

  [ Jeremy Bicha ]
  * Add Ubuntu 19.04 aka disco.

 -- Christoph Berg <email address hidden>  Wed, 21 Nov 2018 12:32:11 +0100

Available diffs

• diff from 193ubuntu1 (in Ubuntu) to 196 (11.9 KiB)
• diff from 194ubuntu1 (in Ubuntu) to 196 (6.0 KiB)

postgresql-common (194) unstable; urgency=medium

  * Remove iproute2 | net-tools dependency from postgresql-server-dev-all,
    obsolete in pg_buildext since 178.
  * Also save pg_controldata on catversion changes, pg_upgrade needs it.
    Spotted by Dagfinn Ilmari Mannsåker, thanks!
  * Chown /etc/postgresql to user postgres.
  * pg_ctlcluster: Use "fast" shutdown by default, and remove code to kill -9
    the server if it doesn't react to a --force stop. (Closes: #756008)
  * pg_upgradecluster: Start upgraded cluster only if it was running before,
    override with new --[no-]start option. (Closes: #876281)
  * pg_upgradecluster: With pg_upgrade, set wal_level early so standby servers
    can be upgraded via the instructions from pg_upgrade(1). (Closes: #876293)
  * pg_upgradecluster: Notify systemd about disabling the old cluster.
  * pg_upgradecluster: Drop sleep(4) that had been there since the first
    version.
  * pg_createcluster: Create stats_temp_directory, so pg_upgrade(cluster) can
    use it even without invoking pg_ctlcluster before. (Closes: #827469)
  * pg_upgradecluster: Drop check for pg_restore --no-data-for-failed-tables,
    switch was introduced in 8.2; use it always and not only when upgrade
    scripts are present. (Closes: #876282)
  * Debian: Default PostgreSQL version in buster is 11.

 -- Christoph Berg <email address hidden>  Thu, 11 Oct 2018 17:29:41 +0200

postgresql-common (193) unstable; urgency=medium

  [ Francois Marier ]
  * Use /run in /usr/lib/tmpfiles.d/postgresql.conf to avoid deprecation
    warning. (Closes: #902875)

  [ Christoph Berg ]
  * pg_buildext: Stop passing srcdir to make invocations.
  * pg_buildext: Copy CFLAGS from environment to COPT so Makefile.global
    picks it up. Notably this will make extension builds use
    -f{debug,file}-prefix-map from dpkg-buildflags.

 -- Christoph Berg <email address hidden>  Thu, 23 Aug 2018 12:57:46 +0200

Available diffs

• diff from 192 to 193 (1.4 KiB)

postgresql-common (192) unstable; urgency=medium

  * postgresql@.service: Use AssertPathExists instead of ConditionPathExists
    so trying to operate on non-existing clusters fails loudly.
    (Closes: #891836)
  * postgresql@.service: Add "RequiresMountsFor /etc/postgresql/%I
    /var/lib/postgresql/%I" to depend on mounts.
  * pg_createcluster: Fix error on importing existing clusters, spotted by
    Mark Eichin, thanks! (Closes: #886871)
  * postinst_check_catversion: Ignore errors while determining PGDATA.
  * Move maintainer address to <email address hidden>.

 -- Christoph Berg <email address hidden>  Wed, 08 Aug 2018 16:21:59 +0200

Available diffs

• diff from 191 to 192 (6.2 KiB)