1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
postgresql-common (200+deb10u1) buster; urgency=high
Existing PostgreSQL databases need to be reindexed
When upgrading from stretch to buster, the glibc locale data is upgraded.
Specifically, this changes how PostgreSQL sorts data in text indexes. To
avoid corruption, such indexes need to be REINDEXed immediately after
upgrading the locales or locales-all packages, before putting back the
database into production.
Suggested command: sudo -u postgres reindexdb --all
Alternatively, upgrade the databases to PostgreSQL 11 using
pg_upgradecluster. (This uses pg_dump by default which will rebuild all
indexes. Using -m upgrade or pg_upgrade is not safe because it preserves
the now-wrong index ordering.)
Refer to the PostgreSQL Wiki for more information:
https://wiki.postgresql.org/wiki/Locale_data_changes
-- Christoph Berg <myon@debian.org> Fri, 12 Apr 2019 14:32:52 +0200
postgresql-common (161) unstable; urgency=medium
pg_ctlcluster is now enforcing stricter file ownership on the cluster config
when invoked as root, including operation via the init.d script or the
systemd unit:
The postgresql.conf owner needs match the data directory owner, or the
postgresql.conf file needs to be owned by root.
Default setups are not affected by this change.
-- Christoph Berg <myon@debian.org> Fri, 05 Sep 2014 15:48:13 +0200
postgresql-common (159) unstable; urgency=low
PostgreSQL clusters managed by postgresql-common are now systemd enabled. For
each cluster, a service "postgresql@<version>-<name>" is created that can be
started/stopped/restarted/reloaded. A parent service "postgresql" acts on
all installed (start.conf has "auto") clusters in parallel like the init.d
script used to do. /etc/init.d/postgresql can still be used, though the mode
of starting individual versions ("/e/i/p start 9.3") no longer works.
pg_ctlcluster can be used to control clusters, but for start and restart the
operation via systemd (using systemctl or the init.d script) is preferred, or
else the clusters will not run in cgroups. (Unfortunately this requires
root.)
If the system is not running systemd, nothing changes.
-- Christoph Berg <myon@debian.org> Fri, 18 Jul 2014 23:52:09 +0300
postgresql-common (158) experimental; urgency=medium
This postgresql-common release introduces several changes in the defaults
used for newly created database clusters, all configurable in
/etc/postgresql-common/createcluster.conf:
* The default log_line_prefix is now '%t [%p-%l] %q%u@%d ' instead of '%t '.
* stats_temp_directory aka pg_stat_tmp is set to a subdirectory of
/var/run/postgresql by default.
* The use of SSL by default is (pre-)configurable via debconf and
createcluster.conf.
If the logging_collector or syslog is being used, pg_lsclusters will show
the filename (or "syslog") instead of just "custom" in the Log file column.
-- Christoph Berg <myon@debian.org> Sat, 05 Jul 2014 16:40:16 +0200
|
