Feedback-ID: i76984098:Fastmail
Message-ID: <a49edff0-f8d8-44c1-9921-ef815f8a1d2a@aklaver.com>
Date: Fri, 31 Jan 2025 14:26:56 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Postgres restore sometimes restores to a point 2 days in the past
To: Koen De Groote <kdg.dev@gmail.com>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
References: <CAGbX52HkW6926c4tY781+iH01x_0qw6Sfo=kT+LHjo_mENqOfQ@mail.gmail.com>
 <70c20a65-4624-4509-ac6a-ef7f0119ea28@aklaver.com>
 <CAGbX52E5_7fPZVW0YSjoTmj5qN-aORXpPqFF+bKCiicM+h3EZQ@mail.gmail.com>
 <a12f131a-1597-496e-b9d8-e00c13d723bb@aklaver.com>
 <CAGbX52H5r2ObhTszzX5L+wKL9XYWvEeCT4xfvU+D6zgvOrPHTg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAGbX52H5r2ObhTszzX5L+wKL9XYWvEeCT4xfvU+D6zgvOrPHTg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/a49edff0-f8d8-44c1-9921-ef815f8a1d2a%40aklaver.com>
Precedence: bulk

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