RE: pg_upgrade -c cannot be run if old cluster is running

2024-09-05 Thread Alain Bourgeois
When the cluster was created, we did initdb /var/lib/pgsql10/data, the storagebox was not available. Then storagebox was delivered, we copied data folder to storagebox in /mnt/pgdata/pgdir and changed postgresql.conf. We didn't delete existing datafiles from /var/lib/pgsql10/data (db was empty)

RE: pg_upgrade -c cannot be run if old cluster is running

2024-09-05 Thread Alain Bourgeois
Tried (as postgres) /usr/pgsql-15/bin/pg_upgrade --check -b /usr/pgsql-10/bin/ -B /usr/pgsql-15/bin -d /var/lib/pgsql/10/data -D /mnt/pgdata/pgdirbc15 -p5432 -P5455 -Upostgres -v Running in verbose mode Performing Consistency Checks - Checking cluster versions

RE: pg_upgrade -c cannot be run if old cluster is running

2024-09-05 Thread Alain Bourgeois
Here is what can be said about config (no extension, nothing special) There are already one postgresql-15 services (separate cluster, on ports <>5432) that run on this machine, and there is also one postgres 10 cluster (on port 5432). The aim is to update the 10 to 15 to get rid of v10. So we cre