Re: Streaming Replication - Error on Standby

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Streaming Replication - Error on Standby
Дата
Msg-id CAGrpgQ8_NxTKYyz1HEH3K4RdLjvs8JaZ_mRvz52JzrKvta2FTw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Streaming Replication - Error on Standby  (bobJobS <russelljanusz@yahoo.com>)
Список pgsql-general
On Tue, Feb 11, 2014 at 11:25 AM, bobJobS <russelljanusz@yahoo.com> wrote:

To get the standby server to a point, I tool a globals dump and a data dump
of the primary server and build the standby.

Then I executed pg_startbackup, rsync data dir to standby data dir (to catch
any changes made while I was building the standby) and finally
pg_stopbackup... all on the primary.


The steps you are using will not work. You cannot use a pg_dump/pg_dump backup from a master to set up a slave. pg_dump generates a "logical" backup, which is used for recovery not setting up slaves.  A very high-level view of the replication setup:
- put the master in backup mode
- pg_basebackup of the master to the slave (no slave data exists prior to this step)
- take the master out of backup mode

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

Предыдущее
От: bobJobS
Дата:
Сообщение: Re: Streaming Replication - Error on Standby
Следующее
От: John R Pierce
Дата:
Сообщение: Re: