Re: Standby server startup question - not broken, just curious

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Scott Whitney <swhitney(at)journyx(dot)com>, Scott Whitney <scott(at)journyx(dot)com>
Cc: John Scalia <jayknowsunix(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Standby server startup question - not broken, just curious
Date: 2014-12-17 16:02:13
Message-ID: 70C21D6D-6C0C-4CE9-BBD5-36836B76D6C4@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Dec 17, 2014, at 8:49 AM, Scott Whitney <scott(at)journyx(dot)com> wrote:
>
> This is _always_ somewhere in a WAL, hence wal_keep_segments. If this is set sufficiently high, you don't _need_ WAL archiving. It will find the missing pieces from those, replay, and get back into streaming mode.

In addition, I believe it looks for local WAL copy first, before fetching from primary.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shayra Sharma 2014-12-17 16:22:02 PostgreSQL
Previous Message Scott Whitney 2014-12-17 15:49:01 Re: Standby server startup question - not broken, just curious