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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Prakash Itnal <prakash074(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is Postgres database server works fine if there is a change in system time?
Date: 2015-06-20 21:56:13
Message-ID: CA+TgmoZo9Bis50hkiv8ZGtOS6spyWL9DWSp8zSsq719GRnNKdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 17, 2015 at 3:36 AM, Prakash Itnal <prakash074(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-06-20 22:06:55 Re: The real reason why TAP testing isn't ready for prime time
Previous Message Robert Haas 2015-06-20 21:52:03 Re: pg_stat_*_columns?