lp:ubuntu/lucid/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

16. By Martin Pitt on 2010-04-05

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

15. By Martin Pitt on 2010-01-20

debian/postgresql-common.postinst: Fix upgrade failure if no tsearch
dictionaries exist. (Closes: #565966)

14. By Martin Pitt on 2010-01-19

* pg_updatedicts: Process dictionaries from /usr/share/hunspell, too.
* debian/control: Add Vcs-* fields.
* Add standard license headers to all programs, and update copyright.
* debian/copyright: Update to DEP-5 (Machine-readable debian/copyright), and
  drop Oliver's copyright, since there is nothing left that was written by
  him.
* pg_updatedicts: Do not create system_<locale>.{affix,dict} symlinks any
  more, but use the actual names that upstream PostgreSQL looks for (without
  system_ prefix). This allows us to drop the system_ lookup patch from
  PostgreSQL. Update t/150_tsearch_stemming.t accordingly and remove the old
  system_* symlinks on upgrade in debian/postgresql-common.postinst.

13. By Martin Pitt on 2009-12-30

* Move the lsb-release dependency of p-common to a recommends of
  p-client-common. (Closes: #562642)
* Drop Oliver from Uploaders:, he has not been active any more for years.
* t/005_PgCommon.t: Add '.' to library search path, so that this prefers
  testing PgCommon.pm from the source tree.
* t/005_PgCommon.t: Add test cases for {set,disable,replace}_conf_value().
* PgCommon.pm, replace_conf_value(): Do not append the new parameter if the
  old is not found.
* PgCommon.pm, {set,disable,replace}_conf_value(): Intercept errors on
  writing data (which could happen when running out of disk space). Write
  into a new file and rename it in the end, instead of directly writing into
  the original file. Thanks to Yann Dirson for the original patch.
  (Closes: #549206)
* pg_createcluster: Change effective gid as well when setting the socket
  directory, to avoid moving postgresql.conf's group to root (which would
  happen with the previous change).
* Add t/042_upgrade_tablespaces.t: Test upgrading a cluster with
  tablespaces. Since this is not currently supported (and hard to do in an
  automated fashion due to the nature of tablespaces), just check that this
  errors out with a sane message and does not do any damage.
* pg_upgradecluster: Add an early check for tablespaces. (Closes: #523574)
* pg_lsclusters: Fix undefined value if owneruid cannot be determined (which
  can happen in special setups). Thanks to Daniel Pittman! (Closes: #541434)
* t/020_create_sql_remove.t: Verify permissions of the data and
  configuration directories.
* pg_createcluster: Make /etc/postgresql/<version> and
  /var/lib/postgresql/<version> owned by 'postgres', so that they can be
  administrated with 'postgres' privileges. Update t/030_errors.t
  accordingly. (LP: #236704, Closes: #525294)
* t/020_create_sql_remove.t: Check that a missing log file is recreated by
  pg_ctlcluster (if it has enough permissions).
* pg_ctlcluster: Make re-creation of log file actually work. (LP: #391119,
  #372476)

12. By Martin Pitt on 2009-12-14

* debian/postgresql-common.postinst: Create /var/log/postgresql/ if it does
  not exist, before trying to chown/chmod it.
* t/001_packages.t: Check that -server-dev-* is installed (for
  t/140_pg_config.t)
* t/001_packages.t: Check that the system default locale is an UTF-8 one.
* debian/supported-versions: Add Ubuntu 10.04.
* t/050_encodings.t: Disable Russian error message encoding test for now,
  since Russian translations were dropped upstream (too incomplete).

11. By Martin Pitt on 2009-09-06

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

10. By Martin Pitt on 2009-07-23

debian/supported-versions: Only support 8.4 in Ubuntu 9.10. (LP: #403381)

9. By Martin Pitt on 2009-07-05

* t/005_PgCommon.t: Add test case for read_conf_file() for configuration
  files with an include directive. This reproduces #535428.
* PgCommon.pm, read_conf_file(): Correctly handle includes.
  (Closes: #535428)
* PgCommon.pm: Check environment variable $PG_CLUSTER_CONF_ROOT for an
  alternative configuration root (default: /etc/postgresql/). For
  testing/development purposes you can change this to point to e. g. your
  home directory, so that you can use the postgresql-common tools without
  root privileges. Thanks to Aidan Van Dyk for the suggestion and patch!
* pg_createcluster: If calling as non-root user, default to effective user
  id for owneruid instead of root. This makes using $PG_CLUSTER_CONF_ROOT
  more convenient.
* pg_wrapper: Document PG_CLUSTER_CONF_ROOT in the POD.
* debian/control: Add missing ${misc:Depends}.
* debian/control: Bump Standards-Version to 3.8.2; no changes necessary.

8. By Martin Pitt on 2009-04-09

* debian/control: Add missing lsb-release dependency (which now ships the
  lsb_release program). (Closes: #520992)
* Add support for 8.4 (pre-release snapshots for now):
  - debian/supported-versions: Support 8.4 everywhere (for backports).
  - cleanpg: Remove 8.4 clusters.
  - pg_createcluster: Clone configure_8_3() as configure_8_4().
  - t/060_obsolete_confparams.t: Add complete set of 8.3 configuration
    options, to test configuration migration to 8.4.
  - PgCommon.pm, get_cluster_locales(): Bail out if calling on 8.4 or later
    cluster (where locales are not associated to clusters any more).
    PgCommon.pm, get_cluster_databases(): Ignore lines from psql -Atl which
    just describe access permissions.
  - pg_ctlcluster: Only do locales check for <= 8.3 for now.
  - "ident sameuser" does not exist any more in 8.4, just use "ident" from
    8.4 on.
  - pg_createcluster: Do not symlink root.crt if
    /etc/postgresql-common/root.crt does not have actual certificates (just
    the help text), since 8.4 gets royally confused about the dummy one.
  - pg_upgradecluster: Migrate obsolete/changed configuration parameters.
  - t/020_create_sql_remove.t: Fix parsing of psql -Atl output for new 8.4
    format.
  - t/030_errors.t: 8.4 now fails on invalid pg_hba.conf, update
    accordingly.
  - t/050_encodings.t: Stop using pg_controldata for checking cluster
    encoding. Just check psql -Atl.
* pg_upgradecluster: Don't call createdb/dropdb with -q; it got dropped in
  8.4 and is not necessary any more with 8.3 either.
* t/010_defaultport_cluster.t: Ensure that we run the test with
  LC_MESSAGES=C, so that it succeeds in non-English locales, too.
* t/051_inconsistent_encoding_upgrade.t: Disable if the oldest available
  cluster is 8.3 or newer; the test is not relevant there, and will fail.

7. By Martin Pitt on 2009-03-23

* 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
  <email address hidden> 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)