Re: Changing the time on the server - Mailing list pgsql-admin

From Tom Lane
Subject Re: Changing the time on the server
Date
Msg-id 14975.1045841743@sss.pgh.pa.us
Whole thread Raw
In response to Changing the time on the server  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
"Donald Fraser" <demolish@cwgsy.net> writes:
> Could somebody tell me the consequences of setting the date forward in time=
>  on the server running PostgreSQL and then at a later date, after some tran=
> sactions have been committed, setting the date back in time?

AFAIR, Postgres itself couldn't care less.  If your application stores
timestamps into the database, it might get a little confused about which
actions were done in what order ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Nikolaus Dilger"
Date:
Subject: Re: Changing the time on the server
Next
From: "Pascal PEYRE"
Date:
Subject: Vacuum Question