Re: Using pg_upgrade on log-shipping standby servers

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Using pg_upgrade on log-shipping standby servers
Дата
Msg-id 20120719160258.GB20583@momjian.us
обсуждение исходный текст
Ответ на Re: Using pg_upgrade on log-shipping standby servers  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Using pg_upgrade on log-shipping standby servers  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Thu, Jul 19, 2012 at 09:41:29AM -0400, Robert Haas wrote:
> On Thu, Jul 19, 2012 at 2:38 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > No, the point is they run pg_upgrade on the stopped primary and stopped
> > standbys.  Are those the same?  I am not really sure.
> 
> Of course not.

OK, but why?  When the clusters are stopped they are the same, you are
running the same initdb on both matchines, and running the same
pg_upgrade.  What would cause the difference, other than the Database
System Identifier, which we can deal with?  I don't think we can
guarantee they are the same, but what would guarantee they are
different?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


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

Предыдущее
От: Joel Jacobson
Дата:
Сообщение: [PATCH] pg_dump: Sort overloaded functions in deterministic order
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [PERFORM] DELETE vs TRUNCATE explanation