Re: Hot standby & SR - log shipping required?

From: Ray Stell <stellr(at)vt(dot)edu>
To: rod(at)iol(dot)ie
Cc: "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Hot standby & SR - log shipping required?
Date: 2013-09-14 02:48:11
Message-ID: 47199759-75A6-4245-A825-48579BA82221@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sep 13, 2013, at 3:51 PM, Raymond O'Donnell wrote:
> [1] and one of the wiki
> articles [2] seem to indicate that you need to set up log-shipping as
> well as SR, whereas one of the wiki articles [2] indicates that
> log-shipping isn't required. I've followed [3] and it seems to work fine
> in initial trials; but I'm wondering if I'm missing something, or if I
> misunderstood [1] + [2] in the first place.
>

Streaming replication works fine without log shipping. The logs are a good idea
in case a pitr becomes required. I don't know why one would ever not write the
archives, but I have done so. I think it was some silly, temporary disk space issue
I had to work around.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jov 2013-09-14 03:31:05 Re: Hot standby & SR - log shipping required?
Previous Message Adrian Klaver 2013-09-14 02:07:45 Re: Postgres 9.2.4 "Double Precision" Precision