Re: [HACKERS] Is Postgres database server works fine if there is a change in system time?
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 not. In general, small time slews will have no effect on operations. If they do then that's likely a PostgreSQL bug. A large time discontinuity, where time jumps backwards or forwards by a large amount, could well cause issues. I would personally be inclined to restart the database server in these cases, or kill the autovaccum scheduler to force it to restart. In what way are the autovacuum workers not working as expected after a system time change? What was the system time change made? How was the change made? On what operating system and version? BTW, this seems to be posted on Stack Overflow too: http://stackoverflow.com/questions/30839163/system-time-change-impact-to-postgresql-database-processes -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Is Postgres database server works fine if there is a change in system time?
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 there will be thousands of such network elements. All these network elements are synced with one or more centralized NTP servers. If due to some issue by mistake if NTP shifts back in time and corrects itself then most of our network elements goes for toss. Since we use limited disc space and our db model is write-heavy (update SQLs), the disc starts getting full and soon all services get interrupted. Restarting service is costly from customer point-of-view. So our suggestion is to prevent a restart in such situations. With my little understanding and analysis I have shared the patch in other mail chain. Please check and share your inputs. For quick reference please find the scenarios below: On Mon, Jun 22, 2015 at 8:02 AM, Craig Ringer cr...@2ndquadrant.com wrote: 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 not. In general, small time slews will have no effect on operations. If they do then that's likely a PostgreSQL bug. A large time discontinuity, where time jumps backwards or forwards by a large amount, could well cause issues. I would personally be inclined to restart the database server in these cases, or kill the autovaccum scheduler to force it to restart. In what way are the autovacuum workers not working as expected after a system time change? What was the system time change made? How was the change made? On what operating system and version? BTW, this seems to be posted on Stack Overflow too: http://stackoverflow.com/questions/30839163/system-time-change-impact-to-postgresql-database-processes -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Cheers, Prakash
Re: [HACKERS] Is Postgres database server works fine if there is a change in system time?
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 not. Please confirm if postgres already handles system time changes or not. I think it's our intention to be reasonably resilient against such changes. Perfect resilient is likely impossible, but I think it's our general goal not to throw up and die. If you find cases where we do, please report them. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Is Postgres database server works fine if there is a change in system time?
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 not. -- Cheers, Prakash
