From: Jerry Sievers <gsievers19@comcast.net>
To: amit tripathi <amittripathi1445@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: recovery.conf not getting changed to recovery.done after PITR
Date: Thu, 06 Sep 2018 10:32:58 -0500
Message-ID: <871sa6y72t.fsf@jsievers.enova.com> (raw)
In-Reply-To: <CABpqzU+LFHBj0_3xkVpKrHb8HShOQO3jNfD0h8f6T3=+xtfBCA@mail.gmail.com>
References: <CABpqzU+LFHBj0_3xkVpKrHb8HShOQO3jNfD0h8f6T3=+xtfBCA@mail.gmail.com>
amit tripathi <amittripathi1445@gmail.com> writes:
> Hi All,
>
> Need help on below issue.
>
>>In recovery.conf file if we give recovery_target_time as 2018-09-05
> 09:54:21 (without EST) and restart the postgresql, recovery.conf is
> not getting changed to recovery.done. Although PITR is successful and
> only till given time records/tables are restored. But database goes
> in recovery mode and i am unable to enter more records.
Show us your recovery.conf after masking anything sensitive.
You probably are paused at a recovery target and if trying to promote
the pitr cluster at this point, need to un-pause replication else it
will not respond to the promote.
HTH
>
>>In the second case if i add EST and restart the postgresql,
> recovery.conf is getting changed to recovery.done but everything is
> getting restored. I mean tables/records added after 2018-09-05
> 09:54:21 are also restored.
>
> Other information-Doing it on Linux host. Timezone in postgresql.conf
> is US/Eastern.
>
>
> Regards,
> Amit
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
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: gsievers19@comcast.net, amittripathi1445@gmail.com
Subject: Re: recovery.conf not getting changed to recovery.done after PITR
In-Reply-To: <871sa6y72t.fsf@jsievers.enova.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