| From: | Deo Felix <deofelix9(at)gmail(dot)com> |
|---|---|
| To: | David Steele <david(at)pgmasters(dot)net> |
| Cc: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgresql Database cant start after restore using pgBackRest |
| Date: | 2023-06-28 12:27:37 |
| Message-ID: | CALW=F4M8mtzq+=QvXJrPLmoCACiYGaiXbSBp25BD4d2AJ=0uiQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Thank you, this worked
On Tue, 27 Jun 2023 at 11:26, David Steele <david(at)pgmasters(dot)net> wrote:
> On 6/27/23 07:41, Deo Felix wrote:
> > In the postgresql.auto.conf i have this configs
> > restore_command = 'pgbackrest --pg1-path=/var/lib/postgres/main
> > --stanza=data archive-get %f "%p"'
> > recovery_target = 'immediate'
> > recovery_target_timeline = 'current'
> >
> > But still I the database cant start
>
> You will need to redo your pgbackrest restore with
> --target-timeline=current and then restart postgres to start recovery
> with the correct settings.
>
> Regards,
> -David
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikhil Ingale | 2023-06-29 07:12:27 | Deleting the pg logs older than 30 days or certain time |
| Previous Message | David Steele | 2023-06-27 14:46:08 | Re: Postgresql Database cant start after restore using pgBackRest |