Change log for postgresql-common package in Ubuntu

postgresql-common (181ubuntu1) artful; urgency=medium

  * debian/supported-versions: add Ubuntu 17.10.

 -- Nishanth Aravamudan <email address hidden>  Thu, 11 May 2017 15:41:35 -0700

Available diffs

• diff from 179 (in Debian) to 181ubuntu1 (2.9 KiB)
• diff from 181 (in Debian) to 181ubuntu1 (726 bytes)

postgresql-common (181) unstable; urgency=medium

  * debian/postgresql-common.config: Fix deprecation warning debconf message
    to use a numerical comparison on the version number.
  * pg_buildext: Fix to use a numerical comparison on the version number.
  * pg_buildext.pod: Drop outdated PG_VIRTUALENV_UNSHARE=-n documentation.
  * pgdg/apt.postgresql.org.sh: Add known distributions.
  * Updated Danish debconf translation by Joe Dalton, thanks!
    (Closes: #856787)

 -- Christoph Berg <email address hidden>  Sat, 15 Apr 2017 18:56:38 +0200

postgresql-common (179) unstable; urgency=medium

  * Catch all pg_ctl output by redirecting it to /var/log/postgresql.
    (Closes: #830485)
  * Dump locale environment variables if setlocale fails.
    (Closes: #848869)
  * Set default log_line_prefix to '%m [%p] %q%u@%d ' to match upstream
    moving to '%m [%p] ' in PostgreSQL 10.
  * Support include_dir in read_conf_file. Patch by Andreas Dewes, thanks!
  * Support adding include directives to the new postgresql.conf from
    createcluster.conf; harness directives with an "add_" prefix, e.g.
    "add_include_dir".
  * Import new apt.postgresql.org key.
  * Support 9.6 for jessie-backports.

 -- Christoph Berg <email address hidden>  Tue, 24 Jan 2017 23:03:12 +0100

Available diffs

• diff from 177git1 (in Ubuntu) to 179 (21.5 KiB)
• diff from 178 to 179 (12.0 KiB)

postgresql-common (178) unstable; urgency=medium

  [ Christoph Berg ]
  * pg_buildext: Don't ask pg_virtualenv for a new network namespace by
    default.
  * postgresql-all: New meta package depending on all server packages in all
    supported versions. Intended to be used for installing test dependencies.
  * pg_upgradecluster: Properly upgrade databases with non-login role owners.
    (Closes: #614374, #838812)
  * pg_upgradecluster, pg_renamecluster: Update cluster_name.
  * Rebuild upgrades libreadline to 7 in unstable. (Closes: #845356)
  * Replace most occurrences of "postmaster" by "postgres". Notable leftover
    is the postmaster.1.gz leader of the manpages alternatives group.
  * pg_ctlcluster, t/020_create_sql_remove.t: Protect against symlink in
    /var/log/postgresql/ allowing the creation of arbitrary files elsewhere.
    Discovered by Dawid Golunski, thanks!

  [ Martin Pitt ]
  * debian/supported-versions: Add Ubuntu 17.04, drop EOLed releases.
  * t/TestLib.pm, check_clean(): Quiesce stderr of netstat, which shows a "Not
    all processes could be identified" warning in unprivileged containers.

 -- Christoph Berg <email address hidden>  Tue, 20 Dec 2016 17:11:15 +0100

Available diffs

• diff from 177ubuntu1 (in Ubuntu) to 178 (10.7 KiB)

postgresql-common (177ubuntu1) zesty; urgency=medium

  * Update zesty to 9.6, as the Debian transition is well under way.

 -- Adam Conrad <email address hidden>  Sun, 18 Dec 2016 10:22:57 -0700

Available diffs

• diff from 177git1 to 177ubuntu1 (742 bytes)

postgresql-common (177git1) zesty; urgency=medium

  Upload current git master to fix supported version for zesty.

  [ Christoph Berg ]
  * pg_buildext: Don't ask pg_virtualenv for a new network namespace by
    default.
  * postgresql-all: New meta package depending on all server packages in all
    supported versions. Intended to be used for installing test dependencies.
  * pg_upgradecluster, pg_renamecluster: Update cluster_name.

  [ Martin Pitt ]
  * debian/supported-versions: Add Ubuntu 17.04.
  * t/TestLib.pm, check_clean(): Quiesce stderr of netstat, which shows a "Not
    all processes could be identified" warning in unprivileged containers.

 -- Martin Pitt <email address hidden>  Fri, 28 Oct 2016 15:08:21 +0200

Available diffs

• diff from 176+git1 to 177git1 (3.4 KiB)

postgresql-common (176+git1) yakkety; urgency=medium

  Upload current Debian packaging git to pick up bug fixes and dependency
  adjustment for libreadline7.

  * Replace hardcoded Recommends: libreadline6 with a build-time detection of
    the current ABI.

Available diffs

• diff from 175build1 to 176+git1 (12.2 KiB)
• diff from 175ubuntu1 to 176+git1 (12.2 KiB)

postgresql-common (175ubuntu1) yakkety; urgency=medium

  * Recommend libreadline7 instead of libreadline6.

 -- Matthias Klose <email address hidden>  Wed, 21 Sep 2016 18:16:49 +0200

Available diffs

• diff from 175build1 to 175ubuntu1 (506 bytes)

postgresql-common (175build1) yakkety; urgency=medium

  * No-change rebuild for readline soname change.

 -- Matthias Klose <email address hidden>  Sat, 17 Sep 2016 12:07:49 +0000

Available diffs

• diff from 175 (in Debian) to 175build1 (338 bytes)

postgresql-common (175) unstable; urgency=medium

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

 -- Christoph Berg <email address hidden>  Thu, 23 Jun 2016 12:26:27 +0200

Available diffs

• diff from 174 to 175 (4.7 KiB)

postgresql-common (174) unstable; urgency=medium

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

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

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

Available diffs

• diff from 173 to 174 (4.7 KiB)

postgresql-common (173) unstable; urgency=medium

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

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

 -- Christoph Berg <email address hidden>  Wed, 30 Mar 2016 15:08:06 +0200

Available diffs

• diff from 172ubuntu1 (in Ubuntu) to 173 (10.4 KiB)

postgresql-common (172ubuntu1) xenial; urgency=medium

  * pgcommon.sh: Adjust for >= xenial using Debian-style locale generation
    methods, and allow fallback to the old Ubuntu method for old releases.

 -- Adam Conrad <email address hidden>  Mon, 21 Mar 2016 12:36:25 -0600

Available diffs

• diff from 172 (in Debian) to 172ubuntu1 (986 bytes)

postgresql-common (172) unstable; urgency=medium

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

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

 -- Christoph Berg <email address hidden>  Thu, 07 Jan 2016 15:13:06 +0100

Available diffs

• diff from 171 to 172 (5.1 KiB)

postgresql-common (171) unstable; urgency=medium

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

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

 -- Christoph Berg <email address hidden>  Fri, 18 Dec 2015 16:22:37 +0100

Available diffs

• diff from 170 to 171 (29.5 KiB)

postgresql-common (170) unstable; urgency=medium

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

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

 -- Christoph Berg <email address hidden>  Thu, 08 Oct 2015 13:48:26 +0200

Available diffs

• diff from 169git1 (in Ubuntu) to 170 (16.1 KiB)

postgresql-common (169git1) wily; urgency=medium

  Upload current git head to fix autopkgtest regression.

  [ Christoph Berg ]
  * t/025_logging.t: Improve syslog detection in the test environment.
  * pg_upgradecluster, t/030_errors.t: Unbreak after we changed the old=new
    error message.
  * PgCommon.pm: make read_cluster_conf_file read postgresql.auto.conf as well
    (Closes: #787154)

 -- Martin Pitt <email address hidden>  Sat, 06 Jun 2015 12:16:06 +0200

Available diffs

• diff from 168 (in Debian) to 169git1 (5.4 KiB)
• diff from 169 (in Debian) to 169git1 (1.9 KiB)

postgresql-common (169) unstable; urgency=medium

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

 -- Christoph Berg <email address hidden>  Thu, 04 Jun 2015 12:09:53 +0200

Available diffs

• diff from 168 to 169 (4.2 KiB)

postgresql-common (168) unstable; urgency=medium

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

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

 -- Christoph Berg <email address hidden>  Thu, 21 May 2015 11:28:45 +0200

Available diffs

• diff from 167 to 168 (2.0 KiB)

postgresql-common (167) unstable; urgency=medium

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

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

 -- Martin Pitt <email address hidden>  Wed, 06 May 2015 11:28:26 +0200

Available diffs

• diff from 166bzr2 (in Ubuntu) to 167 (1022 bytes)

postgresql-common (166bzr2) vivid; urgency=medium

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

  [ Martin Pitt ]
  * debian/maintscripts-functions: Avoid package installation failure of -9.1
    due to the pg_basebackup.1 alternative on systems which have both -9.1 and
    a later version installed in parallel. On those, pg_basebackup.1 will
    already be in the psql.1.gz group, thus -9.1 must not try to put it back
    into the postmaster.1.gz group. (LP: #1357682)
  * Add "default-psql" autopkgtest: Smoketest to verify that installing the
    "postgresql" metapackage results in a running and working cluster.
  * debian/maintscripts-functions, configure_cluster(): When running under
    systemd, do a daemon-reload to re-run the generator and thus create a unit
    for the newly created cluster.
 -- Martin Pitt <email address hidden>   Tue, 10 Mar 2015 11:26:36 +0100

Available diffs

• diff from 166bzr1 to 166bzr2 (1.2 KiB)

postgresql-common (154ubuntu1) trusty-proposed; urgency=medium

  * debian/maintscripts-functions: Avoid package installation failure of -9.1
    due to the pg_basebackup.1 alternative on systems which have both -9.1 and
    a later version installed in parallel. On those, pg_basebackup.1 will
    already be in the psql.1.gz group, thus -9.1 must not try to put it back
    into the postmaster.1.gz group. (LP: #1357682)
 -- Martin Pitt <email address hidden>   Mon, 16 Feb 2015 12:35:43 +0100

Available diffs

• diff from 154 (in Debian) to 154ubuntu1 (1.1 KiB)

postgresql-common (166bzr1) vivid; urgency=medium

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

  [ Martin Pitt ]
  * debian/maintscripts-functions: Avoid package installation failure of -9.1
    due to the pg_basebackup.1 alternative on systems which have both -9.1 and
    a later version installed in parallel. On those, pg_basebackup.1 will
    already be in the psql.1.gz group, thus -9.1 must not try to put it back
    into the postmaster.1.gz group. (LP: #1357682)
 -- Martin Pitt <email address hidden>   Mon, 16 Feb 2015 12:31:20 +0100

Available diffs

• diff from 166 (in Debian) to 166bzr1 (1.8 KiB)

postgresql-common (166) unstable; urgency=medium


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

 -- Christoph Berg <email address hidden>  Thu, 05 Feb 2015 22:19:07 +0100

Available diffs

• diff from 165 to 166 (9.2 KiB)

postgresql-common (165) unstable; urgency=medium


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

 -- Christoph Berg <email address hidden>  Sun, 04 Jan 2015 18:51:31 +0100

Available diffs

• diff from 164 to 165 (2.8 KiB)

postgresql-common (164) unstable; urgency=medium


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

 -- Christoph Berg <email address hidden>  Wed, 17 Dec 2014 20:00:04 +0100

Available diffs

• diff from 163 (in Ubuntu) to 164 (3.5 KiB)

postgresql-common (163) unstable; urgency=medium

  [ Martin Pitt ]
  * pg_createcluster: Disable copy-on-write semantics for data directory on
    btrfs and similar file systems. It eats a lot of performance and isn't
    necessary for data integrity.
  * debian/supported-versions: Welcome Ubuntu 15.04!

  [ Christoph Berg ]
  * Update VCS URLs.
 -- Martin Pitt <email address hidden>   Sun, 26 Oct 2014 07:04:48 -0400

Available diffs

• diff from 162 (in Debian) to 163 (1.1 KiB)

postgresql-common (162) unstable; urgency=medium


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

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

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

 -- Christoph Berg <email address hidden>  Tue, 07 Oct 2014 21:25:25 +0200

Available diffs

• diff from 161 to 162 (5.6 KiB)

postgresql-common (161) unstable; urgency=medium


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

 -- Christoph Berg <email address hidden>  Fri, 15 Aug 2014 10:13:51 +0200

Available diffs

• diff from 160 to 161 (6.3 KiB)

postgresql-common (160) unstable; urgency=medium


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

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

 -- Christoph Berg <email address hidden>  Mon, 11 Aug 2014 15:39:39 +0200

Available diffs

• diff from 159bzr1 (in Ubuntu) to 160 (3.8 KiB)

postgresql-common (159bzr1) utopic; urgency=medium

  * supported-versions: Set 9.4 as default for Ubuntu 14.10.
 -- Martin Pitt <email address hidden>   Mon, 28 Jul 2014 07:13:30 +0200

Available diffs

• diff from 159 (in Debian) to 159bzr1 (508 bytes)

postgresql-common (159) unstable; urgency=low


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

 -- Christoph Berg <email address hidden>  Thu, 24 Jul 2014 11:52:57 +0200

Available diffs

• diff from 157 to 159 (30.9 KiB)

postgresql-common (157) unstable; urgency=medium


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

 -- Christoph Berg <email address hidden>  Fri, 30 May 2014 21:31:36 +0200

Available diffs

• diff from 156 to 157 (1.4 KiB)

postgresql-common (156) unstable; urgency=medium


  [ Christoph Berg ]
  * pg_upgradecluster: Add missing psql -p argument when determining the
    number of tablespaces in the old cluster.
  * Link pg_archivecleanup from /usr/bin. (Closes: #740593)
  * pg_virtualenv: Use fsync = off for speed.
  * pg_buildext: Pass -cios options to pg_virtualenv.
  * t/140_pg_config.t: Versions >= 9.3 have multiarch-enabled libpq et al.

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

 -- Christoph Berg <email address hidden>  Fri, 30 May 2014 00:00:44 +0200

Available diffs

• diff from 155 to 156 (3.7 KiB)

postgresql-common (155) unstable; urgency=medium


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

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

 -- Christoph Berg <email address hidden>  Wed, 21 May 2014 17:34:09 +0200

Available diffs

• diff from 154bzr1 (in Ubuntu) to 155 (24.4 KiB)

postgresql-common (154bzr1) utopic; urgency=medium

  * supported-versions: Welcome, Ubuntu 14.10!
 -- Martin Pitt <email address hidden>   Sat, 26 Apr 2014 19:58:45 +0200

Available diffs

• diff from 154 (in Debian) to 154bzr1 (435 bytes)

postgresql-common (154) unstable; urgency=medium


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

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

 -- Christoph Berg <email address hidden>  Fri, 21 Feb 2014 08:18:46 +0100

Available diffs

• diff from 153bzr1 (in Ubuntu) to 154 (2.2 KiB)

postgresql-common (153bzr1) trusty; urgency=medium

  Upload current Debian packaging git to fix upgrade failure from precise.

  * debian/postgresql-common.preinst: Drop obsolete upgrade migration.
  * debian/maintscripts-functions, _link_manpages(): The move of pg_basebackup
    from server to client still affects upgrades from -9.1 to -9.3. Place the
    upgrade fix here instead of postgresql-9.1.preinst (which does not exist
    any more now). (LP: #1270597)
 -- Martin Pitt <email address hidden>   Wed, 12 Feb 2014 13:44:42 +0100

Available diffs

• diff from 153 (in Debian) to 153bzr1 (1.8 KiB)

postgresql-common (153) unstable; urgency=medium


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

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

 -- Christoph Berg <email address hidden>  Thu, 06 Feb 2014 15:21:00 +0100

Available diffs

• diff from 152 to 153 (14.5 KiB)

postgresql-common (152) unstable; urgency=low


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

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

 -- Martin Pitt <email address hidden>  Thu, 09 Jan 2014 10:56:12 +0100

Available diffs

• diff from 151 to 152 (2.9 KiB)

postgresql-common (151) unstable; urgency=low


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

 -- Christoph Berg <email address hidden>  Thu, 05 Dec 2013 16:32:51 +0100

Available diffs

• diff from 150 to 151 (1.3 KiB)

postgresql-common (150) unstable; urgency=low


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

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

 -- Martin Pitt <email address hidden>  Mon, 21 Oct 2013 22:08:20 +0200

Available diffs

• diff from 148 to 150 (2.2 KiB)
• diff from 149 to 150 (897 bytes)

postgresql-common (149) unstable; urgency=low


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

 -- Christoph Berg <email address hidden>  Mon, 09 Sep 2013 14:15:18 +0200

postgresql-common (148) unstable; urgency=low


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

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

 -- Martin Pitt <email address hidden>  Tue, 27 Aug 2013 11:07:48 +0200

Available diffs

• diff from 146 to 148 (6.0 KiB)

postgresql-common (146) unstable; urgency=low


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

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

 -- Christoph Berg <email address hidden>  Tue, 16 Jul 2013 16:11:35 +0200

Available diffs

• diff from 145 to 146 (4.3 KiB)

postgresql-common (145) unstable; urgency=low


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

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

 -- Christoph Berg <email address hidden>  Mon, 10 Jun 2013 17:01:01 +0200

Available diffs

• diff from 144 to 145 (2.0 KiB)

postgresql-common (144) unstable; urgency=low


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

 -- Christoph Berg <email address hidden>  Fri, 31 May 2013 21:37:47 -0700

Available diffs

• diff from 143 to 144 (6.6 KiB)

postgresql-common (143) unstable; urgency=low


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

 -- Martin Pitt <email address hidden>  Fri, 10 May 2013 17:53:49 +0200

Available diffs

• diff from 142 to 143 (888 bytes)

postgresql-common (142) unstable; urgency=low


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

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

 -- Martin Pitt <email address hidden>  Tue, 07 May 2013 11:11:58 +0200

Available diffs

• diff from 140 to 142 (24.8 KiB)

postgresql-common (140) experimental; urgency=low


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

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

 -- Christoph Berg <email address hidden>  Thu, 31 Jan 2013 10:36:41 +0100

Available diffs

• diff from 139 to 140 (8.8 KiB)

postgresql-common (139) experimental; urgency=low


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

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

 -- Christoph Berg <email address hidden>  Sun, 06 Jan 2013 10:24:49 +0100

Available diffs

• diff from 138 to 139 (9.2 KiB)

postgresql-common (138) experimental; urgency=low


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

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

 -- Martin Pitt <email address hidden>  Sun, 16 Dec 2012 18:57:12 +0100

Available diffs

• diff from 137 to 138 (861 bytes)

postgresql-common (137) experimental; urgency=low


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

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

 -- Martin Pitt <email address hidden>  Sat, 15 Dec 2012 21:32:30 +0100

Available diffs

• diff from 136build1 (in Ubuntu) to 137 (13.2 KiB)

postgresql-common (136build1) raring; urgency=low

  * Rebuild against logrotate 3.8.  No source changes.
 -- Colin Watson <email address hidden>   Wed, 28 Nov 2012 13:14:16 +0000

Available diffs

• diff from 136 to 136build1 (342 bytes)

postgresql-common (136) experimental; urgency=low

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

  [ Christoph Berg ]
  * pg_buildext: Fix supported-versions not to die when the last version is
    not supported.
  * testsuite: Add getopt handling, and make the list of umasks to loop
    through configurable (-u).
  * t/001_packages.t: Print list of installed versions for information.
  * As debian/supported-versions is also used at build-time, add a
    build-dependency on lsb-release for lsb_release to be available. Also,
    print supported versions from debian/rules for easier debugging.
 -- Martin Pitt <email address hidden>   Thu, 20 Sep 2012 09:04:26 +0200

Available diffs

• diff from 135 (in Debian) to 136 (4.4 KiB)

postgresql-common (106ubuntu3) lucid-proposed; urgency=low

  * pg_ctlcluster: Drop erroneous $result assignment which was introduced in
    the previous version due to a mis-merge.

Available diffs

• diff from 106ubuntu1 to 106ubuntu3 (849 bytes)
• diff from 106ubuntu2 to 106ubuntu3 (587 bytes)

postgresql-common (106ubuntu2) lucid-proposed; urgency=low

  * pg_ctlcluster: Do not remove the PID file after SIGKILLing the
    postmaster in the "last-ditch effort to shut down" in --force mode. This
    is a potentially dangerous thing to do when trying to start a second
    postmaster in parallel while the first one is still being shut down.
    (see http://archives.postgresql.org/pgsql-general/2012-07/msg00475.php)
    Patch taken from trunk r1181. (LP: #1042556)
 -- Martin Pitt <email address hidden>   Thu, 06 Sep 2012 15:13:49 +0200

Available diffs

• diff from 106ubuntu1 to 106ubuntu2 (774 bytes)

postgresql-common (129ubuntu1) precise-proposed; urgency=low

  * pg_ctlcluster: Do not remove the PID file after SIGKILLing the
    postmaster in the "last-ditch effort to shut down" in --force mode. This
    is a potentially dangerous thing to do when trying to start a second
    postmaster in parallel while the first one is still being shut down.
    (see http://archives.postgresql.org/pgsql-general/2012-07/msg00475.php)
    Backported from trunk r1181. (LP: #1042556)
  * debian/control: Update Vcs-* for new precise branch.
 -- Martin Pitt <email address hidden>   Thu, 06 Sep 2012 15:01:02 +0200

Available diffs

• diff from 129 to 129ubuntu1 (1006 bytes)

postgresql-common (135) experimental; urgency=low


  [ Martin Pitt ]
  * pg_createcluster: For 9.2 and higher, use the new ssl_{cert,key}_file
    options instead of creating symlinks in the data directory.
    (Closes: #680162)
  * pg_upgradecluster: Set above options to the old cluster's SSL cert/key
    symlink destinations, if they exist.
  * debian/maintscripts-functions: Configure alternatives for manpages in
    -contrib. This will only take effect after (re)installing
    postgresql-contrib-9.2. (Closes: #680571)
  * debian/postgresql-common.postgresql.init: Fix "status" output to be more
    useful and legible, and exit with code 3 if any cluster is down.
    (Closes: #656363)
  * debian/postgresql-common.postgresql.init: Show a warning message if no
    clusters exist. (Closes: #677604)
  * t/041_upgrade_custompaths.t: Run test with a cluster that is down, to
    verify that pg_upgradecluster works for non-running clusters, too.
  * pg_upgradecluster: Move encoding detection after restarting the cluster
    with restricted connections, and drop the check that the cluster is
    running. With this, pg_upgradecluster also works for clusters which are
    not running. (Closes: #681344)

  [ Peter Eisentraut ]
  * pg_createcluster: For PostgreSQL >= 9.2, use initdb options to set the
    default authentication methods, instead of modifying the configuration
    file directly. (Closes: #685043)

 -- Martin Pitt <email address hidden>  Fri, 17 Aug 2012 15:28:35 +0200

Available diffs

• diff from 134 (in Ubuntu) to 135 (3.9 KiB)

postgresql-common (134) unstable; urgency=low

  * debian/backport-ppa: Fix syntax error.
  * PgCommon.pm: Drop unconditional import of Socket::IN6ADDR_ANY and only do
    the IPv6 check if it is available. This keeps this version backwards
    compatible with Debian/Ubuntu releases with older Perl versions.
 -- Martin Pitt <email address hidden>   Thu, 26 Jul 2012 21:29:48 +0200

Available diffs

• diff from 133 to 134 (1.1 KiB)

postgresql-common (133) unstable; urgency=low

  [ Christoph Berg ]
  * Add .bzrignore file.
  * PgCommon.pm: Check IPv4 and IPv6 in next_free_port(). (Closes: #678858)

  [ Peter Eisentraut ]
  * debian/control: Add myself to Uploaders.
  * debian/postgresql-common.lintian-overrides: Remove unused
    binary-without-manpage overrides (files were moved to
    postgresql-client-common package).
  * debian/rules: Catch errors in for loops.
  * pg_wrapper: Avoid Perl warnings if psql is linked against libreadline
    instead of libedit, even though that is not standard anymore.
  * testsuite: Reset core limit for pg_ctl tests.
  * testsuite: Allow running individual tests by passing them on the
    command line.

  [ Martin Pitt ]
  * pg_ctlcluster: Do not remove the PID file after SIGKILLing the
    postmaster in the "last-ditch effort to shut down" in --force mode. This
    is a potentially dangerous thing to do when trying to start a second
    postmaster in parallel while the first one is still being shut down.
    (see http://archives.postgresql.org/pgsql-general/2012-07/msg00475.php)
 -- Martin Pitt <email address hidden>   Thu, 26 Jul 2012 13:20:10 +0200

Available diffs

• diff from 132 (in Debian) to 133 (3.2 KiB)

postgresql-common (132) unstable; urgency=low


  [ Martin Pitt ]
  * debian/control: Add XS-Testsuite: header, as per current DEP-8.
  * debian/tests/control: Drop undefined "no-build-needed" feature.

  [ Christoph Berg ]
  * Recognize "online,recovery" clusters in init script. (Closes: #678936)
    Spotted by Gilbert Roulot.

 -- Christoph Berg <email address hidden>  Sat, 30 Jun 2012 21:31:49 +0200

Available diffs

• diff from 131bzr1 (in Ubuntu) to 132 (838 bytes)

postgresql-common (131bzr1) quantal; urgency=low

  Upload current Debian packaging bzr.

  * debian/control: Add XS-Testsuite: header, as per current DEP-8.
  * debian/tests/control: Drop undefined "no-build-needed" feature.
 -- Martin Pitt <email address hidden>   Thu, 21 Jun 2012 08:12:13 +0200

Available diffs

• diff from 131 to 131bzr1 (711 bytes)

postgresql-common (131) unstable; urgency=low

  [ Martin Pitt ]
  * debian/backport-ppa: Adjust for lucid, build -9.2 for oneiric as well.
  * debian/control: Move bzr branches to alioth, so that other members of
    pkg-postgresql can commit. Update Vcs-* tags.
  * debian/control: Set Maintainer: to pkg-postgresql group, and move myself
    to Uploaders:.
  * debian/README.Devel: Update for moved packaging branches.
  * debian/backport-ppa: Disable dpkg 1.16.2 build dependency for natty as
    well.
  * debian/tests/control: Drop "breaks-computer" restriction. While DEP-8
    mentions it, autopkgtest does not understand it yet and skips the test.
  * debian/tests/system: Run testsuite under en_US.UTF-8, as autopkgtests sets
    it to C by default.
  * t/180_ecpg.t: Ensure that test.pgc is readable for nobody.
  * debian/tests/system: Run the packaged tests instead of the ones in the
    local build tree.
  * debian/tests/system: Unset $TMPDIR so that 'postgres' and 'nobody' do not
    fall over the autopkgtest provided $TMPDIR which is not world writable.
  * t/030_errors.t: Fix nonzero exit code which caused stderr output.

  [ Christoph Berg ]
  * pg_buildext: Also set DESTDIR and VPATH for the configure, build and clean
    targets.
  * Add myself to Uploaders.
 -- Martin Pitt <email address hidden>   Tue, 19 Jun 2012 19:26:12 +0200

Available diffs

• diff from 130 (in Debian) to 131 (3.6 KiB)

postgresql-common (130) unstable; urgency=low


  [ Christoph Berg ]
  * pg_ctlcluster: Add 'promote' action.
  * pg_updatedicts: Fix a typo.
  * pg_lsclusters, PgCommon.pm: Show "recovery" in status column.
  * pg_createcluster: Fix a doc typo.

  [ Martin Pitt ]
  * Add support for 9.2:
    - pg_createcluster: Add 9.2 configuration method.
    - t/060_obsolete_confparams.t: Add full configuration for 9.1 to test the
      configuration update to 9.2.
    - pg_upgradecluster: On upgrades to 9.2, deprecate the 'wal_sender_delay',
      'silent_mode', and 'custom_variable_classes' postgresql.conf options, as
      they do not exist any more.
    - pg_upgradecluster: In the tablespace test, don't query the "spclocation"
      column, which does not exist any more in 9.2. Just check whether we have
      any table space other than the two default ones.
    - t/050_encodings.t: Adjust expected "invalid UTF-8" error to also match
      the 9.2 format.
    - t/170_extensions.t: Adjust the "hstore" exfail to only apply to 9.1.
      9.2's version works without a warning.
  * debian/backport-ppa: Update Ubuntu releases.

 -- Martin Pitt <email address hidden>  Tue, 15 May 2012 13:44:17 +0200

Available diffs

• diff from 129 (in Ubuntu) to 130 (5.3 KiB)

postgresql-common (129) unstable; urgency=low

  * pg_ctlcluster: Fix wrong configuration file name in documentation, thanks
    Peter Eisentraut. (Closes: #653098)
  * t/050_encodings.t: Add alternative Russian translation for expected error
    message, to match against what 9.1.3 has.
  * debian/copyright: Update to official 1.0 format.
  * debian/control: Bump Standards-Version to 3.9.3.
 -- Martin Pitt <email address hidden>   Tue, 06 Mar 2012 12:00:12 +0100

Available diffs

• diff from 128 to 129 (1.5 KiB)

postgresql-common (128) unstable; urgency=low

  * debian/backport-ppa: Make this work for postgresql-X.Y packages, too.
  * debian/postgresql-client-common.links: Wrap pg_basebackup.
    (Closes: #647224)
  * pg_buildext: Fix wrong exit code if "pgversions" does not exist.
    (Closes: #646698)
  * pgxs_debian_control.mk: Some robustifications: Write to temporary control
    file first and rename only after everything succeeds, otherwise delete it.
    Catch errors from pg_buildext and abort the build. (Closes: #646702)
  * pg_buildext, pg_buildext.pod: If second parameter (srcdir) is not
    specified, assume the current directory. (Closes: #646712, part 1)
  * pgxs_debian_control.mk: Drop $(SRCDIR) requirement so that this doesn't
    need to be set separately. Just use $(CURDIR). (Closes: #646712, part 2)
 -- Ubuntu Archive Auto-Sync <email address hidden>   Tue,  03 Jan 2012 02:35:20 +0000

Available diffs

• diff from 127 to 128 (1.8 KiB)

postgresql-common (127) unstable; urgency=low

  * debian/backport-ppa: Add oneiric.
  * logrotate 3.8 landed in unstable, rebuild against this to get a proper
    logrotate config snippet and adjust the depends/breaks. (See Debian
    #640493)
  * debian/rules: Fix logrotate dependency generation logic to only consider
    the most recent logrotate version.
 -- Ubuntu Archive Auto-Sync <email address hidden>   Fri,  16 Dec 2011 16:27:20 +0000

Available diffs

• diff from 126 to 127 (1.1 KiB)

postgresql-common (126) unstable; urgency=low

  * pg_ctlcluster: Prefer setting oom_score_adj over oom_adj, as the latter is
    deprecated. (Closes: #646096)
  * Add debian/tests/{control,system}: DEP-8/autopkgtest control files for
    running the integration tests.
  * t/020_create_sql_remove.t: Set stdin for forked psql process, so that the
    test suite run does not need a defined stdin.
  * debian/control: Clean up metapackage descriptions. (Closes: #649400)
 -- Martin Pitt <email address hidden>   Fri, 25 Nov 2011 11:20:29 +0100

Available diffs

• diff from 125 (in Debian) to 126 (2.3 KiB)

postgresql-common (125) unstable; urgency=low


  * Add debian/backport-ppa: Script to generate and upload backport packages
    to my Ubuntu PPA. Only for personal use.
  * Add t/160_alternate_confroot.t: Test creation, operation, upgrading, and
    removal of clusters as user nobody using $PG_CLUSTER_CONF_ROOT. This
    reproduces LP#835630 and other bugs.
  * PgCommon.pm: If $PG_CLUSTER_CONF_ROOT is set, untaint it.
  * pg_upgradecluster: Don't hardcode /etc/postgresql/, use
    $PgCommon::confroot to respect $PG_CLUSTER_CONF_ROOT. (LP: #835630)
  * pg_upgradecluster: Add --logfile option to specify a custom log file for
    the upgraded cluster. Necessary if you want to run this on
    per-user clusters and can't write into /var/log/postgresql/.
  * pg_ctlcluster: When starting as root for >= 9.1, adjust the OOM killer
    protection to -16, so that the postmaster does not get OOM-killed so
    easily (as it appears to claim all the shared memory). 9.1.1-3 and later
    resets oomadj of child processes to 0, so that the client backends can
    still get OOM-killed. Add tests to t/020_create_sql_remove.t.
    (LP: #854590)
  * debian/control: Add Breaks: to postgresql-9.1 versios before 9.1.1-3, as
    they do not reset oomadj for child processes. This is a precaution to
    avoid running all the client backends with -16 as well.
  * Add t/170_extensions.t: Check that all shipped extensions install and
    remove.
  * Add t/180_ecpg.t: Check that ecpg works. In t/001_packages.t, check that
    libecpg-dev is installed.

 -- Martin Pitt <email address hidden>  Thu, 20 Oct 2011 12:17:30 +0200

postgresql-common (122ubuntu1) oneiric-proposed; urgency=low

  * pg_wrapper: Disable searching of multiarched libreadline. libreadline is
    not multiarched yet in oneiric, so this is not yet necessary. The complete
    fix in version 124 is more intrusive and not appropriate/necessary for an
    SRU. (LP: #860552)
 -- Martin Pitt <email address hidden>   Wed, 12 Oct 2011 07:28:42 +0200

Available diffs

• diff from 122 to 122ubuntu1 (757 bytes)

postgresql-common (124) unstable; urgency=medium


  * Keeping urgency medium, as 123 did not make it into testing yet.
  * PgCommon.pm, cluster_info(): Use /bin/ps instead of reading /proc/*/comm,
    the latter was reported to not work on some systems.
  * pg_ctlcluster: Use PgCommon::check_pidfile_running and drop duplicated
    code.
  * pg_wrapper: The previous multiarch globbing was wrong, as it looked for
    the architecture in uname() (which doesn't work on i386, where uname says
    i686). Now get the multiarch library path from whereever psql expects
    libedit.so to be, so that this even works if you install postgresql-client
    for a foreign architecture.

 -- Martin Pitt <email address hidden>  Sat, 08 Oct 2011 11:48:46 +0200

postgresql-common (122) unstable; urgency=low

  * debian/control: Fix duplicate package description. (Closes: #639562)
  * debian/control: Add lsb-release dependency to -server-dev-all, as the
    pg_buildext tool needs it.
  * pg_wrapper: Find libreadline in multiarch directory, too.
    (Closes: #640520)
  * debian/rules: logrotate 3.8.0 requires specifying the "su" option, which
    is not backportable. Dynamically check the available logrotate version,
    and add it if it is >= 3.8. Also dynamically generate a dependency or
    breaks to logrorate 3.8+. (Closes: #640493)
  * PgCommon.pm: Allow '@' characters in LC_CTYPE/LC_COLLATE values. Thanks to
    Willi Mann for the patch. (Closes: #640031)
  * pg_upgradecluster: Print message for running the upgrade.d scripts, thanks
    Karsten Hilbert.
  * t/040_upgrade.t: Add test case for a database with read only default
    transactions. Reproduces #599085.
  * pg_upgradecluster: Set superuser configuration value of
    'default_transaction_read_only' to 'off' during the upgrade, so that
    upgrading databases with read only default transactions actually works.
    Thanks Karsten Hilbert for the suggestion. (Closes: #599085)
  * t/040_upgrade.t, pg_upgradecluster: Consistently use upper case for SQL
    keywords.
  * Correct wrong bug reference in previous changelog.
 -- Martin Pitt <email address hidden>   Sun, 25 Sep 2011 21:38:20 +0200

Available diffs

• diff from 121bzr1 to 122 (5.2 KiB)

postgresql-common (121bzr1) oneiric; urgency=low

  Upload current Debian packaging bzr, to fix postgresql-pljava FTBFS.

  * debian/control: Fix duplicate package description. (Closes: #639562)
  * debian/control: Add lsb-release dependency to -server-dev-all, as the
    pg_buildext tool needs it.
 -- Martin Pitt <email address hidden>   Tue, 06 Sep 2011 16:33:12 +0200

Available diffs

• diff from 121 to 121bzr1 (769 bytes)

postgresql-common (121) unstable; urgency=low

  [ Martin Pitt ]
  * debian/supported-versions: Switch Ubuntu 11.10 to 9.1 (LP: #833684) and
    also preemtively add Ubuntu 12.04 (which will ship with 9.1, too).
  * debian/control: Bump Standards-Version to 3.9.2, no changes necessary.
  * debian/rules: Call dh_installinit with -r to avoid restarting on upgrade.
    (Closes: #639140)
  * debian/control: Wrap dependencies.
  * debian/control, debian/rules: Convert from cdbs to dh, and bump
    Standards-Version to 7.
  * debian/control, debian/rules: Build the versionless metapackages from this
    source instead of the current postgresql-X.Y source. This behaves better
    with backports. Thanks to Christoph Berg for the suggestion.
  * debian/postgresql-common.lintian-overrides: Don't complain about missing
    manpage for pg_config, it's shipped by libpq-dev.
  * debian/control: Update description of the metapackages to actually say
    "metapackage" to quiesce lintian.
  * Split POD of pg_buildext into pg_buildext.pod, and update debian/rules to
    build the manpage from there. Fixes lintian "shell syntax failure"
    error.

  [ Peter Eisentraut ] 
  * pg_createcluster:
    - Use "peer" instead of "ident" on local socket connections from 9.1 on.
    - Apply pg_hba.conf adjustments to replication connections as well.
    - (Closes: #632702)
 -- Martin Pitt <email address hidden>   Thu,  01 Sep 2011 15:19:29 +0000

Available diffs

• diff from 120+bzr1 to 121 (4.6 KiB)