postgresql-common (290ubuntu1) resolute; urgency=low

  * Merge from Debian unstable. Remaining changes:
    - Ignore postgresql tests results on ppc64el and s390x for now, they go
      OOM

 -- Gianfranco Costamagna <locutusofborg@debian.org>  Fri, 27 Feb 2026 15:05:01 +0100

postgresql-common (290) unstable; urgency=medium

  * t/090_multicluster.t: Use LANG=C to un-confuse rust-coreutils' sort.

 -- Christoph Berg <myon@debian.org>  Thu, 26 Feb 2026 12:04:54 +0100

postgresql-common (289ubuntu1) resolute; urgency=low

  * Merge from Debian unstable. Remaining changes:
    - Ignore postgresql tests results on ppc64el and s390x for now, they go
      OOM

 -- Gianfranco Costamagna <locutusofborg@debian.org>  Thu, 12 Feb 2026 09:17:56 +0100

postgresql-common (289) unstable; urgency=medium

  * pg_upgradecluster: PG 19 removes escape_string_warning.
  * t/027_jit.t: skip on EOL versions that are incompatible with newer LLVM.
  * t/090_multicluster.t: Don't rely on `sort -k3` to do the right thing.
  * pg_wrapper: Remove readline LD_PRELOAD hack.
  * Updated ca translation. (Closes: #1126654)

 -- Christoph Berg <myon@debian.org>  Wed, 11 Feb 2026 11:10:30 +0100

postgresql-common (288ubuntu1) resolute; urgency=low

  * Merge from Debian unstable. Remaining changes:
    - t/090_multicluster.t: skip port change test due to a regression in rust
      coreutils (LP 2125504) (LP: #2125057)
    - Ignore postgresql tests results on ppc64el and s390x for now, they go
      OOM

 -- Gianfranco Costamagna <locutusofborg@debian.org>  Thu, 29 Jan 2026 09:48:35 +0100

postgresql-common (288) unstable; urgency=medium

  [ Christoph Berg ]
  * Remove obsolete /etc/sysctl.d/30-postgresql-shm.conf, take 2.
    (Closes: #1120606)
  * apt.postgresql.org.sh: Add -a architecture option; default to the local
    native architecture.
  * server/postgresql.mk: Build regress.so and install into server-dev package.

  [ Magnus Hagander ]
  * PgCommon.pm package_list: Accept held packages as installed.

  [ Laurenz Albe ]
  * pg_upgradecluster.d/analyze: Prevent waiting for synchronous standbys.

 -- Christoph Berg <myon@debian.org>  Mon, 26 Jan 2026 19:42:15 +0100

postgresql-common (287ubuntu1) resolute; urgency=low

  * Merge from Debian unstable. Remaining changes:
    - t/090_multicluster.t: skip port change test due to a regression in rust
      coreutils (LP 2125504) (LP: #2125057)
    - Ignore postgresql tests results on ppc64el and s390x for now, they go
      OOM

 -- Gianfranco Costamagna <locutusofborg@debian.org>  Fri, 21 Nov 2025 08:57:15 +0100

postgresql-common (287) unstable; urgency=medium

  * Drop postgresql-common -> postgresql-common-dev dependency.

 -- Christoph Berg <myon@debian.org>  Tue, 11 Nov 2025 18:06:11 +0100

postgresql-common (286) unstable; urgency=medium

  * pg_buildext: run_installed always uses the installed versions.

 -- Christoph Berg <myon@debian.org>  Sat, 11 Oct 2025 12:36:47 +0200

postgresql-common (284) unstable; urgency=medium

  * Restore postgresql-common -> postgresql-common-dev dependency until
    all extensions have been updated to test-depend on it.
  * Skip JIT tests if postgresql-18-jit is not installed.

 -- Christoph Berg <myon@debian.org>  Fri, 26 Sep 2025 17:58:33 +0200

postgresql-common (283) unstable; urgency=medium

  * Build extensions for PostgreSQL 18; set 18 as default version.
  * Remove postgresql-common -> postgresql-common-dev dependency; add 'make'
    to postgresql-common-dev dependencies.
  * Instead of having extensions depend on postgresql-NN-jit-llvm (>= X),
    use Breaks: postgresql-NN-jit-llvm (<< X) so postgresql-NN-jit does not
    have to be installed.
  * postgresql@.service: Use TimeoutStartSec=infinity instead of 0.

 -- Christoph Berg <myon@debian.org>  Wed, 10 Sep 2025 14:23:07 +0200

postgresql-common (282ubuntu1) questing; urgency=medium

  * t/090_multicluster.t: skip port change test due to a regression in rust
    coreutils (LP 2125504) (LP: #2125057)

 -- Athos Ribeiro <athos.ribeiro@canonical.com>  Tue, 30 Sep 2025 12:23:30 -0300

postgresql-common (282) unstable; urgency=medium

  * pg_upgradecluster "dump" method improvements:
    * Revert to using plain pg_dumpall for "dump" upgrades.
      In 2005, version 33 had switched to using custom format dumps and
      pg_restore to support large objects, but this has been supported in
      pg_dumpall since 8.1. This enables better error detection during the
      upgrade and abort instead of papering over problems. (The use of
      --no-data-for-failed-tables is also dropped.)
    * Output is now the queries instead of the command tags, should be more
      pleasant to watch.
    * Stop mangling pg_proc.probin, was introduced to work around problems
      with upgrades from woody/7.4.
    * Upgrading clusters with databases not accepting connections is no longer
      supported. (An error is thrown instead.)
    * Use PGOPTIONS to temporarily override default_transaction_read_only.
  * testsuite: Remove special case for plpython3 on 9.x and python 3.12.
  * t/TestLib.pm: Support catching stderr in exec_as().
  * testsuite: Make tests aware on which archs postgresql-NN-jit is built.

 -- Christoph Berg <myon@debian.org>  Sat, 16 Aug 2025 11:28:52 +0200

postgresql-common (281) unstable; urgency=medium

  * pgdg/apt.postgresql.org.sh: PG19 has been branched.
  * server/postgresql.mk: Fix building for PG19.
  * t: Drop python3 exceptions for 9.x, not required.

 -- Christoph Berg <myon@debian.org>  Sat, 19 Jul 2025 12:25:53 +0200

postgresql-common (280) unstable; urgency=medium

  * server/postgresql.mk: Use --with-libcurl on Linux only.
  * Updated pt translation by Américo Monteiro, thanks! (Closes: #1107433)
  * Updated it translation by Luca Monducci, thanks! (Closes: #1107848)

 -- Christoph Berg <myon@debian.org>  Mon, 23 Jun 2025 15:32:53 +0200

postgresql-common (279) unstable; urgency=medium

  * server/postgresql.mk: Build PG18 with libnuma on Linux.

 -- Christoph Berg <myon@debian.org>  Thu, 12 Jun 2025 21:02:00 +0200

postgresql-common (278) unstable; urgency=medium

  * pg_upgradecluster: Do two vacuumdb runs in analyze hook for PG18+.
  * t/040_upgrade.t: Verify presence of stats after upgrade.
  * pg_virtualenv: Adjust to extension_control_path change in PG18.

 -- Christoph Berg <myon@debian.org>  Wed, 07 May 2025 17:58:33 +0200

postgresql-common (277) unstable; urgency=medium

  * Updated ro translation by Remus-Gabriel Chelu, thanks! (Closes: #1101817)
  * server/postgresql.mk: Build PG18 with liburing.

 -- Christoph Berg <myon@debian.org>  Wed, 09 Apr 2025 12:17:57 +0200

postgresql-common (276) unstable; urgency=medium

  * pg_upgradecluster: Use --missing-stats-only in analyze hook for PG18+.
  * pg_virtualenv: Use PG18's extension_control_path to find extensions in
    temporary build paths instead of our custom extension_destdir patch.
  * pg_buildext: Export $PG_CONFIG in all modes.
  * Fix "should we build with LLVM support" detection on PG18+.
  * Remove test-with-jit.conf, wasn't really exercised anyway.
  * Updated es translation by Camaleón, thanks! (Closes: #1098284)
  * Updated tr translation by Atila Koç, thanks! (Closes: #1101161)
  * Updated pt_BR translation by Paulo Henrique de Lima Santana, thanks!
    (Closes: #1098442)

 -- Christoph Berg <myon@debian.org>  Mon, 31 Mar 2025 15:10:15 +0200

postgresql-common (275) unstable; urgency=medium

  [ Christoph Berg ]
  * postgresql.mk: Enable --with-libcurl in PG18; ship llvmjit.so in new -jit
    package.
  * t/TestLib.pm check_clean: Sleep and retry on failure. (Closes: #1099815)
  * Updated nl translation by Frans Spiesschaert, thanks! (Closes: #1099468)
  * Updated de translation by Hermann-Josef Beckers, thanks! (Closes: #1099529)

  [ Michael Banck ]
  * pg_lsclusters: Warn if postgresql.conf is not readable.

 -- Christoph Berg <myon@debian.org>  Tue, 18 Mar 2025 16:37:57 +0100

postgresql-common (274) unstable; urgency=medium

  * PgCommon.pm read_conf_file: Propagate missing_ok to included files.
  * Move pgdg-keyring conflicts to postgresql-client-common where the files
    are located now.

 -- Christoph Berg <myon@debian.org>  Thu, 20 Feb 2025 11:52:38 +0100

postgresql-common (273) unstable; urgency=medium

  * Temporarily remove dependency on "make" until the dependency from
    postgresql-common on postgresql-common-dev is removed for the PG18
    transititon.

 -- Christoph Berg <myon@debian.org>  Fri, 14 Feb 2025 15:03:16 +0100

postgresql-common (272) unstable; urgency=medium

  * Move libipc-run-perl dependency to postgresql-common-dev.

 -- Christoph Berg <myon@debian.org>  Thu, 13 Feb 2025 15:14:15 +0100

postgresql-common (271) unstable; urgency=medium

  * Mark postgresql-common-dev as M-A: foreign.
  * pg_createcluster: Disable SSL on 9.1 and earlier.
  * pg_upgradecluster: Ignore missing postgresql-contrib-NN for 10+.
  * PgCommon read_cluster_conf_file: Allow postgresql.auto.conf to be missing.

 -- Christoph Berg <myon@debian.org>  Thu, 13 Feb 2025 15:01:44 +0100

postgresql-common (270) unstable; urgency=medium

  * postgresql-all.config: Handle systems without clusters.
  * t/190_pg_buildext.t: Check for postgresql-server-dev-all.

 -- Christoph Berg <myon@debian.org>  Fri, 24 Jan 2025 13:03:15 +0100

postgresql-common (269) unstable; urgency=medium

  [ Christoph Berg ]
  * If the "postgresql" meta package is installed, offer automated upgrading
    of the "main" cluster. (Closes: #810730)
  * pg_upgradecluster: Check if all packages for the old version are installed
    for the new version as well. (Closes: #703850)
  * pg_upgradecluster: Enable checksums in "dump" upgrades to 18+; add
    --(no-)data-checksums option. (Closes: #959705)
  * pg_backupcluster: Add -Z --compress option.
  * pg_backupcluster: Mark RUNNING backups properly.
  * pg_ctlcluster: Fix setsid call, thanks Nam T. Nguyễn. (Closes: #1054782)
  * pg_dropcluster: Drop only tablespace dirs matching our catalog version.
  * README.Debian: Update upgrade instructions and fill in major versions
    automatically. (Closes: #943788, #971536)
  * Move contents of postgresql-server-dev-all to new package
    postgresql-common-dev so they can be used stand-alone without pulling in
    postgresql-common-dev-* and dependencies. postgresql-server-dev-all is now
    a pure meta package. Also take over pg_buildext and server build files
    from postgresql-common.
  * postgresql-common temporarily depends on postgresql-common-dev until
    all extension test dependencies have been updated. (Planned for the PG18
    release preparations.)
  * postgresql-common-dev is arch: all, convert postgresql-server-dev-all back
    to arch: all as well since the PG build chain isn't cross-build ready yet
    anyway.
  * Remove postgresql-contrib meta package, provide it from postgresql.
  * supported-versions: Remove obsolete distribution-detection code; move to
    postgresql-common-dev; don't install
    /etc/postgresql-common/supported_versions by default.
  * postgresql-common.config: Remove deprecation notice for old majors.
  * debian/maintscripts-functions: Create "main" cluster only when no other
    clusters exist yet.
  * pg_buildexit: Pass -j to `make` invocations. (Salsa: !23)
  * pg_buildexit: Error out without a PGVERSION pattern in debian/control.in.
  * PgCommon.pm set_conffile_value: Fix replacing unquoted floats and negative
    values, thanks Allan Forsberg!
  * PgCommon.pm read_conf_file: Add missing_ok parameter.
  * Remove obsolete /etc/sysctl.d/30-postgresql-shm.conf. (Closes: #1042927)
  * Move apt.postgresql.org.{asc,gpg,sh} to postgresql-client-common.
    Drop /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg compat code.

  [ Christopher Bock ]
  * pg_backupcluster: Fix backup directory in documentation.

  [ Dennis Schwan ]
  * Prevent removal of update-alternatives in RPM when updating package.

  [ Michael Banck ]
  * pg_createcluster: Do not remove existing data directory on failure.
    (Closes: #1056303)

 -- Christoph Berg <myon@debian.org>  Wed, 22 Jan 2025 20:05:11 +0100

postgresql-common (267) unstable; urgency=medium

  * t/027_jit.t: No jit for PG18+ on Ubuntu focal.

 -- Christoph Berg <myon@debian.org>  Thu, 21 Nov 2024 11:54:02 +0100

postgresql-common (266) unstable; urgency=medium

  * pg_upgradecluster: Support upgrades to 18 with data checksums disabled.
  * Fix pg_backupcluster with data checksums enabled.

 -- Christoph Berg <myon@debian.org>  Thu, 14 Nov 2024 14:53:36 +0100

postgresql-common (265) unstable; urgency=medium

  * Add libipc-run-perl to postgresql-client-common depends for extension
    tests.

 -- Christoph Berg <myon@debian.org>  Mon, 21 Oct 2024 16:50:44 +0200

postgresql-common (264) unstable; urgency=medium

  * postgresql-all: Drop dependency on postgresql-contrib-*.
  * Remove remaining traces of python2 compatibility code.
  * debian/postgresql-common.tmpfile: Rename to .tmpfiles.
  * t/027_jit.t: Skip JIT tests in 11.
  * t/045_backup.t: Fix test running on 9.x without systemd.

 -- Christoph Berg <myon@debian.org>  Thu, 26 Sep 2024 14:06:48 +0200

postgresql-common (263) unstable; urgency=medium

  [ Christoph Berg ]
  * pg_buildext: Set PROVE_FLAGS=--verbose in installcheck.
  * debian/supported-versions: Add 17 as default version.
  * Most extension packages will now default to supporting only 64-bit
    architectures. Enable the pkg.postgresql.32-bit build profile to revert
    for local builds.

  [ Andreas Karlsson ]
  * pg_ctlcluster: Add logrotate action

 -- Christoph Berg <myon@debian.org>  Tue, 10 Sep 2024 13:03:32 +0200

postgresql-common (262) unstable; urgency=medium

  * Chown /var/tmp/postgresql-* to postgres so catversion bump instructions do
    not require root. Spotted by Greg Smith, thanks.
  * Ignore test results on powerpc.

 -- Christoph Berg <myon@debian.org>  Thu, 08 Aug 2024 16:37:01 +0200

postgresql-common (261) unstable; urgency=medium

  * server/postgresql.mk: Use --enable-dtrace only on Linux.
  * pg_createcluster: Internally set LC_NUMERIC=C to ensure version
    comparisons use '.' as separator.
  * t/045_backup.t: ALTER SYSTEM needs 9.4+.

 -- Christoph Berg <myon@debian.org>  Tue, 25 Jun 2024 14:04:23 +0200

postgresql-common (260) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Thu, 09 May 2024 17:10:04 +0200

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 <myon@debian.org>  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 <myon@debian.org>  Mon, 18 Mar 2024 17:10:46 +0100

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 <myon@debian.org>  Thu, 08 Feb 2024 13:32:31 +0100

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 <myon@debian.org>  Wed, 08 Nov 2023 16:25:17 +0100

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 <myon@debian.org>  Thu, 14 Sep 2023 10:35:53 +0200

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 <myon@debian.org>  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 <myon@debian.org>  Wed, 09 Aug 2023 11:51:21 +0200

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 <myon@debian.org>  Sat, 01 Jul 2023 20:45:40 +0200

postgresql-common (251) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  Tue, 14 Mar 2023 15:19:01 +0100

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 <myon@debian.org>  Thu, 09 Feb 2023 11:28:43 +0100

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. (Closes: #986186)
  * 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 <myon@debian.org>  Thu, 10 Nov 2022 15:06:56 +0100

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 <myon@debian.org>  Sat, 22 Oct 2022 14:46:03 +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 <myon@debian.org>  Fri, 14 Oct 2022 10:59:12 +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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  Wed, 11 May 2022 15:57:04 +0200

postgresql-common (240) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  Thu, 10 Feb 2022 11:02:57 +0100

postgresql-common (237) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Tue, 04 Jan 2022 11:44:42 +0100

postgresql-common (236) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Mon, 03 Jan 2022 16:19:56 +0100

postgresql-common (235) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Mon, 20 Dec 2021 18:13:44 +0100

postgresql-common (234) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Mon, 06 Dec 2021 10:51:35 +0100

postgresql-common (233) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Fri, 03 Dec 2021 09:50:31 +0100

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 <myon@debian.org>  Thu, 11 Nov 2021 17:17:49 +0100

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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  Wed, 12 May 2021 17:16:38 +0200

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 <myon@debian.org>  Tue, 02 Feb 2021 15:40:25 +0100

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 <myon@debian.org>  Thu, 14 Jan 2021 16:23:51 +0100

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 <myon@debian.org>  Thu, 12 Nov 2020 12:37:57 +0100

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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  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 <myon@debian.org>  Wed, 30 Sep 2020 21:54:23 +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 <myon@debian.org>  Wed, 12 Aug 2020 15:10:25 +0200

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 <myon@debian.org>  Thu, 14 May 2020 16:36:50 +0200

postgresql-common (214) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Thu, 27 Feb 2020 13:22:52 +0100

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 <myon@debian.org>  Mon, 24 Feb 2020 16:20:14 +0100

postgresql-common (212) unstable; urgency=medium

  * debian/supported-versions: Remove 9.4 support on apt.postgresql.org.

 -- Christoph Berg <myon@debian.org>  Tue, 11 Feb 2020 15:06:26 +0100

postgresql-common (211) unstable; urgency=medium

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

 -- Christoph Berg <myon@debian.org>  Mon, 27 Jan 2020 14:57:59 +0100

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 <myon@debian.org>  Thu, 14 Nov 2019 13:23:42 +0100

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 <myon@debian.org>  Thu, 07 Nov 2019 15:09:18 +0100

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.
    (Closes: #942307)

 -- Christoph Berg <myon@debian.org>  Mon, 28 Oct 2019 15:04:12 +0100

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 <myon@debian.org>  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 <myon@debian.org>  Thu, 12 Sep 2019 15:49:10 +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 <myon@debian.org>  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 <myon@debian.org>  Thu, 08 Aug 2019 12:48:00 +0200

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 <myon@debian.org>  Tue, 09 Jul 2019 16:16:57 +0200

# Older entries have been removed from this changelog.
# To read the complete changelog use `apt changelog postgresql-client-common`.
