Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres restore sometimes restores to a point 2 days in the past - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Postgres restore sometimes restores to a point 2 days in the past
Date
Msg-id a49edff0-f8d8-44c1-9921-ef815f8a1d2a@aklaver.com
Whole thread Raw
In response to Postgres restore sometimes restores to a point 2 days in the past  (Koen De Groote <kdg.dev@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Koen De Groote
Date:
Subject: Re: Postgres restore sometimes restores to a point 2 days in the past
Next
From: Gabriele Tozzi
Date:
Subject: Toughs for CREATE DATABASE performance improvement