From: | Gokan Atmaca <linux(dot)gokan(at)gmail(dot)com> |
---|---|
To: | Frédéric Boulet <boulet(dot)f(at)gmail(dot)com> |
Cc: | Victor Yegorov <vyegorov(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: PgBackRest PITR restore |
Date: | 2021-09-09 14:29:04 |
Message-ID: | CAHg8tEAqcR3+toNXXAM=WRFPtR9OkktUZRMEDhDxVUEwCpEutg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> 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(dot)f(at)gmail(dot)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(dot)gokan(at)gmail(dot)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(dot)f(at)gmail(dot)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(at)gmail(dot)com> a écrit :
>> >>
>> >> вт, 7 сент. 2021 г. в 13:32, Gokan Atmaca <linux(dot)gokan(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Gokan Atmaca | 2021-09-09 14:36:36 | Re: PgBackRest PITR restore |
Previous Message | Michael Paquier | 2021-09-09 04:23:10 | Re: Estimating HugePages Requirements? |