> What do I need to do to get it back in "in production" mode?
I did as below. looks correct now. Is there any other method?
select pg_wal_replay_resume();
pg_wal_replay_resume
----------------------
(1 row)
On Thu, Sep 9, 2021 at 5:29 PM Gokan Atmaca <linux.gokan@gmail.com> wrote:
>
> > 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