<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
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
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.