[PG_UPGRADE] 9.6 to 10.5

Hi,

I tried to upgrade my PGSQL cluster from 9.6 to 10.5 version through pg_upgrade tool.

I followed the actions noticed in the documentation (https://www.postgresql.org/docs/10/static/pgupgrade.html) and those noticed in the man page of pg_upgrade.

My both clusters (source and target) have been closed with pg_ctl –D /DATA/CLS/clsdata stop commands.

When I try to upgrade my cluster with the following command :

pg_upgrade --old-datadir "/DATA/PPEM/clsdata" --new-datadir "/DATA/PPEM73/clsdata" --old-bindir "/u01/app/postgres/product/9.6.3.0/DERIV01/bin" --new-bindir "/u01/app/postgres/product/10.5.0.0/DERIV01/bin"

Postgres raise the following error :

Performing Consistency Checks

-----------------------------

Checking cluster versions                                   ok

The source cluster was not shut down cleanly.

Failure, exiting

I tried to restart and shutdown clusters with another methods (-m options of pg_ctl, killing processes, …) still have the same issue.

Best regards,

Rémi DEGLAVE

Database Administrator

Lyreco
Phone: +33 (0)3 27 23 42 33
Rue du 19 Mars 1962 - 59770 MARLY - FRANCE
http://www.lyreco.com

supporting the educational development of children throughout the world.
Please, click here to discover Lyreco Actions for children.