Arch Linux

czert

Member

Registered: 2015-05-23

Posts: 5

can't upgrade postgresql database via pg_upgrade: missing subdirectory

Hi everyone,

I hope this is the right forum category to post this in.

I'm having a problem upgrading my postgres cluster to version 9.4, from version 9.3 (I think, can't be completely sure). I followed the normal procedure as outlined in the wiki, but when I run the pg_upgrade script itself, the consistency checks won't pass:

Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
connection to database failed: FATAL:  database "studio" does not exist
DETAIL:  The database subdirectory "pg_tblspc/16414/PG_9.3_201306121/16439" is missing.

Failure, exiting

Now, even if the database "studio" is corrupted, I'd like to save the rest of my databases. I don't have the old version of postgresql package cached anymore, so I don't know how to try and access the rest of the cluster. Can anyone point me in the right direction?

Also, I haven't needed to use postgresql for some time now, so the case may be that the old version was actually 9.2 and I'm unknowingly trying to skip a version. But that first check of cluster versions done by pg_upgrade says "ok", so hopefully that's not what's happening.

twelveeighty

Member

Registered: 2011-09-04

Posts: 1,452

Re: can't upgrade postgresql database via pg_upgrade: missing subdirectory

Please post the full command with options that are using to run pg_upgrade.  Also check pacman.log to see what you were upgrading from.

Partial upgrades are not supported on Arch, so they won't happen automatically unless you are using IgnorePkg / IgnoreGroup in pacman.conf.  Therefore, I think what happened is that when postgresql was upgraded from 9.2 to 9.3 a while ago, you did not migrate your databases. So the 9.3 upgrade utility is trying to upgrade a 9.2 database to 9.4, and that's failing.

If you can confirm this is the case, then I think you should be able to downgrade the postgresql and postgresql-old-upgrade  packages to their 9.3 state and then convert your db to 9.3. Then update both to the latest version and upgrade the db from 9.3 to 9.4.

Take lots of backups in between, of course.