Re: database system identifier differs between the primary and standby

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: database system identifier differs between the primary and standby
Дата
Msg-id BANLkTinYxC8dX=FO6G0saOBHWYzZVVs+Tg@mail.gmail.com
обсуждение исходный текст
Ответ на database system identifier differs between the primary and standby  (rajibdk <rajib.deka@siemens.com>)
Ответы Re: database system identifier differs between the primary and standby  (rajibdk <rajib.deka@siemens.com>)
Список pgsql-hackers
On Wed, Apr 20, 2011 at 9:28 AM, rajibdk <rajib.deka@siemens.com> wrote:
> We are getting the following log while configuring hot standby,
>
> 2011-04-20 17:34:40 ETC/GMT FATAL:  the database system is starting up
> 2011-04-20 17:34:41 ETC/GMT FATAL:  database system identifier differs
> between the primary and standby
> 2011-04-20 17:34:41 ETC/GMT DETAIL:  The primary's identifier is
> 5592072752411433371, the standby's identifier is 5597615802844953578.
>
> PostgreSQL Version: 9.0.2

You need to initialize the slave using a hot backup taken on the master.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: setlocale() on Windows doesn't work correctly if the locale name
Следующее
От: David Fetter
Дата:
Сообщение: Re: pgbench \for or similar loop