-
postgresql-common (85~feisty1) feisty-backports; urgency=low
* Automated backport upload; no source changes.
postgresql-common (85) unstable; urgency=low
* debian/README.Debian: Fix fatal typo that suggested dropping the wrong
cluster on upgrade. (Closes: #464064)
* pg_upgradecluster: Fix some typos in the POD, thanks to Brendan Jurd!
postgresql-common (84) unstable; urgency=low
* Add t/140_pg_config.t: Check correct output of pg_config, to avoid bugs
like #455509 and #462037 in the future.
* t/040_upgrade.t: Create and cd into an inaccessible test directory.
* pg_upgradecluster: Chdir to / before the upgrade to avoid confusing error
messages about inaccessible cwd.
* debian/README.Debian: Update for 8.3 being the default version. Drop
description of 7.4 autovacuum daemon magic, since it is obsolete now.
* debian/postgresql-common.templates: Point to README.Debian.
* debian/postgresql-common.cron.d: Update for 8.3, and add warnings and doc
pointer about enabling regular VACUUM FULL. (LP: #186831)
* PgCommon.pm, get_cluster_locales(): Print proper error message when server
package is removed, but not purged, and a cluster still exists.
(Closes: #463070)
* t/030_errors.t, t/130_nonroot_admin.t: Check pg_dropcluster/
pg_createcluster error message when being called with insufficient
privileges.
* pg_createcluster, pg_dropcluster: Point out that program needs to be run
as root when creating/removing config or data directory fails.
(Closes: #460576)
* t/090_multicluster.t: Remove test case for nonexisting PGSERVICE value,
since this is not reliably reported in psql.
* t/140_pg_config.t: Skip pg_config test for 8.1. It's known broken in Etch
(pg_config was only shipped in libpq-def) and irrelevant in Lenny.
postgresql-common (83) unstable; urgency=low
* Drop the "If you have openssl installed..." from the package description,
since ssl-cert depends on it.
* t/050_encodings.t: Add alternative unicode representation 0xc827 for the
CVE-2006-2313 test, so that the testsuite runs cleanly in Ubuntu 6.06.
* debian/supported-versions: Drop 8.1 from fallback set of supported
versions.
* debian/postgresql-common.config: Add check for forcing the obsoletion
notifications when upgrading over a particular version. This provides the
notification when upgrading from Etch to Lenny, and when obsoleting a
major version within unstable.
* debian/supported-versions: Drop support for 8.2 in unstable, 8.3 is the
version du jour.
* debian/supported-versions: Drop Ubuntu 5.10, fix a typo in the versions
for Ubuntu 6.06.
* t/090_multicluster.t: Test correct behaviour of pg_service.conf. (See
#439026)
* debian/supported-versions: Only support 8.3 in Ubuntu 8.04.
postgresql-common (82) unstable; urgency=low
* debian/control: Fix 'commmon' typo. (Closes: #449532)
* t/030_errors.t: Check that an /etc/postgresql/postgresql.conf leftover is
not regarded as a cluster directory. This reproduces #450565.
* PgCommon.pm, get_versions()/get_version_clusters(): Filter out '.' and
'..' from readdir() output. (Closes: #450565)
* pg_ctlcluster: Use "smart" mode shutdown by default, and add option
-f/--force to use "fast" -> "immediate" -> kill -9 approach. (LP: #154012)
* debian/init.d-functions: Use --force when stopping all clusters, since
default smart mode can potentially block forever and thus fail to shut
down a machine.
* debian/README.Devel: Update for current bzr versions and hosting on
code.launchpad.net.
* Update Japanese debconf translations (Closes: #450902)
postgresql-common (81) unstable; urgency=low
* debian/supported_versions: Welcome, Ubuntu Hardy (8.04)!
* debian/postgresql-common.templates, debian/control: Language and grammar
improvements, thanks a lot to Christian Perrier and the l10n teams!
(Closes: #446457)
* Update debconf translations, thanks to all translators!
- French (Christian Perrier) (Closes: #446978)
- Vietnamese (Clytie Siddall) (Closes: #447009)
- Finnish (Esko Arajärvi) (Closes: #447045)
- Italian (Luca Monducci) (Closes: #447052)
- Galician (Jacobo Tarrio) (Closes: #447054)
- Basque (Piarres Beobide) (Closes: #447131)
- Spanish (Javier Fernández-Sanguino Peña) (Closes: #447417)
- Czech (Miroslav Kure) (Closes: 447436)
- Portugese (Miguel Figueiredo) (Closes: #447642)
- Brazilian Portugese (Eder L. Marques) (Closes: #447881)
- Russian (Sergey Alyoshin) (Closes: #448768)
- German (Martin Pitt)
postgresql-common (80) unstable; urgency=low
* pg_upgradecluster: Fix locale error checking.
* pg_upgradecluster: Use cluster_exists() instead of
cluster_data_directory().
* PgCommon.pm: Fix cluster_data_directory() to consider the data_directory
setting in postgresql.conf, which should trump the /pgdata symbolic link.
* debian/init.d-functions: Check for 'postgresql.conf' instead of 'pgdata'
in the test for a valid cluster configuration directory, since 'pgdata' is
optional now.
* pg_createcluster: Do not create pgdata symlinks to the data directory in
/etc any more when configuring a >= 8.0 cluster. Use the data_directory
configuration option instead. (Part of #444689)
* t/020_create_sql_remove.t: Check that clusters still work when replacing
the data_directory setting with a pgdata symbolic link, and that
the data_directory setting trumps the symlink.
* pg_upgradecluster: Set correct data_directory config option after copying
over the old configuration files.
* t/060_obsolete_confparams.t: Restore data_directory setting after
scribbling over the configuration file with our template.
* PgCommon.pm, cluster_info(): Only return a value for 'logfile' when it is
not explicitly configured with log_directory and/or log_filename. The
previous guessing was wrong anyway, since PostgreSQL always appends a
pretty unpredictable timestamp.
* pg_ctlcluster: Only do log file checks and pass pg_ctl -l option when the
log file default is used. Otherwise let PostgreSQL do its logfile handling
and waive log file checks, since we don't know which file is used.
* pg_ctlcluster: Redirect pg_ctl's stdout and stderr to /dev/null, otherwise
it will hang forever when using a custom log file (and thus not passing
-l).
* pg_lsclusters: Print "custom" as log file location if a custom one was set
in postgresql.conf.
* pg_upgradecluster: Enable 'redirect_stderr' in the 7.4 -> 8.x migration of
'syslog' -> 'log_destination', so that the log output is actually
complete.
* t/060_obsolete_confparams.t: Enable 'redirect_stderr' in the template
postgresql.conf's, so that we actually capture log output.
* t/020_create_sql_remove.t: Check proper handling of logs when configuring
log file in postgresql.conf, using the log symlink, or having neither.
* PgCommon.pm, cluster_info(): Return default log file in 'logfile' if
neither postgresql.conf nor a 'log' symlink explicitly specify a log file.
* pg_createcluster: Do not create log symlink if using the default log file
(i. e. when not using -l). (Closes: #444689)
* t/020_create_sql_remove.t: Verify that log symlink is not created by
default.
* architecture.html: Update to current reality.
* debian/postgresql-common.config: Do not consider versions as obsolete if
they are newer than the latest officially supported version. This avoids
confusion when testing new betas in experimental or using backports.
(Closes: #446635)
* t/TestLib.pm: Make exec_as() work with user name 'root' (not just uid 0).
* Add t/130_nonroot_admin.t: Check that administrative pg_ tools work as
non-root, too, if the invoker has sufficient permissions on the
directories (test case for LP #90036).
* pg_{create,drop,upgrade}cluster: Small tweaks to make the scripts work for
non-root users with sufficient write permissions to
/etc/postgresql/<version>, /var/lib/postgresql/<version>, and
/var/log/postgresql. (LP: #90036)
postgresql-common (79) unstable; urgency=low
* debian/supported-versions: Welcome, version 8.3!
* pg_createcluster: Add configure_8_3().
* PgCommon.pm, cluster_info(): 8.3 defaults to 'autovacuum = On' when not
given, reflect that in the avac_enable return value.
* t/050_encodings.t: 8.3 onwards refuses to create a cluster with an
inconsistent locale/encoding combination. Just drop the test case, it does
not make too much sense anyway.
* t/090_multicluster.t: Do not rely on output of createdb, call it with -q.
8.3 behaves differently here.
* t/060_obsolete_confparams.t: Add full set of 8.2 postgresql.conf options
for testing upgrades to 8.3.
* pg_upgradecluster: When upgrading to 8.3, transition changed configuration
options:
- bgwriter_lru_percent, bgwriter_all_percent, bgwriter_all_maxpages,
stats_start_collector, and stats_reset_on_server_start: deprecated.
- redirect_stderr -> logging_collector
- stats_command_string -> track_activities
- stats_block_level || stats_row_level -> track_counts
- Explicitly enable archive_mode when archive_command is set.
postgresql-common (78) unstable; urgency=low
* debian/postgresql-common.postinst: Only clean up
/usr/lib/postgresql/dumpall/ on upgrades if it is actually a directory.
(Closes: #440596)
postgresql-common (77) unstable; urgency=low
* debian/control: Fix obsolete ${Source-Version}.
* t/020_create_sql_remove.t: Create fake rotated log files to check that
they are cleaned up properly.
* pg_dropcluster: Remove rotated logs, too. (part of #431643)
* debian/postgresql-common.postinst: Clean up /usr/lib/postgresql/dumpall/
junk from the Sarge->Etch postgresql transition. This needs to be kept
until after Lenny's release. (part of #431643)
* Add debian/postgresql-client-common.postrm: Clean up
/var/lib/postgresql/.psql_history on purge. Closes: #431643
* debian/postgresql-common.postinst: Create /var/lib/postgresql/ if it does
not exist. This should not usually happen, but apparently did anyway.
(Closes: #438698)
postgresql-common (76) unstable; urgency=medium
* Priority medium since this unbreaks client programs like psql in testing.
* pg_wrapper: Revert changes of version 74 to make this work with taint
mode. It breaks too many custom setups, and Perl just doesn't allow to
untaint $PATH bluntly. If you run pg_wrapper from a perl script with taint
checks enabled, you have to clean $PATH yourself. Closes: #427894
* t/020_create_sql_remove.t: Check that PL/TCL and PL/TCLu work, so that we
now have complete test coverage of all four PLs that are shipped with the
core package.
* t/001_packages.t: Check that postgresql-pltcl-<version> is installed.
* PgCommon.pm, get_cluster_socketdir(): Improve error message if data
directory parent is not readable. Closes: #428698
postgresql-common (75) unstable; urgency=low
The "Never run the test suite without 7.4 just because it is deprecated and
about to be removed" release. Sorry for the trouble.
* pg_ctlcluster: Partially revert PATH cleansing to make pg_ctl work on 7.4
again. This can be dropped again once 7.4 is actually removed from the
archive. Closes: #425594
postgresql-common (74) unstable; urgency=low
* debian/supported_versions:
- Match any 4.0* as Debian Etch to get the correct set of supported
versions. Closes: #420915
- Add Lenny/unstable: only support 8.2.
- Add Ubuntu 7.10.
- Don't fail if the distribution cannot be determined at all, only print
out a warning.
* pg_createcluster, pg_ctlcluster, pg_dropcluster, pg_maintenance,
pg_upgradecluster: Strip down PATH untainting to the absolute minimum, to
not fall over if e. g. /usr/local/bin is misconfigured to be world
writable. Closes: #420565
* pg_wrapper: Make this script work with taint checks enabled. This happens
in a pretty blunt way, since it does not actually make sense to enforce
environment variables, etc. It should just not fail when being called from
a -T perl script. Closes: #422129
* debian/postgresql-common.postinst: Do not hide failures of the init
script on restart.
* debian/postgresql-common.config, debian/postgresql-common.templates:
Remove the check for an untransitioned postgresql, since it was only
necessary for the Sarge->Etch upgrade. Update debian/po/*.po.
* Remove debian/postgresql-common.preinst, we only needed it for the
"untransitioned" test.
* debian/control: Move cdbs and debhelper from B-D-I to B-D, since we need
them for 'clean'.
* Add debian/postgresql-client-common.lintian: Lintian overrides for 'binary
without manpage'. The stuff in /usr/bin is just a symlink to pg_wrapper,
postgresql-client-* ships the actual manpages for those.
-- SpecialK <email address hidden> Fri, 8 Feb 2008 13:50:30 +0000
-
postgresql-common (73) unstable; urgency=low
* 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.
postgresql-common (72) unstable; urgency=low
* debian/postgresql-common.postinst: Set default /var/log/postgresql
permissions to root:postgres 1775. Closes: #410852
* Update Russian debconf translations. Thanks to Yuriy Talakan'!
Closes: #414067
* postgresql-common/debian/postgresql-common.dirs: Remove
/var/lib/postgresql, so that adduser does not complain about a preexisting
directory with the wrong owner any more. This also avoids removing the
home directory of postgres when removing the package. Closes: #415444
-- Martin Pitt <email address hidden> Wed, 28 Mar 2007 16:35:35 +0100
-
postgresql-common (71) unstable; urgency=low
* Add Swedish debconf translations. Thanks to Andreas Henriksson!
Closes: #407865
* Add Galician debconf translations. Thanks to Jacobo Tarrio!
Closes: #408121
* debian/supported-versions: Only 8.2 is supported in Ubuntu 7.04.
* pg_ctlcluster: Check that $version and $cluster are still defined after
untainting to avoid confusing (but harmless) error message.
Closes: #406117
-- Martin Pitt <email address hidden> Mon, 29 Jan 2007 17:07:19 +0000
-
postgresql-common (70) unstable; urgency=low
* t/050_encodings: Check that $LC_ALL dominates $LANG on pg_createcluster.
This reproduces bug #403239.
* pg_createcluster: If $LC_ALL is defined, fix $LANG to $LC_ALL. Servers
prior to 8.2 get this wrong and fail over an invalid $LANG even if that is
dominated by a valid $LC_ALL. Closes: #403239
* Add Brazilian Portugese debconf translations. Thanks to André Luís Lopes!
Closes: #403563
* t/040_upgrade.t: Check that pg_upgradecluster does not have any stderr
output (such as error messages from pg_restore, the server, or Perl
warnings). This uncovers #403529.
* pg_upgradecluster: Do not mangle {hba,ident,external_pid}_file values from
old postgresql.conf if they do not exist at all. This removes the Perl
warnings during upgrades from 7.4. Closes: #403529
* debian/README.Debian: Describe default cluster setup and give an example
for upgrading a cluster if a newer version with the same name already
exists.
-- Ubuntu Archive Auto-Sync <email address hidden> Wed, 20 Dec 2006 13:01:42 +0000
-
postgresql-common (69) unstable; urgency=medium
* Urgency medium, only safe fixes and this needs to go into Etch due to
first bug fix.
* debian/supported_versions: Gracefully fall back on an unknown
distribution, instead of failing package installation completely.
Closes: #400628
* debian/supported_versions: Some minor factorization.
* Add Spanish debconf translations, thanks to Javier Fernández-Sanguino
Peña! Closes: #402198
* pg_createcluster: Add --locale and the various --lc_* options that initdb
supports, and mention in POD that directly setting --encoding is not
recommended. Closes: #395083
* t/050_encodings.t: Use pg_createcluster's new --locale option in some test
cases.
* Make testsuite work with just one installed major version (mainly boils
down to disabling upgrade tests).
-- Ubuntu Archive Auto-Sync <email address hidden> Tue, 12 Dec 2006 11:03:49 +0000
-
postgresql-common (68) unstable; urgency=low
* debian/supported-versions: Add Debian 4.0. Closes: #399978
* debian/postgresql-common.postinst: Use adduser option --quiet for adding
postgres to ssl-cert. Closes: #399979
* pg_createcluster: Enable timestamps in log files by default. Other system
log files have timestamps, too, and they are useful. Closes: #395554
* t/040_upgrade.t: Fix number of tests if oldest installed PostgreSQL
version is < 8.0.
-- Ubuntu Archive Auto-Sync <email address hidden> Mon, 27 Nov 2006 07:55:07 +0000
-
postgresql-common (67) unstable; urgency=low
*t/040_upgrade.t: Skip the user/group name clash test when there are only
servers >= 8.1 installed, since it does not apply to them and breaks the
test suite.
* t/040_upgrade.t: Check that the upgraded cluster still works after
removing the old one, to check for stale paths of configuration files.
* pg_upgradecluster: Adapt path to configuration files in the target
cluster, so that they do not refer to the files of the old cluster. (This
fixes an upgrade regression introduced in version 62).
* debian/supported-versions: Add Ubuntu 7.04.
* Add Italian debconf translations. Thanks to Luca Monducci
<email address hidden>! Closes: #396947
-- Ubuntu Archive Auto-Sync <email address hidden> Fri, 17 Nov 2006 17:12:39 +0000
-
postgresql-common (66) unstable; urgency=low
* Add Japanese debconf translations. Thanks to Hideki Yamane!
Closes: #393055
* pg_upgradecluster: Use -X no-data-for-failed-tables only for 8.1. In
8.2beta2 this got renamed to --no-data-for-failed-tables.
postgresql-common (65) unstable; urgency=low
* pg_upgradecluster: Quiesce dropdb for already existing 'postgres'
database.
* pg_upgradecluster: Avoid harmless, but confusing error messages about role
creation:
- Do not use -c for pg_dumpall, since the target roles should not yet
exist anyway.
- Filter out the 'CREATE (ROLE|USER)' command for the db superuser, since
it will already exist.
- Testsuite: Check that pg_upgradecluster output contains no server error
messages.
- Closes: #389930
postgresql-common (64) unstable; urgency=low
* Fix pg_ctlcluster regression from 63: 'database system is starting up'
fatal error message caused immediate abortion of startup checks. Make the
check easier and more robust, adapt test cases accordingly.
* t/020_create_sql_remove.t: Add check that PL/Perl works. Check that
-plperl-X.Y. is installed in t/001_packages.t.
* t/{040_upgrade.t,041_upgrade_custompaths.t}: Check for pg_restore error
messages during upgrade.
* pg_upgradecluster: Avoid pg_restore errors during upgrade (they were
nonfatal, but look ugly:)
- Drop 'postgres' db in 8.1+ target cluster if the source cluster already
has it.
- Do not use pg_restore's --create for template1.
- Fix hardcoded library paths before dumping/restoring the cluster, not
after, to avoid error messages about failed library loads.
postgresql-common (63) unstable; urgency=low
* t/090_multicluster.t, t/100_upgrade_scripts.t: Replace hardcoded '8.1'
versions in test data with appropriate $MAJORS values.
* pg_createcluster: Add configure_8_2().
* pg_ctlcluster, check_running_postmaster(): Check for both 'postmaster' and
'postgres' processes to also work for 8.2.
* t/TestLib.pm, check_clean(): Also check for running 'postgres' processes
(since that's how the server is called in 8.2+). Update number of tests
everywhere.
* t/TestLib.pm, check_clean(): Fix regexp for netstat port grepping so that
ports like '54321' do not match.
* t/TestLib.pm, pidof(): Make pidof() strict enough to not catch the stats
collector and writer subprocesses.
* t/*.t: Various small adaptions to work with 8.2, too.
* t/060_obsolete_confparams.t: Add full configuration for 8.1, to test
8.1->8.2 upgrade.
* pg_upgradecluster: When upgrading to 8.2, transition changed configuration
options:
- preload_libraries -> shared_preload_libraries
- australian_timezones -> timezone_abbreviations
* pg_ctlcluster: Instead of parsing pg_hba.conf, just try to connect with
setting PGPASSWORD to a bogus value, and check for authentication errors.
This is more robust and more elegant, and also covers nonstandard
authentication schemes correctly. Closes: #388419
* debian/supported-versions: Recklessly consider 8.2 as supported to avoid
whining if 8.2 package gets backported.
-- Ubuntu Archive Auto-Sync <email address hidden> Tue, 07 Nov 2006 03:24:56 +0000
-
postgresql-common (62) unstable; urgency=low
* 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
postgresql-common (61) unstable; urgency=low
* pg_lsclusters: Remove trailing spaces from output, adapt test suite
accordingly.
* pg_upgradecluster: Correctly pass custom datadir to pg_createcluster.
Closes: #385034
* Add t/041_upgrade_custompaths.t: Test upgrading with a custom data
directory and log file path (this also covers bug #385034).
postgresql-common (60) unstable; urgency=low
* Update Czech debconf translations, thanks to Miroslav Kure.
Closes: #384757
* t/090_multicluster.t: Check that $PGHOST and $PGDATABASE environment
variables are respected and have the correct precedence. (This reproduces
#385971). Now this test has full coverage of all libpq environment
variables but $PGUSER (which is not used at all anywhere).
* pg_wrapper: Do not override $PGDATABASE and $PGHOST with user_clusters
map. Closes: #385971
* Update Dutch debconf translations, thanks to Vincent Zweije.
Closes: #386704
* pg_createcluster: Fix POD to have consistent long-option syntax. Thanks to
Bastian Kleineidam! (Part of bug #386148)
* Improve handling of custom socket directories:
- pg_createcluster: Create a nonexisting directory.
- pg_dropcluster: Remove empty socket directory unless it's /tmp or
/var/run/postgresql.
- Thanks to Bastian Kleineidam for the suggestions.
- t/030_errors.t: Do not create our custom socket dir ourselves any more,
since pg_createcluster is now supposed to handle that (thus providing a
test case).
- Closes: #386148
-- Martin Pitt <email address hidden> Tue, 19 Sep 2006 16:37:46 +0100
