Re: Postgresql Database cant start after restore using pgBackRest

[image: image.png]

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