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.
>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