Re: Simulate a PITR in postgresql 16

2025-07-02 Thread Franklin Anderson de Oliveira Souza
I don't know exactly what I did wrong but redoing what I described in the email worked perfectly! Thanks everyone! Enviado do Gmail para celular Em seg., 30 de jun. de 2025 às 15:35, Franklin Anderson de Oliveira Souza < frankli...@gmail.com> escreveu: > I'm trying to

Re: Simulate a PITR in postgresql 16

2025-06-30 Thread raphi
Am 30.06.2025 um 21:45 schrieb Ron Johnson: Using PgBackRest might be more convenient, since it handles everything you need, is multithreaded, never removes too many wal files, compresses files if you want and also encrypts them if you want. I agree, with pgBackRest it's basically: pgbackre

Re: Simulate a PITR in postgresql 16

2025-06-30 Thread Christoph Moench-Tegeder
## Franklin Anderson de Oliveira Souza (frankli...@gmail.com): > LOG: database system was shut down at 2025-06-30 12:15:28 -04 > cp: cannot stat '/dados/temp/wals/0002.history': No such file or directory > - > > > The restore_command requires the .history file but it does not

Re: Simulate a PITR in postgresql 16

2025-06-30 Thread Adrian Klaver
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

Re: Simulate a PITR in postgresql 16

2025-06-30 Thread Ron Johnson
x27;s just more convenient.) On Mon, Jun 30, 2025 at 3:35 PM Franklin Anderson de Oliveira Souza < frankli...@gmail.com> wrote: > I'm trying to simulate a PITR in postgresql 16 with the following steps: > > directorys: > /data/primary > /data/base > /data/wals > /data

Simulate a PITR in postgresql 16

2025-06-30 Thread Franklin Anderson de Oliveira Souza
I'm trying to simulate a PITR in postgresql 16 with the following steps: directorys: /data/primary /data/base /data/wals /data/csv 1- Create cluster to primary postgresql: /usr/pgsql-16/bin/initd -D /data/primary 2- Start Cluster ( port) /usr/pgsql-16/bin/pg_ctl -D /data/primary sta