Re: recovery_target immediate timestamp

2020-11-13 Thread Fujii Masao
On 2020/11/13 8:39, Euler Taveira wrote: On Wed, 11 Nov 2020 at 22:40, Fujii Masao mailto:masao.fu...@oss.nttdata.com>> wrote: On 2020/11/12 6:00, Euler Taveira wrote: > The first patch adds a new message that prints the latest completed checkpoint > when the consistent state

Re: recovery_target immediate timestamp

2020-11-12 Thread Euler Taveira
On Wed, 11 Nov 2020 at 22:40, Fujii Masao wrote: > > On 2020/11/12 6:00, Euler Taveira wrote: > > > The first patch adds a new message that prints the latest completed > checkpoint > > when the consistent state is reached. > > I'm not sure how useful this information is in practice. > > Fujii, th

Re: recovery_target immediate timestamp

2020-11-11 Thread Fujii Masao
On 2020/11/12 6:00, Euler Taveira wrote: Hi, While restoring a backup using recovery_target immediate, I noticed that there isn't a timestamp available. LOG:  consistent recovery state reached at 0/A000100 LOG:  recovery stopping after reaching consistency LOG:  pausing at the end of recover

recovery_target immediate timestamp

2020-11-11 Thread Euler Taveira
Hi, While restoring a backup using recovery_target immediate, I noticed that there isn't a timestamp available. LOG: consistent recovery state reached at 0/A000100 LOG: recovery stopping after reaching consistency LOG: pausing at the end of recovery HINT: Execute pg_wal_replay_resume() to pro