Re: Postgres restore sometimes restores to a point 2 days in the past

On 1/31/25 13:52, Koen De Groote wrote:
>  > I should have asked earlier what is the archive command
> 
> The example from the documentation, but with GZIP. So from the 
> documentation: 
> https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-ARCHIVING-WAL
<https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-ARCHIVING-WAL>
> 
> Which becomes this: archive_command = 'test ! -f 
> /mnt/server/archivedir/%f.gz && gzip -c %p /mnt/server/archivedir/%f.gz'
> 
> 
>  > Are you setting standby.signal or recovery.signal or both
> 
> Sorry, I keep confusing them. I checked my deployment code, it's 
> recovery.signal and only that.

Do you have any of the Recovery Target settings from below set?:

https://www.postgresql.org/docs/current/runtime-config-wal.html#RUNTIME-CONFIG-WAL-RECOVERY-TARGET


> 
> Regards,
> Koen De Groote
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com