Re: pg_upgrade vs. pg_dump

Поиск
Список
Период
Сортировка
От Stéphane Wirtel
Тема Re: pg_upgrade vs. pg_dump
Дата
Msg-id 67A7D71F-28F7-4280-9EFF-8A92169AF9A1@wirtel.be
обсуждение исходный текст
Ответ на pg_upgrade vs. pg_dump  ("Perry, Hemy" <hemy_perry@mentor.com>)
Ответы Re: pg_upgrade vs. pg_dump  ("Perry, Hemy" <hemy_perry@mentor.com>)
Список pgsql-admin
On 20 Jan 2015, at 20:22, Perry, Hemy wrote:

> Hello,
>
> I am planning  a migration from 9.1.7 to 9.4.0.
> Based on my understanding, the recommendation is to use pg_upgrade
> over 'dump and restore'.
> Is that right?
You can compile the twice versions of PostgreSQL on the same computer
and just execute the upgrade with pg_upgrade and the right parameters.


>
> If I want to use pg_upgrade, I need to provide the -b bindir
> (--old-bindir=bindir) and so my second question is what if I'll
> provide 9.4 (the new PostgreSQL executable directory) also as the
> 'old-bindir', can it work that way? Always?
> [I am trying to solve a problem that I might not have the old-bindir
> available on the machine and only the new-bindir will be available (as
> well as the old & new datadir of course :)]
>
> Thanks
> Hemy


--
Stéphane Wirtel - http://wirtel.be - @matrixise


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

Предыдущее
От: "Perry, Hemy"
Дата:
Сообщение: pg_upgrade vs. pg_dump
Следующее
От: Glyn Astill
Дата:
Сообщение: Re: cannot drop an extension