Re: Postgresql Database cant start after restore using pgBackRest

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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.