Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux