From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Gokan Atmaca <linux.gokan@gmail.com>
Cc: Frédéric Boulet <boulet.f@gmail.com>
Cc: Victor Yegorov <vyegorov@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PgBackRest PITR restore
Date: Thu, 9 Sep 2021 10:38:41 -0400
Message-ID: <5a08389c-839d-603f-9dfe-fb583618594a@sqlexec.com> (raw)
In-Reply-To: <CAHg8tEAqcR3+toNXXAM=WRFPtR9OkktUZRMEDhDxVUEwCpEutg@mail.gmail.com>
References: <CAHg8tEB00Kk81SGHqDa8JvXW_6ZdH4qTmQkcAALchj=EtHswMA@mail.gmail.com>
<CAGnEboifMGBtH=_5MdkuZHzgo5z68V6O3e+g4rGHbzUb7TQkNA@mail.gmail.com>
<CAHuOqjNDo1XWs_OM+c=FjNRkKO303HwJFwGzQGS1W+qBu_uL0w@mail.gmail.com>
<CAHg8tEC5LF9JdQEzMBP1=UjF+LNmHMXLB97GUT0O23vbka44MA@mail.gmail.com>
<CAHuOqjMrWBgrd47k_g2cEbtYTQ-hvJe3BJ83=bC-7HzbX=O-VA@mail.gmail.com>
<CAHg8tEAqcR3+toNXXAM=WRFPtR9OkktUZRMEDhDxVUEwCpEutg@mail.gmail.com>
* “standby.signal” – indicates the server should start up as a hot standby
* “recovery.signal” – indicates the server should start up in targeted
recovery mode
Assuming we are at V12 or higher, simply remove standby.signal if exists
in datadir and add the empty file recovery.signal in datadir.
Regards,
Michael Vitale
Gokan Atmaca wrote on 9/9/2021 10:29 AM:
>> You need to restore the databases in a different directory, the "recover" the one you want.
> When I do a PITR, the database is in recovery mode. (in archive recovery)
> What do I need to do to get it back in "in production" mode?
>
>
>
>
>
> On Tue, Sep 7, 2021 at 4:19 PM Frédéric Boulet <boulet.f@gmail.com> wrote:
>> You need to restore the databases in a different directory, the "recover" the one you want.
>>
>> Le mar. 7 sept. 2021 à 15:01, Gokan Atmaca <linux.gokan@gmail.com> a écrit :
>>>> You can restore 1 database, but be careful, the other databases are also created but empty !
>>> you're right, now I get it. :)
>>>
>>> On Tue, Sep 7, 2021 at 2:55 PM Frédéric Boulet <boulet.f@gmail.com> wrote:
>>>> Hello,
>>>>
>>>> You can restore 1 database, but be careful, the other databases are also created but empty !
>>>>
>>>> BR
>>>>
>>>> Le mar. 7 sept. 2021 à 13:52, Victor Yegorov <vyegorov@gmail.com> a écrit :
>>>>> вт, 7 сент. 2021 г. в 13:32, Gokan Atmaca <linux.gokan@gmail.com>:
>>>>>> Using PgBackRest I am able to restore the backup from 2 minutes ago.
>>>>>> Can I restore only one database?
>>>>>
>>>>> Yup.
>>>>>
>>>>> https://pgbackrest.org/command.html#command-restore
>>>>>
>>>>> Look for --db-include
>>>>>
>>>>>
>>>>> --
>>>>> Victor Yegorov
>
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: MichaelDBA@sqlexec.com, linux.gokan@gmail.com, boulet.f@gmail.com, vyegorov@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: PgBackRest PITR restore
In-Reply-To: <5a08389c-839d-603f-9dfe-fb583618594a@sqlexec.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