public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Koen De Groote <[email protected]>
Cc: PostgreSQL General <[email protected]>
Subject: Re: Postgres restore sometimes restores to a point 2 days in the past
Date: Fri, 31 Jan 2025 14:26:56 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAGbX52H5r2ObhTszzX5L+wKL9XYWvEeCT4xfvU+D6zgvOrPHTg@mail.gmail.com>
References: <CAGbX52HkW6926c4tY781+iH01x_0qw6Sfo=kT+LHjo_mENqOfQ@mail.gmail.com>
	<[email protected]>
	<CAGbX52E5_7fPZVW0YSjoTmj5qN-aORXpPqFF+bKCiicM+h3EZQ@mail.gmail.com>
	<[email protected]>
	<CAGbX52H5r2ObhTszzX5L+wKL9XYWvEeCT4xfvU+D6zgvOrPHTg@mail.gmail.com>

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
[email protected]

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Postgres restore sometimes restores to a point 2 days in the past
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox