Restore from a specific timeline

[mboncalo]

Hi Everyone,

I am trying to find out how to restore data from a specific timeline with Postgres Operator 2.4.1, Postgres 15
I tried to add “target_timeline” value in pgbackrest secret but was not successful

Thank you.

[Sergey_Pronin]

@mboncalo can you show me how you add it and what you see?

I would expect to see it in PerconaPGRestore manifest:

apiVersion: pgv2.percona.com/v2
kind: PerconaPGRestore
metadata:
  name: restore1
spec:
  pgCluster: cluster1
  repoName: repo1
  options:
  - --target-timeline=123
  - --target="2024-11-04 05:00:00+00"  

[mboncalo]

@Sergey_Pronin

--target="2024-11-04 05:00:00+00"

I added a line like target_timeline=4 for example, in the s3.conf secret created for pgbackrest. It’s not there now but I just wanted you to have an idea where it was. I will test your version as well and come back with feedback, it makes more sense

[mboncalo]

Thank you, tested this method and worked perfectly