amit tripathi <amittripathi1445@xxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800
