Re: Best practise for upgrade of 24GB+ database

Поиск
Список
Период
Сортировка
От Nicholson, Brad (Toronto, ON, CA)
Тема Re: Best practise for upgrade of 24GB+ database
Дата
Msg-id EC55DC235432104F8255702A8D7344D925739880@G9W0741.americas.hpqcorp.net
обсуждение исходный текст
Ответ на Re: Best practise for upgrade of 24GB+ database  (francis picabia <fpicabia@gmail.com>)
Список pgsql-admin
> -----Original Message-----
> From: francis picabia [mailto:fpicabia@gmail.com]
> Sent: Friday, January 20, 2012 3:39 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Best practise for upgrade of 24GB+ database
> > In the past I've used Slony to upgrade much larger database clusters
> than yours with minimal down time (I'm talking seconds for the actual
> master switch).  You set up a new replica on the new version and then
> move the master from old to new.  No need to explicitly resync
> afterwards.
>
> That's great information.  9.0 is introducing streaming replication,
> so that is another option I'll look into.

Streaming rep will not help you here as you cannot replicated between versions with it.  Slony allows replication to a
newversion. 

Brad.

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Force explicit transactions on insert / update
Следующее
От: "Al-Salami, Adel"
Дата:
Сообщение: "service user account 'postgres' could not be created"