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"

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