Request a Demo
Home   >   mailing lists

Re: pg_rewind problem: cannot find WAL - Mailing list pgsql-general

From Luca Ferrari
Subject Re: pg_rewind problem: cannot find WAL
Date
Msg-id CAKoxK+5XT5bAV+w-4dC=rP+a7t2zkvRf8+-wj087yd1Fd5b2iQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_rewind problem: cannot find WAL  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: pg_rewind problem: cannot find WAL
List pgsql-general
Tree view 
On Wed, May 7, 2025 at 3:55 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> I don't think it is connected to a WAL switch.
>

Thanks.

> I'd say that you should set "wal_keep_size" high enough that all the WAL
> needed for pg_rewind is still present.
>
> If you have a WAL archive, you could define a restore_command on the server
> you want to rewind.

I've pgbackrest making backups, so I have an archive_command. I'm
going to see if putting a restore_command can fix the problem.

Thanks for the suggestion.

Luca

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: huge_pages=on cause could not map anonymous shared memory: Cannot allocate memory
Next
From: Karsten P
Date:
Subject: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union