Re: Best practice for 8.1.5 -> 8.2 migration - with big database?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Best practice for 8.1.5 -> 8.2 migration - with big database?
Дата
Msg-id 200702142113.11307.peter_e@gmx.net
обсуждение исходный текст
Ответ на Best practice for 8.1.5 -> 8.2 migration - with big database?  ("Mason Hale" <masonhale@gmail.com>)
Список pgsql-general
Mason Hale wrote:
> So, I'm fishing to see of there are alternatives to taking our
> production database down for 6+ hours do this upgrade. Can slony or
> wal files be of help here?

Slony can, but WAL files will not work between different versions.

> Also -- due to hardware limitations, we need to install 8.2.x on the
> same hardware 8.1.5 is currently running on. Can those two versions
> exist side-by-side?

Sure.  Just set a different port and different data directory.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Protect PL/PGSQL source
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: backup database by cloning itself