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`.
Generated by dwww version 1.16 on Tue Dec 16 06:45:58 CET 2025.