Re: Simulate a PITR in postgresql 16

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Franklin Anderson de Oliveira Souza <franklinbr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Simulate a PITR in postgresql 16
Date: 2025-06-30 20:43:12
Message-ID: 5cf33398-a39d-459e-900b-7ee5609f55b7@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/30/25 12:35, Franklin Anderson de Oliveira Souza wrote:
> I'm trying to simulate a PITR in postgresql 16 with the following steps:
>

> -----------------
> LOG: starting PostgreSQL 16.3 on x86_64-pc-linux-gnu, compiled by gcc
> (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit
> LOG: listening on IPv6 address "::1", port 2222
> LOG: listening on IPv4 address "127.0.0.1", port 2222
> LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.2222"
> LOG: listening on Unix socket "/tmp/.s.PGSQL.2222"
> LOG: database system was shut down at 2025-06-30 12:15:28 -04
> cp: cannot stat '/dados/temp/wals/00000002.history': No such file or directory
> -----------------

Where is /dados/temp/wals/ coming from?

>
>
> The restore_command requires the .history file but it does not exist
> in any of the clusters in this simple test, which is wrong in this
> example ? Tanks
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2025-06-30 21:03:31 Re: Simulate a PITR in postgresql 16
Previous Message Ron Johnson 2025-06-30 19:45:24 Re: Simulate a PITR in postgresql 16