Skip to content
Postgres service upgrade
1stodogwu
OP

2 months ago

I have been trying to upgrade to the version 18 but the upgrade process is hanging during pg_upgrade. This suggests pg_upgrade is running but not completing or crashing silently.

Solved

3 Replies

Railway
BOT

2 months ago

The major version upgrade attempt failed and the subsequent revert left your Postgres service running on a new, empty volume while your original data (~8.9 GB in the postgres-volume) is sitting detached but fully intact on our storage. Your data is not lost, and it can be recovered by reattaching that original volume to the service.


Status changed to Awaiting User Response Railway • 2 months ago


1stodogwu
OP

2 months ago

The main thing is why is the upgrading failing?


Status changed to Awaiting Railway Response Railway • 2 months ago


sam-a
EMPLOYEE

2 months ago

Every upgrade attempt failed at the same preflight check: your PG 16 database references a loadable library (extension) that is not included in the target version's image. The check logged "Checking for presence of required libraries ... fatal" and aborted before any data migration, which is why the process appeared to hang. The same blocker hit both the version 18 and version 17 targets. To identify the problematic extension, connect to your current PG 16 database and run SELECT * FROM pg_extension;, then cross-check each extension against what the target major ships. Drop or replace any that are not available in the new image, and retry the upgrade. Your original data (~8.9 GB) is still intact on a detached volume and has not been lost.


Status changed to Awaiting User Response Railway • 2 months ago


Status changed to Solved sam-a • 2 months ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...