[PG_UPGRADE] 9.6 to 10.5

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.

Responses

Browse pgsql-bugs by date

  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