Re: pg_upgrade & tablespaces

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: pg_upgrade & tablespaces
Дата
Msg-id 52C33F13.3040401@gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade & tablespaces  (Joseph Kregloh <jkregloh@sproutloud.com>)
Список pgsql-general
On 12/31/2013 01:51 PM, Joseph Kregloh wrote:
>         So you have not upgraded the tablespaces. What is important to
>         remember is Postgres uses numbers to keep track of relations.
>         Part of the upgrade process involves changing the numbers that
>         point at relations. By manually dropping a 9.0 tablespace into a
>         9.3 data directory you have broken that system. You need to let
>           pg_upgrade do the translation. See my previous message below
>         for a possible solution:
>
>
>
> Sorry, I may not have been to clear on my explenation, pg_upgrade
> creates the 9.3 data directories inside the tablespace folders and those
> are the ones I moved. So pg_upgrade finishes it's job.

Can we see a listing of the tablespace and pg_tblspc?

--
Adrian Klaver
adrian.klaver@gmail.com


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

Предыдущее
От: Joseph Kregloh
Дата:
Сообщение: Re: pg_upgrade & tablespaces
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade & tablespaces