What to do with tablespaces when upgrading to pg13 from pg1X?

From: James(王旭) <wangxu(at)gu360(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: What to do with tablespaces when upgrading to pg13 from pg1X?
Date: 2021-01-12 02:28:52
Message-ID: tencent_054F2BAA623053795C9BE722@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I was planning to upgrade from 12 to 13 using this command:
/usr/pgsql-13/bin/pg_upgrade -b /usr/pgsql-12/bin/ -B /usr/pgsql-13/bin/ -d /data/pg/ -D /pg/pgdata_13/ --jobs=10

And I got this output:
Checking for presence of required libraries&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ok
Checking database user is the install user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ok
Checking for prepared transactions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ok
Checking for new cluster tablespace directories
new cluster tablespace directory already exists: "/data/tsdb/metas/PG_13_202007201"
Failure, exiting
I think it's because /data/tsdb was my tablespace dir which was out of the old main data directory(/data/pg/).

So what should I do with old tablespaces when upgrading ?

Thanks a lot !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2021-01-12 02:45:42 Re: What to do with tablespaces when upgrading to pg13 from pg1X?
Previous Message Jack Orenstein 2021-01-11 18:44:51 Re: Static memory, shared memory