Re: archive_command and streaming replication

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Scott Briggs *EXTERN*" <scott(dot)br(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: archive_command and streaming replication
Date: 2012-05-18 08:04:49
Message-ID: D960CB61B694CF459DCFB4B0128514C207E6A71A@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor 2012-05-18 08:34:17 One schema per different databases
Previous Message Sergey Konoplev 2012-05-18 07:40:42 Re: Replication recovery?