From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql Database cant start after restore using pgBackRest
Date: Sun, 25 Jun 2023 12:30:05 -0500
Message-ID: <08b27fdc-8caa-4498-039d-d07565b3aed9@gmail.com> (raw)
In-Reply-To: <CALW=F4MZsscvQ-x+fGmxSY2q4xaGk1stKPsKuts-om-ewdeR5A@mail.gmail.com>
References: <CALW=F4MZsscvQ-x+fGmxSY2q4xaGk1stKPsKuts-om-ewdeR5A@mail.gmail.com>
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.png
>
> *
> *
>
> image.png
In Thunderbird, at least, it's impossible to see those tiny images.
--
Born in Arizona, moved to Babylonia.
Attachments:
[image/png] image.png (19.4K, ../08b27fdc-8caa-4498-039d-d07565b3aed9@gmail.com/3-image.png)
download | view image
[image/png] image.png (55.7K, ../08b27fdc-8caa-4498-039d-d07565b3aed9@gmail.com/4-image.png)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql Database cant start after restore using pgBackRest
In-Reply-To: <08b27fdc-8caa-4498-039d-d07565b3aed9@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox