-
-
Notifications
You must be signed in to change notification settings - Fork 389
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unable to start patroni after pgbackrest restore #656
Comments
@kumarashish071092 Please attach the ansible and patroni logs. |
The issue was resolved after inserting restore_command and bootstrap method as pgbackrest in /etc/patroni/patroni.yml file :
bootstrap
method: pgbackrest
pgbackrest:
command: /var/lib/postgresql/bootstrap_pgbackrest.sh
keep_existing_recovery_conf: False
no_paramas: False
recovery_conf:
recovery_target_action: promote
recovery_target_timeline: latest
recovery_command: pgbackrest --stanza=trino-prod archive-get %f %p
vi bootstrap_pgbackrest.sh
pgbackrest --type=immediate --repo1-host=10.0.XX.XX --repo1-host-user=postgres --target-action=promote --stanza=trino-prod --set=20240507-063127F --log-level-console=detail --archive-mode=off restore
restarted patroni and the issue got resolved
…________________________________
From: Vitaliy Kukharik ***@***.***>
Sent: Thursday, May 9, 2024 12:51 AM
To: vitabaks/postgresql_cluster ***@***.***>
Cc: Kumar Ashish ***@***.***>; Mention ***@***.***>
Subject: Re: [vitabaks/postgresql_cluster] Unable to start patroni after pgbackrest restore (Issue #656)
[Email from a non-Nagarro source: please exercise caution with links and attachments]
@kumarashish071092<https://github.com/kumarashish071092> Please attach the ansible and patroni logs.
—
Reply to this email directly, view it on GitHub<#656 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AVXUU3QJXMQJQGNO63UH4MLZBJ3KDAVCNFSM6AAAAABHM2HFDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBRGI3DSMRSGI>.
You are receiving this because you were mentioned.
|
Ok, good! I will prepare a website with detailed documentation soon. |
You may have an old version of automation because for pgbackrest we have not used the bootstrap method to provide delta restore functionality for a long time. See details here https://github.com/vitabaks/postgresql_cluster#restore-and-cloning |
Yes it was not there . In the original automation file , it is initdb. I have modified it to make it sync with Patroni .
Is there any other way to restore pgbackrest with patroni
Get Outlook for iOS<https://aka.ms/o0ukef>
…________________________________
From: Vitaliy Kukharik ***@***.***>
Sent: Thursday, May 9, 2024 7:35:02 PM
To: vitabaks/postgresql_cluster ***@***.***>
Cc: Kumar Ashish ***@***.***>; Mention ***@***.***>
Subject: Re: [vitabaks/postgresql_cluster] Unable to start patroni after pgbackrest restore (Issue #656)
[Email from a non-Nagarro source: please exercise caution with links and attachments]
You may have an old version of automation because for pgbackrest we have not used the bootstrap method to provide delta restore functionality for a long time.
See details here https://github.com/vitabaks/postgresql_cluster#restore-and-cloning
—
Reply to this email directly, view it on GitHub<#656 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AVXUU3XDGUCHVDNK54ZRU53ZBN7A5AVCNFSM6AAAAABHM2HFDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBSG4ZDQNBZGQ>.
You are receiving this because you were mentioned.Message ID: ***@***.***>
|
And why are you not satisfied with the current method? It is fully automated. Point-In-Time-Recoveryhttps://github.com/vitabaks/postgresql_cluster#restore-and-cloning You can run automatic restore of your existing patroni cluster
What does automation do? (recovery steps with pgBackRest):
|
@SDV109 Please confirm that you are already using the automated Point-In-Time-Recovery method. Do you have any difficulties with this? |
@vitabaks, Yes, I confirm that with the latest repository releases, there are no problems with the recovery method at a certain point in time. @kumarashish071092, Hi, look at my comment on the PITR problem earlier, maybe it will help you: #588 (comment) |
Is the problem still relevant? |
I have restored my entire cluster from a other pgbackrest host and after making the necessary changes , I was able to start the database using the below command :
/usr/lib/postgresql/14/bin/pg_ctl -D /mnt/Postgres/postgresql/14/trin-prod/data start
But this is not getting run by patroni service and the playbook execution is not getting completed .
how can I link the patroni and new postgres cluster and does it have to do anything with etcd as well?
The text was updated successfully, but these errors were encountered: