Re: Postgres warm standby with delay

From: "Amit S(dot)" <comeonamit(at)gmail(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org, Ron Watkins <rwatki(at)gmail(dot)com>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgres warm standby with delay
Date: 2018-05-06 23:04:25
Message-ID: CAC-OOAtLfgE+DkCzd1PPnqSZTj0SBE2h5Zi-LaL2TeKfN_Ds+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Here are the first steps you can follow before you go to minute details::

https://wiki.postgresql.org/wiki/Warm_Standby

On Fri, May 4, 2018 at 12:57 AM, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de
> wrote:

> On 3 May 2018 21:20:08 CEST, Ron Watkins <rwatki(at)gmail(dot)com> wrote:
> >Management wants to have our postgres database server backed-up to a
> >warm-standby server with an 8-hour delay.
> >
>
> You are looking for:
>
> recovery_min_apply_delay
>
>
> Regards, Andreas
>
>
> --
> 2ndQuadrant - The PostgreSQL Support Company
>
>

--

Amit Sharma

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Paul Linehan 2018-05-07 15:58:01 Re: SUM and MAX over different periods - months over several years?
Previous Message Tom Lane 2018-05-06 18:13:47 Re: Calculating Median value