From: | DEGLAVE Remi <remi(dot)deglave(at)lyreco(dot)com> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | [PG_UPGRADE] 9.6 to 10.5 |
Date: | 2018-08-10 12:51:29 |
Message-ID: | AM6PR02MB3782E6A52BDA2A806B6A587AFE240@AM6PR02MB3782.eurprd02.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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,
[bouton]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<http://www.lyreco.com/>
[ligne]
[lfe]supporting the educational development of children throughout the world.
Please, click here<http://www.youtube.com/user/verylyrecopeople#p/u> to discover Lyreco Actions for children.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2018-08-10 13:45:48 | Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 |
Previous Message | Andres Freund | 2018-08-10 02:26:34 | Re: BUG #15320: = any (array(SQL)) ERROR: invalid memory alloc request size 1073741824 |