[Pkg-postgresql-public] Bug#689996: postgresql-common: pg_updatedicts does not remove old dictionaries

[Daniel Kahn Gillmor]

Package: postgresql-common
Version: 136
Severity: normal
Control: found -1 134wheezy1

It looks like pg_updatedicts adds new dictionaries to postgresql's
dictionary cache, but it doesn't remove old dictionaries that have
been purged.

This seems like a mistake to me -- why should these dictionaries
linger if the system administator has purged them?

Below is an example transcript that i think shows the problem:

0 root at stylus:~# ls -la /var/cache/postgresql/dicts/it*
ls: cannot access /var/cache/postgresql/dicts/it*: No such file or directory
2 root at stylus:~# apt-get install myspell-it
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  myspell-it
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 365 kB of archives.
After this operation, 1,377 kB of additional disk space will be used.
Get:1 http://http.us.debian.org/debian/ sid/main myspell-it all 1:3.3.0-4 [365 kB]
Fetched 365 kB in 0s (785 kB/s)
Selecting previously unselected package myspell-it.
(Reading database ... 271633 files and directories currently installed.)
Unpacking myspell-it (from .../myspell-it_1%3a3.3.0-4_all.deb) ...
Processing triggers for postgresql-common ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
  bg_bg
  ca_es-valencia
  ca_es
  cs_cz
  da_dk
  de_de
  en_gb
  en_us
  eo
  et_ee
  fr
  he
  it_it
  ku_tr
  lt_lt
  lv_lv
  nb_no
  nl
  nn_no
  pl
  pt
  pt_br
  ru_ru
  sk_sk
  sl_si
  sv_se
  uk_ua
[ ok ] Starting PostgreSQL 9.1 database server: main.
Setting up myspell-it (1:3.3.0-4) ...
0 root at stylus:~# ls -la /var/cache/postgresql/dicts/it*
-rw-r--r-- 1 root root   80452 Oct  8 16:28 /var/cache/postgresql/dicts/it_it.affix
-rw-r--r-- 1 root root 1292843 Oct  8 16:28 /var/cache/postgresql/dicts/it_it.dict
0 root at stylus:~# apt-get purge myspell-it
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  myspell-it*
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
After this operation, 1,377 kB disk space will be freed.
Do you want to continue [Y/n]? 
(Reading database ... 271643 files and directories currently installed.)
Removing myspell-it ...
Purging configuration files for myspell-it ...
Processing triggers for postgresql-common ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
  bg_bg
  ca_es-valencia
  ca_es
  cs_cz
  da_dk
  de_de
  en_gb
  en_us
  eo
  et_ee
  fr
  he
  ku_tr
  lt_lt
  lv_lv
  nb_no
  nl
  nn_no
  pl
  pt
  pt_br
  ru_ru
  sk_sk
  sl_si
  sv_se
  uk_ua
[ ok ] Starting PostgreSQL 9.1 database server: main.
0 root at stylus:~# ls -la /var/cache/postgresql/dicts/it*
-rw-r--r-- 1 root root   80452 Oct  8 16:28 /var/cache/postgresql/dicts/it_it.affix
-rw-r--r-- 1 root root 1292843 Oct  8 16:28 /var/cache/postgresql/dicts/it_it.dict
0 root at stylus:~# ls -la /usr/share/postgresql/9.1/tsearch_data/it*
-rw-r--r-- 1 root root 1654 Sep 25 01:02 /usr/share/postgresql/9.1/tsearch_data/italian.stop
lrwxrwxrwx 1 root root   39 Oct  8 16:28 /usr/share/postgresql/9.1/tsearch_data/it_it.affix -> /var/cache/postgresql/dicts/it_it.affix
lrwxrwxrwx 1 root root   38 Oct  8 16:28 /usr/share/postgresql/9.1/tsearch_data/it_it.dict -> /var/cache/postgresql/dicts/it_it.dict
0 root at stylus:~# 
0 root at stylus:~# 

thanks for maintaining postgresql in debian!

       --dkg


-- System Information:
Debian Release: wheezy/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 3.5-trunk-686-pae (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-common depends on:
ii  adduser                   3.113+nmu3
ii  debconf [debconf-2.0]     1.5.46
ii  logrotate                 3.8.2-1
ii  lsb-base                  4.1+Debian7
ii  postgresql-client-common  136
ii  procps                    1:3.3.3-2
ii  ssl-cert                  1.0.32

postgresql-common recommends no packages.

postgresql-common suggests no packages.

-- debconf information:
  postgresql-common/obsolete-major: