Re: Slot issues - Mailing list pgsql-general

From Andres Freund
Subject Re: Slot issues
Date
Msg-id 20181014215556.dpdadv5zn7cdkvpx@alap3.anarazel.de
Whole thread Raw
In response to Re: Slot issues  (Ravi Krishna <srkrishna1@aol.com>)
Responses Re: Slot issues  (Ravi Krishna <srkrishna1@aol.com>)
List pgsql-general
Hi,

On 2018-10-14 17:52:30 -0400, Ravi Krishna wrote:
> The best part in Db2 HADR is that when the standby is catching up with the master after a long time, it will
> start from the last LSN and fetch it from the primary WAL directory (active logs ). If not found, it will look for
it
> in the archived logs and start applying from there until the current
> point.

Uh, it works precisely the same in postgres.


> No rep slot business.

You're not forced to use slots.  Their purpose is to allow to force the
primary to keep necessary resources around. Which also allows to get rid
of the archive in some setups.

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Slot issues
Next
From: Ravi Krishna
Date:
Subject: Re: Slot issues