From: Alain Bourgeois <alain.bourgeois@zetes.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: RE: pg_upgrade -c cannot be run if old cluster is running
Thread-Topic: pg_upgrade -c cannot be run if old cluster is running
Thread-Index: AQHa/uFJ1aOyTlHXcEqR/dv06Qzpr7JIGRwAgADZqZA=
Date: Thu, 5 Sep 2024 09:45:02 +0000
Message-ID: 
 <PAXP191MB1712718D658ACACE08617C8BF09D2@PAXP191MB1712.EURP191.PROD.OUTLOOK.COM>
References: <172546462173.8361.7114078895863039790@wrigleys.postgresql.org>
 <1692842.1725482754@sss.pgh.pa.us>
In-Reply-To: <1692842.1725482754@sss.pgh.pa.us>
Accept-Language: en-US, fr-BE
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?CmpAQsaidRQWDXvaMvPgP9iP0O8YyThf57IX77H0+2tRxQ2+KOmE27YnVNTW?=
 =?us-ascii?Q?RrCn/4UFRhuDI7PJSZA2Ky58Pec27d4nB4yBny0S+H9jImd9z0PfU27YO0l4?=
 =?us-ascii?Q?FJS62adAVEiqZMC3kLM9oV3G/HWpe35ZElF0znLEqHf/LJElnRfKR0wPNMpA?=
 =?us-ascii?Q?ELMBu6LZT7joFakcWTe1TKCRZ6mpdjGe0FIim67g04EQX2mgW/AczMjxkaYF?=
 =?us-ascii?Q?7zPnjeSSc4heU9JwvNp/9Evwhp2iAgnWCd7sxVZJyWZqjbX5QJrWOqJ4ieLE?=
 =?us-ascii?Q?Q8nnFky4TI0BQHjlHX0JMMzS0DD+igYhXPQ5ZVfbqQsQS816Z7IJGHBsmCTc?=
 =?us-ascii?Q?LfIL4/DF5+3EEKyGTyur22fzcCbF/6qFU4Rkr2gGSxFu8jIC52DeQfNQnNsF?=
 =?us-ascii?Q?WZPLkMPEp8I1W3Pt5yKMnoSSoC1rPWPFaJIkkTc3U/NXZZLo2rhktTdp/Iit?=
 =?us-ascii?Q?8CWH9ZmU1KU2hUofDgHWDsU4WbbTGjmB9NOP3Ga/bIvrV/UskE4mppHkELwp?=
 =?us-ascii?Q?MBsX79AVVUvwEHOzxX76zGjgraAR+ujfwtuGgdmEwg7xgobhtrv3eFgD3Qse?=
 =?us-ascii?Q?GPcfRalYdioDQcJ9bOTQFQkSlB6s9+Q0lQrpB9IXwsZMwEvo9jP1v2/UvNTh?=
 =?us-ascii?Q?0chGLdn/522OoCMB+sYhnazmxKAjmB9oaGPOQwHdJE5hbOW11Zb34VWJ4DtZ?=
 =?us-ascii?Q?ThFtEapa8zmlJ2IfWXbuq2CWCSNjPOMqahG7Ua+LXyQHRP2D0vl4GlMg2qW7?=
 =?us-ascii?Q?9oJnctKnefi57NNKHtIc3V4NXw1sSKlNLZALD2qbl7C7rkQ5mkkrmuaLz3NR?=
 =?us-ascii?Q?tw1RurdMaULsGjAPylO8AFJpZqwRywKvWZZZBYIqI+CUGkDGQ8OBO7+bvsn/?=
 =?us-ascii?Q?OW744JFAr77KF3pjGYyw915qas9egwBW59USA4YWeoqFH/AiDuj5u5KE5zrY?=
 =?us-ascii?Q?yJP2qq0U+bkPrzQg3FUWQ0XFQhc7RYnjgY/XD6CfMmEw2n6lz7ZJPjKQNEdh?=
 =?us-ascii?Q?IsaOQbMntwDvA/S8sd09eoRwzn8oNFXdOzN8J7rPQyIQ+8uCDwwxRajSFxQo?=
 =?us-ascii?Q?PYgXO8yGdobNLst+9He0+ljKbkIJRyM8dHuTrH20aR6pqY67e+tuv76zXI6t?=
 =?us-ascii?Q?owVnNFjJ7xUUwdtdFfAsdhfHENxKsFNIy1+aXjmQxN8h2hqgJxhQgqH+uKdx?=
 =?us-ascii?Q?GlTRrw1z/gwA6WUsnVf8Usv9WOxKD8jpDrJWne1Cx+e7CwBHCtlhJrWoaBbn?=
 =?us-ascii?Q?Pjbmd5YuM5L4TJf6PDDBgrCXCM9XgzBgc+b2KpqfScdCMgFxL+Oci7AlgQDA?=
 =?us-ascii?Q?a4b9gpgVL4wUH8xQH1iTwZz5SVPhe2PoIxQtVtR4ccttInjOORvvbHz8yN04?=
 =?us-ascii?Q?9K1eJPl2WlhyygAB9mJih0XRqQGcMUUBVGnA622ZadM700xoq7aM0XQ0O8p1?=
 =?us-ascii?Q?uI7hZJp1JMB0QmZJ4sK3uJgpl5ndcsXtibhPDhjVJBFchHDXUNdgzIhfR5GJ?=
 =?us-ascii?Q?9oLfe43NskZ1m38tIutAxShDACcv0OZDqPIqYOF8Cf5++yt1ol2QCZwpKzW4?=
 =?us-ascii?Q?p8XpoONPeJgF8nG7a83gcRqZCR2t9fn7pxk5fIQp?=
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: zetes.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PAXP191MB1712.EURP191.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 6fc28293-8ee7-4b5f-17a1-08dccd8f69fa
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Sep 2024 09:45:02.1316
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: f92badf4-a21b-4ddb-bae6-00e040c26fb8
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 WEqrpieoT0Iz/0FN1Szk/znKAlJgGGAd72+IX24pBCIxfUed4e9genVsaAAhqxmCNCz3KMm3doN+NL1Kkrm9IIhYTFWUEBEzWlTo43FTD9k=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3P191MB0875
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/PAXP191MB1712718D658ACACE08617C8BF09D2%40PAXP191MB1712.EURP191.PROD.OUTLOOK.COM>
Precedence: bulk

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 -Upos=
tgres -v
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
Current pg_control values:

pg_control version number:            1002
Catalog version number:               201707211
Database system identifier:           6631834114473972710
Latest checkpoint's TimeLineID:       1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0:555
Latest checkpoint's NextOID:          13809
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        548
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Size of a large-object chunk:         2048
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           0


Values to be changed:

First log segment after reset:        000000010000000000000002
Current pg_control values:

pg_control version number:            1300
Catalog version number:               202209061
Database system identifier:           7410372953202657258
Latest checkpoint's TimeLineID:       1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0:732
Latest checkpoint's NextOID:          16387
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        716
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Size of a large-object chunk:         2048
Date/time type storage:               64-bit integers
Float8 argument passing:              by value

Data page checksum version:           0


Values to be changed:

First log segment after reset:        000000010000000000000002
"/usr/pgsql-10/bin/pg_ctl" -w -l "/mnt/pgdata/pgdirbc15/pg_upgrade_output.d=
/20240905T083735.457/log/pg_upgrade_server.log" -D "/var/lib/pgsql/10/data"=
 -o "-p 5432 -b  -c listen_addresses=3D'' -c unix_socket_permissions=3D0700=
 -c unix_socket_directories=3D'/var/lib/pgsql'" start >> "/mnt/pgdata/pgdir=
bc15/pg_upgrade_output.d/20240905T083735.457/log/pg_upgrade_server.log" 2>&=
1

*failure*
There were problems executing ""/usr/pgsql-10/bin/pg_ctl" -w -l "/mnt/pgdat=
a/pgdirbc15/pg_upgrade_output.d/20240905T083735.457/log/pg_upgrade_server.l=
og" -D "/var/lib/pgsql/10/data" -o "-p 5432 -b  -c listen_addresses=3D'' -c=
 unix_socket_permissions=3D0700 -c unix_socket_directories=3D'/var/lib/pgsq=
l'" start >> "/mnt/pgdata/pgdirbc15/pg_upgrade_output.d/20240905T083735.457=
/log/pg_upg
rade_server.log" 2>&1"
Consult the last few lines of "/mnt/pgdata/pgdirbc15/pg_upgrade_output.d/20=
240905T083735.457/log/pg_upgrade_server.log" for the probable cause of the =
failure.

connection to server on socket "/var/lib/pgsql/.s.PGSQL.5432" failed: No su=
ch file or directory
Is the server running locally and accepting connections on that socket?

could not connect to source postmaster started with the command:
"/usr/pgsql-10/bin/pg_ctl" -w -l "/mnt/pgdata/pgdirbc15/pg_upgrade_output.d=
/20240905T083735.457/log/pg_upgrade_server.log" -D "/var/lib/pgsql/10/data"=
 -o "-p 5432 -b  -c listen_addresses=3D''=20
-c unix_socket_permissions=3D0700 -c unix_socket_directories=3D'/var/lib/pg=
sql'" start
Failure, exiting