Re: Is there a way to change current time?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: "Warstone(at)list(dot)ru" <warstone(at)list(dot)ru>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Is there a way to change current time?
Date: 2021-04-15 14:13:33
Message-ID: 3778411.1618496013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> On Thu, Apr 15, 2021 at 04:45:44PM +0300, Warstone(at)list(dot)ru wrote:
>> Is there any way to set time that CURRENT_TIMESTAMP and/or now() will give next
>> time? (We need it only for testing purposes so if there is any hack, cheat,
>> etc. It will be fine)

> No, it gets the time from the operating system.

I think there are OS-level solutions for this on some operating systems.
If nothing else, you could manually set the system clock; but what you'd
really want is for the phony time to be visible to just some processes.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2021-04-15 14:14:27 Re: Is there a way to change current time?
Previous Message Justin Pryzby 2021-04-15 14:01:56 Re: Is there a way to change current time?