Re: Postgresql Database cant start after restore using pgBackRest

I have tried removing the archive command but still does not work

On Sun, 25 Jun 2023 at 20:30, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> On 6/25/23 11:53, Deo Felix wrote:
>
> I am doing backup with pgbackrest in the database server every day at
> night, I was testing to restore the backup in another server, the restore
> was successfully however the database cant start
>
> *pgbackrest --stanza=data --delta --log-level-console=detail restore*
>
>
> Here's what worked for me:
> SetName=20221106-000003F
> pgbackrest restore \
> --stanza=$SomeStanza \
> --pg1-path=$NewPGData \
> --log-level-file=detail \
> --log-level-console=detail \
> --process-max=$ThreadCnt \
> --type=immediate --set=$SetName
>
> An alternative which should also work:
> RestoreTime="2022-11-06 02:00:00.0000"
> pgbackrest restore \
> --stanza=$SomeStanza \
> --pg1-path=$NewPGData \
> --log-level-file=detail \
> --log-level-console=detail \
> --process-max=$ThreadCnt \
> --type=time --target="$RestoreTime"
>
> [image: image.png]
>
>
> [image: image.png]
>
>
> In Thunderbird, at least, it's impossible to see those tiny images.
>
>
> --
> Born in Arizona, moved to Babylonia.
>