recovery.conf not getting changed to recovery.done after PITR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux