lp://staging/ubuntu/saucy-proposed/postgresql-common

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

59. By Martin Pitt on 2013-08-27

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

58. By Christoph Berg on 2013-07-16

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

57. By Christoph Berg on 2013-06-10

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

56. By Christoph Berg on 2013-05-31

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

55. By Martin Pitt on 2013-05-10

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

54. By Martin Pitt on 2013-05-07

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

53. By Christoph Berg on 2013-01-31

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

52. By Christoph Berg on 2013-01-06

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

51. By Martin Pitt on 2012-12-16

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

50. By Martin Pitt on 2012-12-15

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