Re: Postgresql Database cant start after restore using pgBackRest

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.png
>
> *
> *
>
> image.png

In Thunderbird, at least, it's impossible to see those tiny images.

--
Born in Arizona, moved to Babylonia.