Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres warm standby with delay - Mailing list pgsql-novice

From Amit S.
Subject Re: Postgres warm standby with delay
Date
Msg-id CAC-OOAtLfgE+DkCzd1PPnqSZTj0SBE2h5Zi-LaL2TeKfN_Ds+Q@mail.gmail.com
Whole thread Raw
In response to Re: Postgres warm standby with delay  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-novice
Tree view
Here are the first steps you can follow before you go to minute details::


On Fri, May 4, 2018 at 12:57 AM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:
On 3 May 2018 21:20:08 CEST, Ron Watkins <rwatki@gmail.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Calculating Median value
Next
From: Paul Linehan
Date:
Subject: Re: SUM and MAX over different periods - months over several years?