Package: postgresql
Version: 15+244
Severity: minor

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On previous upgrades to postgresql to a new major versions, you'd always
get a prompt and instructions how to upgrade the database cluster to the
new postgresql version. I did not get that with the upgrade to 15 though.

Relevant part of aptitude log:
================================================================
# aptitude safe-upgrade
...
Preparing to unpack .../027-postgresql-common_244_all.deb ...
Leaving 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by 
postgresql-common'
Unpacking postgresql-common (244) over (243) ...
Preparing to unpack .../028-postgresql-client-common_244_all.deb ...
Unpacking postgresql-client-common (244) over (243) ...
...
Selecting previously unselected package postgresql-client-15.
Preparing to unpack .../105-postgresql-client-15_15.0-1_amd64.deb ...
Unpacking postgresql-client-15 (15.0-1) ...
Selecting previously unselected package postgresql-15.
Preparing to unpack .../106-postgresql-15_15.0-1_amd64.deb ...
Unpacking postgresql-15 (15.0-1) ...
Preparing to unpack .../107-postgresql_15+244_all.deb ...
Unpacking postgresql (15+244) over (14+243) ...
...
Setting up postgresql-client-common (244) ...
...
Setting up postgresql-client-15 (15.0-1) ...
update-alternatives: using /usr/share/postgresql/15/man/man1/psql.1.gz to 
provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
...
Setting up postgresql-common (244) ...
grep: warning: stray \ before /
grep: warning: stray \ before /
grep: warning: stray \ before -
grep: warning: stray \ before /
...
Setting up postgresql-15 (15.0-1) ...
Creating new PostgreSQL cluster 15/main ...
/usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15/main --auth-local 
peer --auth-host scram-sha-256 --no-instructions
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  provider:    libc
  LC_COLLATE:  en_US.UTF-8
  LC_CTYPE:    en_US.UTF-8
  LC_MESSAGES: en_US.UTF-8
  LC_MONETARY: en_US.UTF-8
  LC_NUMERIC:  en_US.UTF-8
  LC_TIME:     nl_NL.UTF-8
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/15/main ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Europe/Amsterdam
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
update-alternatives: using /usr/share/postgresql/15/man/man1/postmaster.1.gz to 
provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
...
Setting up postgresql (15+244) ...
...
================================================================

Are the (cluster) upgrade instructions no longer needed? Is it done
automatically and thus no manual action is needed? Are users expected to
know what to do and how to do it? Anything else?

# pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
14  main    5432 online postgres /var/lib/postgresql/14/main 
/var/log/postgresql/postgresql-14-main.log
15  main    5433 online postgres /var/lib/postgresql/15/main 
/var/log/postgresql/postgresql-15-main.log


- -- System Information:
Debian Release: bookworm/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'testing-debug'), (500, 
'unstable'), (500, 'testing'), (500, 'stable'), (101, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 5.19.0-2-amd64 (SMP w/16 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages postgresql depends on:
ii  postgresql-15  15.0-1

postgresql recommends no packages.

Versions of packages postgresql suggests:
pn  postgresql-doc  <none>

- -- no debconf information

-----BEGIN PGP SIGNATURE-----

iHUEARYIAB0WIQT1sUPBYsyGmi4usy/XblvOeH7bbgUCY0mQqQAKCRDXblvOeH7b
bn0iAP9WaPTzPKaTCZn8HDatsPz/DP8hC+DY2+hhWWdY8ls9owD/QiEt4MFZPQb5
hjcE8JnI09aX/M2jPCYI629k/Yy/gQk=
=RuQa
-----END PGP SIGNATURE-----

Reply via email to