Re: archive_command and streaming replication - Mailing list pgsql-general

From Albe Laurenz
Subject Re: archive_command and streaming replication
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207E6A71A@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: archive_command and streaming replication  (Scott Briggs <scott.br@gmail.com>)
List pgsql-general
Scott Briggs wrote:
> So if you do need to use wal files to catch up a slave, what would
> that process be?  If you caught up with wal files, how would streaming
> replication know what positon to start at? And how would you tell
> streaming replication the new position after catching up with wal
> files?

See
http://www.postgresql.org/docs/9.1/static/warm-standby.html#STANDBY-SERV
ER-OPERATION,
particularly the second paragraph.

WAL records are ordered, so the standby can request the correct
WAL record when it connects to the primary.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Replication recovery?
Next
From: Igor
Date:
Subject: One schema per different databases