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

Поиск
Список
Период
Сортировка
От James(王旭)
Тема What to do with tablespaces when upgrading to pg13 from pg1X?
Дата
Msg-id tencent_054F2BAA623053795C9BE722@qq.com
обсуждение исходный текст
Ответы Re: What to do with tablespaces when upgrading to pg13 from pg1X?  (Bruce Momjian <bruce@momjian.us>)
Список 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                 ok
Checking database user is the install user                  ok
Checking for prepared transactions                          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 !

В списке pgsql-general по дате отправления:

Предыдущее
От: Jack Orenstein
Дата:
Сообщение: Re: Static memory, shared memory
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: What to do with tablespaces when upgrading to pg13 from pg1X?