Re: setting local time without restarting server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Anony Mous <A(dot)Mous(at)shaw(dot)ca>
Cc: "'Bruno Wolff III'" <bruno(at)wolff(dot)to>, pgsql-general(at)postgresql(dot)org
Subject: Re: setting local time without restarting server
Date: 2004-05-14 00:34:11
Message-ID: 14684.1084494851@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Anony Mous <A(dot)Mous(at)shaw(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-05-14 04:00:34 Re: pg_xlog becomes extremely large during CREATE INDEX
Previous Message Tom Lane 2004-05-14 00:31:38 Re: After update complete set