Package: postgresql-common Version: 264 Severity: important File: /usr/bin/pg_upgradecluster
Dear Maintainer, I just tried upgrading my 16 cluster to 17, and pg_upgradecluster fails to do the upgrade. I tried this on 2 different machines with different architectures, to the same exact failure. Follows the log of that in the second one: ----------------8<----------------8<----------------8<----------------- root@ava:~# pg_dropcluster --stop 17 main root@ava:~# pg_upgradecluster -m clone 16 main 17 ADVERTÊNCIA: o banco de dados "template1" possui uma de versão de ordenação sem correspondência DETAIL: O banco de dados foi criado usando a versão de ordenação 2.39, mas o sistema operacional fornece a versão 2.40. HINT: Reconstrua todos os objetos nesse banco de dados que usam a ordenação padrão e execute ALTER DATABASE template1 REFRESH COLLATION VERSION, ou construa o PostgreSQL com a versão correta da biblioteca. ADVERTÊNCIA: o banco de dados "template1" possui uma de versão de ordenação sem correspondência DETAIL: O banco de dados foi criado usando a versão de ordenação 2.39, mas o sistema operacional fornece a versão 2.40. HINT: Reconstrua todos os objetos nesse banco de dados que usam a ordenação padrão e execute ALTER DATABASE template1 REFRESH COLLATION VERSION, ou construa o PostgreSQL com a versão correta da biblioteca. Stopping old cluster... Creating new PostgreSQL cluster 17/main ... /usr/lib/postgresql/17/bin/initdb -D 17 --auth-local peer --auth-host scram-sha-256 --no-instructions --encoding UTF8 --lc-collate pt_BR.UTF-8 --lc-ctype pt_BR.UTF-8 --locale-provider libc 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: locale provider: libc LC_COLLATE: pt_BR.UTF-8 LC_CTYPE: pt_BR.UTF-8 LC_MESSAGES: C.UTF-8 LC_MONETARY: C.UTF-8 LC_NUMERIC: C.UTF-8 LC_TIME: C.UTF-8 The default text search configuration will be set to "portuguese". Data page checksums are disabled. fixing permissions on existing directory 17 ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... America/Bahia creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok Copying old configuration files... Copying old start.conf... Copying old pg_ctl.conf... Running init phase upgrade hook scripts ... /usr/lib/postgresql/17/bin/pg_upgrade -b /usr/lib/postgresql/16/bin -B /usr/lib/postgresql/17/bin -p 5432 -P 5433 -d /etc/postgresql/16/main -D /etc/postgresql/17/main --clone Finding the real data directory for the source cluster ok Finding the real data directory for the target cluster 2024-10-11 11:49:15.555 GMT [37914] LOG: skipping missing configuration file "/var/log/postgresql/pg_upgradecluster-16-17-main.evvf/17/postgresql.auto.conf" ok could not read permissions of directory "/var/log/postgresql/pg_upgradecluster-16-17-main.evvf/17": No such file or directory Failure, exiting Error during cluster dumping, removing new cluster Cluster is not running. Starting old cluster again ... root@ava:~# ----------------8<----------------8<----------------8<----------------- /var/log/postgresql/pg_upgradecluster-16-17-main.evvf/ is created by pg_upgradecluster, but it seems that pg_upgrade is looking for an extra "17" directory inside that? Maybe this is a bug in pg_upgrade. -- System Information: Debian Release: trixie/sid APT prefers testing APT policy: (900, 'testing'), (500, 'stable-security'), (500, 'unstable'), (1, 'experimental') Architecture: arm64 (aarch64) Kernel: Linux 6.10.11-arm64 (SMP w/32 CPU threads) Locale: LANG=pt_BR.UTF-8, LC_CTYPE=pt_BR.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages postgresql-common depends on: ii adduser 3.137 ii debconf [debconf-2.0] 1.5.87 ii init-system-helpers 1.67 ii libjson-perl 4.10000-1 ii perl 5.38.2-5 ii postgresql-client-common 264 ii ssl-cert 1.1.3 ii sysvinit-utils [lsb-base] 3.10-2 ii ucf 3.0043+nmu1 Versions of packages postgresql-common recommends: ii e2fsprogs 1.47.1-1 ii logrotate 3.22.0-1 postgresql-common suggests no packages. -- debconf information: postgresql-common/catversion-bump: * postgresql-common/obsolete-major: postgresql-common/ssl: true
signature.asc
Description: PGP signature
