Author: Martin Pitt
Revision Date: 2015-06-06 12:16:06 UTC

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)

Author: Martin Pitt
Revision Date: 2015-06-06 12:16:06 UTC

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)

Author: Martin Pitt
Revision Date: 2015-02-16 12:35:43 UTC

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)

Author: Martin Pitt
Revision Date: 2015-03-10 11:26:36 UTC

[ 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.

Author: Martin Pitt
Revision Date: 2015-03-10 11:26:36 UTC

[ 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.

Author: Martin Pitt
Revision Date: 2015-02-16 12:35:43 UTC

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)

Author: Christoph Berg
Revision Date: 2014-10-07 21:25:25 UTC

[ 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)

Author: Christoph Berg
Revision Date: 2014-10-07 21:25:25 UTC

[ 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)

Author: Christoph Berg
Revision Date: 2014-02-21 08:18:46 UTC

[ 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.

Author: Martin Pitt
Revision Date: 2013-08-27 11:07:48 UTC

[ 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.

Author: Martin Pitt
Revision Date: 2013-08-27 11:07:48 UTC

[ 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.

Author: Christoph Berg
Revision Date: 2013-01-31 10:36:41 UTC

[ 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).

Author: Christoph Berg
Revision Date: 2013-01-31 10:36:41 UTC

[ 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).

Author: Martin Pitt
Revision Date: 2012-09-06 15:01:02 UTC

* 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.

Author: Martin Pitt
Revision Date: 2012-09-20 09:04:26 UTC

[ 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.

Author: Martin Pitt
Revision Date: 2012-09-18 08:05:03 UTC

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

Author: Martin Pitt
Revision Date: 2012-09-18 08:05:03 UTC

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

Author: Martin Pitt
Revision Date: 2012-09-06 15:01:02 UTC

* 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.

Author: Martin Pitt
Revision Date: 2012-03-06 12:00:12 UTC

* 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.

Author: Martin Pitt
Revision Date: 2011-10-12 07:28:42 UTC

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)

Author: Martin Pitt
Revision Date: 2011-10-12 07:28:42 UTC

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)

Author: Martin Pitt
Revision Date: 2011-09-25 20:10:26 UTC

* 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.

Author: Martin Pitt
Revision Date: 2011-02-13 22:28:33 UTC

* debian/supported-versions: Add Ubuntu 11.04. Drop versions which are newer
  than the ones supported in the released versions, as backports are now
  generally accepted by our .config scripts, but having those newer versions
  confuses pg_buildext.
* debian/postgresql-common.config: Silence warning from --compare-versions
  when being called through a trigger and $2 is not a version number.
  This works around the underlying dpkg problem. (Closes: #608522)
* Add debian/postgresql-common.sysctl: sysctl.d/ template for changing
  kernel.shmmax and kernel.shmall, which is very common with PostgreSQL.
  Install it in debian/rules. Thanks to Peter Eisentraut for the suggestion!
  (Closes: #607946)
* testsuite: Take new unified init script into account when stopping
  existing clusters. Thanks Steve Beattie! (LP: #712200)
* pg_wrapper: If libreadline is installed, LD_PRELOAD this for "psql", to
  avoid using the rather broken libedit. We need to build the postgresql-X.Y
  packages against libedit for license reasons (#603599), but as libreadline
  has a drop-in compatible ABI, this works around the licensing
  restrictions. Thanks to Andreas Barth for working this out! Add a
  recommends to libreadline6. (Closes: #608442, #607907, #607109, #611918)

Author: Martin Pitt
Revision Date: 2011-01-03 10:16:55 UTC

Backport current version to hardy, as the current postgresql-8.4 backport
needs this newer version. Drop debian/source/format, as hardy does not yet
support 3.0 sources. (LP: #693157)

Author: Martin Pitt
Revision Date: 2010-10-18 11:09:35 UTC

* t/030_errors.t: Check that pg_createcluster leaves the original one
  intact if the cluster already exists, also when the original one is not
  running. This reproduces LP #661061/Debian #597097.
* pg_createcluster: Be more careful with cleaning up the created cluster if
  an error occurs: Do not start the cleanup until we actually passed our
  sanity checks and created files for the new cluster. Before, it would
  erroneously remove an already existing cluster on a sanity check fail, if
  that cluster happened to not be running at the time. (LP: #661061)
  Patches cherrypicked from trunk r1024.

Author: Martin Pitt
Revision Date: 2010-10-18 11:09:35 UTC

* t/030_errors.t: Check that pg_createcluster leaves the original one
  intact if the cluster already exists, also when the original one is not
  running. This reproduces LP #661061/Debian #597097.
* pg_createcluster: Be more careful with cleaning up the created cluster if
  an error occurs: Do not start the cleanup until we actually passed our
  sanity checks and created files for the new cluster. Before, it would
  erroneously remove an already existing cluster on a sanity check fail, if
  that cluster happened to not be running at the time. (LP: #661061)
  Patches cherrypicked from trunk r1024.

Author: Martin Pitt
Revision Date: 2010-09-22 12:04:00 UTC

* Urgency high since this fixes two RC bugs.
* t/030_errors.t: Check that pg_createcluster leaves the original one intact
  if the cluster already exists, also when the original one is not running.
  This reproduces #597097.
* pg_createcluster: Be more careful with cleaning up the created cluster if
  an error occurs: Do not start the cleanup until we actually passed our
  sanity checks and created files for the new cluster. Before, it would
  erroneously remove an already existing cluster on a sanity check fail, if
  that cluster happened to not be running at the time. (Closes: #597097)
* debian/supported-versions: Be more robust against lsb_release failing, e.
  g. in the case where it is not fully configured yet. (Closes: #597561)
* debian/supported-versions: Drop check for /etc/debian_version if
  lsb_release is not working/existing. Derivatives have debian_version as
  well, and we don't actually evaluate it, so just print a meaningful error
  message and go with the default versions.
* debian/rules: Put init script priority back to S29/K21 to match the
  previous postgresql-8.4 init script. Fix the priorities on upgrade in
  debian/postgresql-common.preinst. (Closes: #597654)

Author: Martin Pitt
Revision Date: 2010-04-24 21:14:13 UTC

Automated backport upload; no source changes.

Author: Martin Pitt
Revision Date: 2010-04-05 17:58:25 UTC

* t/001_packages.t: Check for ".utf8" locale instead of ".UTF-8". This
  seems to be the new canonical spelling now.
* t/TestLib.pm, check_clean(): Require that /var/log/postgresql/ still
  exists. If we remove it entirely, current versions of logcheck complain
  loudly. This was already fixed a while ago in squeeze, this will ensure it
  stays so. (Closes: #576180)
* t/040_upgrade.t: Check upgrade of database and table ACL, an ALTER
  DATABASE option, and correct upgrading of a custom pg_hba.conf. This
  reproduces #543506.
* pg_upgradecluster: Rework logic to use "pg_dumpall -s" instead of
  "pg_dumpall -g", to also catch ACLs, global settings, and the like. Drop
  manual database creation and encoding special-cases, since those are being
  taken care of by the -s commands already. (Closes: #543506, #562676)
* pg_upgradecluster: Re-enable connections after the upgrade is done, not in
  between.
* t/120_pg_upgradecluster_scripts.t: Upgrade scripts should not create
  tables in the "init" phase, since they will be overwritten during
  dump/restore. Change the test case to move table changes into the "finish"
  phase, and update documentation in pg_upgradecluster to point out this
  potential problem.
* debian/init.d-functions, status(): More appropriate output formatting for
  "status" init script commands. (Closes: #522679)

Author: Martin Pitt
Revision Date: 2009-09-06 21:30:40 UTC

* debian/supported-versions: Only support 8.4 in Ubuntu 9.10. (LP: #403381)
* PgCommon.pm, change_ugid(): Fix taint error. (LP: #403693)
* Update Swedish debconf translations, thanks Martin Bagge!
  (Closes: #539216)
* t/090_multicluster.t: Run psql error tests under LC_MESSAGES=C to not fail
  under non-English locales.
* pg_upgradecluster: Do not try to migrate "stats_*" settings to
  "track_counts" again if track_counts is already set. This led to disabling
  autovacuum on a 8.3 → 8.4 migration. (Closes: #540351)
* pg_upgradecluster: Fix owner of pg_hba.conf after upgrade, to also work in
  tight umask settings.
* debian/control: Bump Standards-Version to 3.8.3; no changes necessary.
* debian/control: Re-promote ssl-cert to Depends:. Dropping to recommends
  does not buy anything and causes regressions. (Closes: #540982)

Author: Martin Pitt
Revision Date: 2009-03-23 07:41:50 UTC

* t/030_errors.t: Fix "no space left on device" test for non-English
  locales.
* Add cleanpg: Script to remove all PostgreSQL related processes and files.
  This isn't shipped in the package, just kept in the source as a developer
  tool.
* debian/control: Update section to "database".
* debian/control: Bump Standards-Version to 3.8.1 (no changes required).
* t/TestLib.pm, deb_installed(): Properly close the dpkg file descriptor.
  Thanks to Cyril Bouthors for pointing this out!
* t/001_packages.t: Check that postgres user is in the ssl-cert group.
  Thanks to Cyril Bouthors for the patch!
* Added support for passing additional options to pg_ctl through a new
  configuration file pg_ctl.conf, or as additional CLI arguments to
  pg_ctlcluster. Add tests in t/085_pg_ctl.conf.t. Thanks to Cyril Bouthors
  <cyril@bouthors.org> for the patch! (Closes: #492843)
* t/070_non_postgres_clusters.t: Update number of tests for new pg_ctl.conf
  file.
* t/090_multicluster.t: Check that explicit port specification with
  -p/--port/$PGPORT selects the right cluster in the case of multiple
  existing clusters where none runs on the default port. This reproduces
  #517527.
* pg_wrapper: Default to latest version if -p, --port, or $PGPORT is
  specified, multiple clusters are available, and none is running on the
  default port 5432. (Closes: #517527)

Author: Ubuntu Archive Auto-Sync
Revision Date: 2009-11-09 13:45:15 UTC

Automated backport upload; no source changes.

Author: Martin Pitt
Revision Date: 2008-07-21 12:01:08 UTC

* Update Swedish debconf translations, thanks Martin Bagge!
  (Closes: #490677)
* Add Turkish debconf translations, thanks Mert Dirik!
  (Closes: #491007)
* Update Vietnamese debconf translations, thanks Clytie Siddall!
  (Closes: #491048)
* Update Russian debconf translations, thanks Sergey Alyoshin!
  (Closes: #491420)
* PgCommon.pm, change_ugid(): Use /usr/bin/id instead of manual parsing with
  getgrent(), which is reportedly magnitudes faster for environments with
  a large number of groups in remote databases. Thanks to Rodrigo Gallardo!
  (Closes: #491136)
* debian/postgresql-common.postinst: Update root.crt header comment for
  PostgreSQL 8.3. (Closes: #491276)
* pg_ctlcluster: Fix typo in pg_ctl error messages. Thanks to Aaron Schrab!
  (Closes: #488280)
* pg_createcluster, pg_ctlcluster: Set the log file group to "adm" if
  the cluster is owned by a system user (like "postgres"). In the "owned by
  human user" case, keep it as that user's primary group. Check both cases in
  the test suite. (Closes: #483017)
* t/TestLib.pm: Return "1" at the end, to avoid "TestLib.pm did not return a
  true value" error on import.
* PgCommon.pm, read_conf_file(): Fix parsing of escaped quotes in string
  values. Add tests to t/005_PgCommon.t. (Closes: #481055)

Author: Martin Pitt
Revision Date: 2008-03-31 11:32:39 UTC

* Urgency medium since #472930 is an important bug fix.
* debian/init.d-functions: If there are no clusters, exit with 4 (LSB-code
  for "unknown status") instead of 0 (which means "service is running", but
  it is debatable and confusing whether all clusters are running if there
  are none at all). (LP: #203966)
* Update Spanish debconf translations, thanks Javier Fernández-Sanguino
  Peña. (Closes: #473405)
* t/060_obsolete_confparams.t: Run upgrades under
  default_transaction_read_only=on. t/040_upgrade.t still uses the default
  "off", so both cases get tested. This replicates the problem report from
  Karsten Hilbert.
* pg_upgradecluster: Work with default_transaction_read_only=on.
* debian/autovacuum.conf, architecture.html: Point out that this file is
  only relevant for PostgreSQL versions earlier than 8.1. Thanks to Ross
  Boylan for pointing this out.
* Add t/051_inconsistent_encoding_upgrade.t: Check that upgrades from
  pre-8.3 to 8.3 succeed and have correct encodings if the old DB had a
  database whose encoding did not match the server locale. This reproduces
  #472930.
* pg_upgradecluster: Fix handling of database encodings on upgrade, since
  8.3 now forces DB encodings and server locale to match:
  - With C locale, keep encoding of DBs on upgrade, just as in previous
    versions. (C is compatible with all encodings, and causes lots of string
    functions not to work correctly, but people still use it deliberately.)
  - With other locales, create the target DB manually with a compatible
    encoding, and call pg_restore in a way to not create the target DB and
    automatically convert encoding.
  - Closes: #472930, LP: #207779

Author: SpecialK
Revision Date: 2008-02-08 13:48:52 UTC

Automated backport upload; no source changes.

Author: Martin Pitt
Revision Date: 2007-09-16 20:59:30 UTC

debian/postgresql-common.postinst: Only clean up
/usr/lib/postgresql/dumpall/ on upgrades if it is actually a directory.
(Closes: #440596)

Author: SpecialK
Revision Date: 2008-02-08 13:50:30 UTC

Automated backport upload; no source changes.

Author: Martin Pitt
Revision Date: 2007-03-26 18:51:27 UTC

* debian/postgresql-common.dirs: Ship /var/lib/postgresql again, creating it
  dynamically causes various upgrade failures. Closes: #416146, #416228
* debian/postgresql-common.postinst: Call adduser with --no-create-home.
  This avoids the 'wrong owner' warning as well.

Author: Martin Pitt
Revision Date: 2007-02-12 09:00:42 UTC

Automated backport upload; no source changes.

Author: Martin Pitt
Revision Date: 2006-09-18 09:12:20 UTC

* t/080_start.conf.t: Check that stop'ing a cluster works even if the
  cluster is disabled (test for bug #386996).
* pg_ctlcluster: Allow 'stop' and 'autovac-stop' for disabled clustes.
  Closes: #386996
* Reduce options passed to postmaster at runtime to shorten command line and
  make the configuration more obvious and explicit:
  - pg_ctlcluster: Do not pass unix_socket_dir/hba_file/ident_file if it is
    already defined in postgresql.conf.
  - pg_createcluster: If we create a cluster >= 8.0, set hba_file,
    ident_file, and external_pid_file in postgresql.conf.
  - 070_non_postgres_clusters.t: Fix expected output accordingly and
    use 'ls' for socket check instead of looking at the command line.
  - Closes: #384999

Author: Martin Pitt
Revision Date: 2006-05-29 08:56:06 UTC

debian/control: Have p-common always depend on the recent p-client-common,
since the latter ships PgCommon.pm. If the library is out of date, this
can break operations horribly. (http://bugs.debian.org/369289)

Author: Ubuntu Archive Auto-Sync
Revision Date: 2006-01-19 17:21:56 UTC

Automated backport upload; no source changes.

Author: Martin Pitt
Revision Date: 2006-03-08 12:48:49 UTC

* pg_createcluster:
  - Do not enable SSL on 7.4 clusters since enabling it without enabling the
    TCP socket breaks.
  - Fix backported from version 29.
  - Malone #33996.

Author: Martin Pitt
Revision Date: 2005-09-28 22:59:04 UTC

* Changed my debuild alias to explicitly ignore .arch-ids directories (a
  mere -i catched some, but not all arch directories). Closes: #328204
* Add lintian overrides for missing manpages; manpages are provided by
  postgresql-client-X.Y packages.
* pg_ctlcluster: Have autovac-* commands error out with a meaningful message
  instead of claiming success if pg_autovacuum is not available.
* pg_ctlcluster:
  - Increase the timeout for the started postmaster to 30 seconds to cope
    with slow startup. Closes: #320444
  - Immediately fail if the postmaster produced log output and does not run
    any more. This avoids unnecessary timeouts on configuration errors and
    the like.
* pg_createcluster: Listen on localhost by default only since upstream
  considers listening on all interfaces by default not safe enough.
  Closes: #318820
* pg_dropcluster: Handle missing data directories gracefully.
  Closes: #330135