Re: pg_rewind restore_command issue in PG12 - Mailing list pgsql-hackers

From Amine Tengilimoglu
Subject Re: pg_rewind restore_command issue in PG12
Date
Msg-id CADTdw-y7Bmn3eU-OH3h2Uv-_k2=8RMLnhwxts6nj9PE+qTGGSg@mail.gmail.com
Whole thread Raw
In response to Re: pg_rewind restore_command issue in PG12  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: pg_rewind restore_command issue in PG12  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
   When I read the pg_rewind PG12 doc.  It says:

"... but if the target cluster ran for a long time after the divergence, the old WAL files might no longer be present. In that case, they can be manually copied from the WAL archive to the pg_wal directory, or fetched on startup by configuring primary_conninfo or restore_command.".

  So I thought we could use restore_command. But when I try to use it , I see it doesn't work either.

Thanks.



Heikki Linnakangas <hlinnaka@iki.fi>, 4 Oca 2021 Pzt, 15:42 tarihinde şunu yazdı:
On 03/01/2021 20:13, Amine Tengilimoglu wrote:
>       In a situation where pg_rewind gets an error due to a missing
> wall, I  have set restore_command so that the needed wals can be read
> from the archive (I don't want to manually copy the wal files), but I
> see it doesn't work. What am I missing?  Is restore_command not really
> working with pg_rewind in PG12? Or  how should I trigger pg_rewind to
> use restore_command?

Using restore_command is a new feature in pg_rewind in PostgreSQL 13. It
doesn't work on earlier versions.

- Heikki

pgsql-hackers by date:

Previous
From: "赵锐"
Date:
Subject: [Bug Fix] Logical replication on partition table is very slow and CPU is 99%
Next
From: "Joel Jacobson"
Date:
Subject: Re: Test harness for regex code (to allow importing Tcl's test suite)