Re: [HACKERS] Is Postgres database server works fine if there is a change in system time?

2015-06-21 Thread Craig Ringer
On 17 June 2015 at 15:36, Prakash Itnal prakash...@gmail.com wrote: Hi, Currently we observed that certain postgres child process, for eg. autovacuum worker, are not working as expected if there is a system time change. So I wanted to know if postgres already supports system time changes or

Re: [HACKERS] Is Postgres database server works fine if there is a change in system time?

2015-06-21 Thread Prakash Itnal
Hi, The more detailed discussion is on other mail chain with subject line: Auto-vacuum is not running in 9.1.12 I agree there is no issue if time shifts by small amount. This issue is serious only if there is big time shifts. In our product the database is deployed on remote network elements and

Re: [HACKERS] Is Postgres database server works fine if there is a change in system time?

2015-06-20 Thread Robert Haas
On Wed, Jun 17, 2015 at 3:36 AM, Prakash Itnal prakash...@gmail.com wrote: Currently we observed that certain postgres child process, for eg. autovacuum worker, are not working as expected if there is a system time change. So I wanted to know if postgres already supports system time changes or

[HACKERS] Is Postgres database server works fine if there is a change in system time?

2015-06-17 Thread Prakash Itnal
Hi, Currently we observed that certain postgres child process, for eg. autovacuum worker, are not working as expected if there is a system time change. So I wanted to know if postgres already supports system time changes or not. Please confirm if postgres already handles system time changes or