Re: Allow users to choose what happens when recovery target is not reached

2022-01-29 Thread Bharath Rupireddy
On Sat, Nov 13, 2021 at 6:45 PM Bharath Rupireddy wrote: > > Firstly, the proposed patch adds no new behaviour as such, it just > gives the ability that is existing today on v12 and below (prior to > commit dc78866 which went into v13 and later). > > I think performing PITR is the user's wish - wh

Re: Allow users to choose what happens when recovery target is not reached

2021-11-13 Thread Euler Taveira
On Sat, Nov 13, 2021, at 10:15 AM, Bharath Rupireddy wrote: > Firstly, the proposed patch adds no new behaviour as such, it just > gives the ability that is existing today on v12 and below (prior to > commit dc78866 which went into v13 and later). It reintroduces an awkward behavior [1]. > I think

Re: Allow users to choose what happens when recovery target is not reached

2021-11-13 Thread Bharath Rupireddy
On Sat, Nov 13, 2021 at 9:45 AM Julien Rouhaud wrote: > > On Sat, Nov 13, 2021 at 11:00 AM Bharath Rupireddy > wrote: > > > > Users will always be optimistic and set a recovery target and try to > > reach it, but somehow the few of the WAL files haven't arrived (for > > whatever the reasons) the

Re: Allow users to choose what happens when recovery target is not reached

2021-11-12 Thread Julien Rouhaud
On Sat, Nov 13, 2021 at 11:00 AM Bharath Rupireddy wrote: > > Users will always be optimistic and set a recovery target and try to > reach it, but somehow the few of the WAL files haven't arrived (for > whatever the reasons) the PITR target server, imagine if their primary > isn't available too, t

Re: Allow users to choose what happens when recovery target is not reached

2021-11-12 Thread Bharath Rupireddy
On Fri, Nov 12, 2021 at 4:09 PM Julien Rouhaud wrote: > > On Fri, Nov 12, 2021 at 6:14 PM Bharath Rupireddy > wrote: > > > > Currently, the server shuts down with a FATAL error (added by commit > > [1]) when the recovery target isn't reached. This can cause a server > > availability problem, espe

Re: Allow users to choose what happens when recovery target is not reached

2021-11-12 Thread Julien Rouhaud
On Fri, Nov 12, 2021 at 6:14 PM Bharath Rupireddy wrote: > > Currently, the server shuts down with a FATAL error (added by commit > [1]) when the recovery target isn't reached. This can cause a server > availability problem, especially in case of disaster recovery (geo > restores) where the primar

Allow users to choose what happens when recovery target is not reached

2021-11-12 Thread Bharath Rupireddy
Hi, Currently, the server shuts down with a FATAL error (added by commit [1]) when the recovery target isn't reached. This can cause a server availability problem, especially in case of disaster recovery (geo restores) where the primary was down and the user is doing a PITR on a server lying in an