Re: setting local time without restarting server - Mailing list pgsql-general

From Tom Lane
Subject Re: setting local time without restarting server
Date
Msg-id 14684.1084494851@sss.pgh.pa.us
Whole thread Raw
In response to Re: setting local time without restarting server  (Anony Mous <A.Mous@shaw.ca>)
List pgsql-general
Anony Mous <A.Mous@shaw.ca> writes:
> Thanks, but I do want to set the system time.

You cannot do that from within Postgres, because it requires root
privileges.

> I'd like to do it without having to first change
> the system time, and then re-start the postmaster.

Who said anything about restarting the postmaster?  Just set the system
time (eg, with date(1)).

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: After update complete set
Next
From: Tom Lane
Date:
Subject: Re: pg_xlog becomes extremely large during CREATE INDEX