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 simulate a PITR in postgr

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 IPv6

Re: Simulate a PITR in postgresql 16

2025-06-30 Thread 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. (In 2025, I also leave pg_wal on the same mount point as data/. Disk space is plentiful and it's ju