Re: Postgresql Database cant start after restore using pgBackRest

[Deo Felix <deofelix9@xxxxxxxxx>]

<2023-06-25 21:14:17.647 EAT::@:[1038849]:>LOG:  restored log file "0000000100001834000000F4" from archive
<2023-06-25 21:14:18.311 EAT::@:[1038841]:>LOG:  received smart shutdown request
<2023-06-25 21:14:18.386 EAT::@:[1038841]:>LOG:  received SIGHUP, reloading configuration files
<2023-06-25 21:14:18.507 EAT::@:[1038841]:>LOG:  startup process (PID 1038849) was terminated by signal 9: Killed
<2023-06-25 21:14:18.507 EAT::@:[1038841]:>LOG:  terminating any other active server processes
<2023-06-25 21:14:18.507 EAT::@:[1038841]:>LOG:  abnormal database system shutdown
<2023-06-25 21:14:19.438 EAT::@:[1038841]:>LOG:  database system is shut down

On Sun, 25 Jun 2023 at 20:30, Ron <ronljohnsonjr@xxxxxxxxx> 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"

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

--
Born in Arizona, moved to Babylonia.