Re: Weird error when setting up streaming replication
| От | Quentin Hartman |
|---|---|
| Тема | Re: Weird error when setting up streaming replication |
| Дата | |
| Msg-id | CAJ48qNbQ1wKYNcHL8YVS5s_GeQUPaTyAoBZYhBJHA4Qhk8GMiA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Weird error when setting up streaming replication (Michael Paquier <michael.paquier@gmail.com>) |
| Ответы |
Re: Weird error when setting up streaming replication
Re: Weird error when setting up streaming replication |
| Список | pgsql-general |
This pair of servers aren't replacing anything, they are new, empty servers. Before starting the slave at all, I'm copying the entire data filestructure over to it via rsync. I'm doing almost exactly what is described here: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Binary_Replication_in_6_Steps . The only different is that I've tweaked the paths on the rsync to be appropriate to my system layout. I've even gone so far as to delete everything in the data dir except for the pg_xlog directory before syncing everything over to make sure it wasn't caused by something not getting overwritten when it was supposed to.
On Thu, Aug 8, 2013 at 6:23 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Fri, Aug 9, 2013 at 8:55 AM, Quentin HartmanIt looks that you are not able to detect valid checkpoint records when
<qhartman@direwolfdigital.com> wrote:
> 2013-08-08 23:47:30 GMT LOG: WAL file is from different database system
> 2013-08-08 23:47:30 GMT DETAIL: WAL file database system identifier is
> 5909892614333033983, pg_control database system identifier is
> 5909892824786287231.
replaying WAL because your new system has been initialized with a
fresh initdb, symbolized by the errors above. You should build your
new node using a base backup or a snapshot of the data folder of the
node you are trying to replace.
--
Michael
В списке pgsql-general по дате отправления: