Reputation: 23
Postgres upgrade(10.9 to 12.2) is failing sporadically
But we observed, upgrade fails sometimes at 'check' step (pg_upgrade --check
)
and some other times fails at 'link' (pg_upgrade --link
) step though check step was success.
with below logs
pg_upgrade --check
fails with below output
[-----------------------------]
[Performing Consistency Checks]
[Checking cluster versions ok]
[Checking database user is the install user ok]
[Checking database connection settings ok]
[Checking for prepared transactions ok]
[Checking for reg* data types in user tables ok]
[Checking for contrib/isn with bigint-passing mismatch ok]
[Checking for tables WITH OIDS ok]
[Checking for invalid "sql_identifier" user columns ok]
[]
[*failure*]
[]
Failed at "Checking for presence of required libraries"
some other times pg_upgrade --link
fails with below output
[-----------------------------]
[][Checking cluster versions ok]
[Checking database user is the install user ok]
[][Checking database connection settings ok]
[][Checking for prepared transactions ok]
[][Checking for reg* data types in user tables ok]
[][Checking for contrib/isn with bigint-passing mismatch ok]
[][Checking for tables WITH OIDS ok]
[][Checking for invalid "sql_identifier" user columns ok]
[][Creating dump of global objects ok]
[][Creating dump of database schemas]
[][ postgres]
[][*failure*]
Failed at "Checking for presence of required libraries"
Note:
Upvotes: 1
Views: 231