Re: pg_upgrade & tablespaces

Поиск
Список
Период
Сортировка
Искать
От
John R Pierce
Тема
Re: pg_upgrade & tablespaces
Дата
Msg-id
52B361A7.1040302@hogranch.com
Ответ на
Список
Дерево обсуждения
pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces John R Pierce <pierce@hogranch.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces John R Pierce <pierce@hogranch.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces John R Pierce <pierce@hogranch.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces John R Pierce <pierce@hogranch.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Jeff Janes <jeff.janes@gmail.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Ziggy Skalski <zskalski@afilias.info>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Adrian Klaver <adrian.klaver@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Sergey Konoplev <gray.ru@gmail.com>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Sergey Konoplev <gray.ru@gmail.com>
Re: pg_upgrade & tablespaces Bruce Momjian <bruce@momjian.us>
Re: pg_upgrade & tablespaces Joseph Kregloh <jkregloh@sproutloud.com>
Re: pg_upgrade & tablespaces Sergey Konoplev <gray.ru@gmail.com>
Re: pg_upgrade & tablespaces Jeff Janes <jeff.janes@gmail.com>
On 12/19/2013 1:06 PM, Joseph Kregloh wrote:
> It's easier to keep things segregated. It is not anymore different 
> than doing the upgrade in the same jail. Which at the end of the day 
> you are doing the upgrade in the same jail, because at the end of the 
> day pg_upgrade just needs the old data an binary to start and create 
> some dump files.

pg_upgrade needs to access the old data AND all the tablespaces at the 
same paths as the old server sees them AND the new data and tablespaces 
at the same path as the NEW server sees them.   if the two servers are 
in different jails, I don't see how you could make that work... if you 
run pg_upgrade in the host system, then all the paths are different for 
both sets of data and tablespaces.





-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast


В списке pgsql-general по дате отправления
От: Sergey Konoplev
Дата:
Сообщение: Re: pg_upgrade & tablespaces
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade & tablespaces
FAQ