Package: postgresql-common
Version: 200+deb10u1
Severity: important
The upgrade message has urgency=high and uses language giving much
importance to what is written, speaking about db corruption, but is not
usable for those like me who do not know how postres works.
Specifically:
1) if that is really urgent, why the upgrade script does not do it
itself, or at least gives interactive guidance on how to do it?
2) the suggested command 'postgres reindexdb --all' does not exist on my
system, at least not in the PATH; the only executable I found which
is named postgres is /usr/lib/postgresql/11/bin/postgres, but I do
not know if it's the right one
3) I found a reindexdb command in the PATH, and tried that one, but I
get
# reindexdb --all
reindexdb: could not connect to database template1: could not connect to
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5433"?
I can see that there is a socket at
/var/run/postgresql/11-main.pg_stat_tmp, but I do not know if that's
the right one
4) I tried the suggested alternative pg_upgradecluster, but I get:
# pg_upgradecluster
Usage: /usr/bin/pg_upgradecluster [OPTIONS] <old version> <cluster name> [<new
data directory>]
and again I do not know what to do.
Aptitude tells me that I have postgresql installed because
# aptitude why postgresql-11
i wwwconfig-common Suggests postgresql-client
i A postgresql-client Depends postgresql-client-11
i A postgresql-client-11 Suggests postgresql-11
so apparently I don't need it and unistalled it, but I suppose the above
observations still hold
Thank you for maintaining this piece of software
--
IPIN'19 http://ipin2019.isti.cnr.it Voice: +39.050.621.3058
Francesco Potortì (ricercatore) Mobile: +39.348.8283.107
ISTI - Area della ricerca CNR Skype: wnlabisti
via G. Moruzzi 1, I-56124 Pisa Web: http://fly.isti.cnr.it
-- System Information:
Debian Release: buster/sid
APT prefers testing
APT policy: (990, 'testing'), (101, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.19.0-4-amd64 (SMP w/4 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE,
TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8),
LANGUAGE=C:en_GB:en:en_US:it:fr:es (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages postgresql-common depends on:
ii adduser 3.118
ii debconf [debconf-2.0] 1.5.71
ii lsb-base 10.2019031300
ii postgresql-client-common 200+deb10u1
ii procps 2:3.3.15-2
ii ssl-cert 1.0.39
ii ucf 3.0038+nmu1
Versions of packages postgresql-common recommends:
ii e2fsprogs 1.44.5-1
ii logrotate 3.14.0-4
Versions of packages postgresql-common suggests:
ii libjson-perl 4.02000-1
-- debconf information:
postgresql-common/catversion-bump:
postgresql-common/ssl: true
* postgresql-common/obsolete-major:
