Thanks for the response.
From what I can determine, postmaster gets the OS date and time when its
starts up, but then seems to maintain the data and time independently. If
you change the OS date or time after postmaster is running, the two systems
will be out of synch. I'm hoping to determine if there is a way to "reset"
the postmaster date and time to match that of the OS if they are out of
synch, without restarting postmaster.
----- Original Message -----
From: "Manuel Sugawara" <masm(at)fciencias(dot)unam(dot)mx>
To: "George Weaver" <gweaver(at)shaw(dot)ca>
Sent: Wednesday, January 28, 2004 10:50 PM
Subject: Re: [NOVICE] Setting date and time
George Weaver <gweaver(at)shaw(dot)ca> writes:
> Hi Everyone,
> Is it possible to reset the data and time in postmaster without
> restarting it?
PostgreSQL uses the OS clock for date/time issues. If you can change
the date on your system, PostgreSQL won't complain, AFAIK.
In response to
pgsql-novice by date
|Next:||From: Manuel Sugawara||Date: 2004-01-29 16:31:35|
|Subject: Re: Setting date and time|
|Previous:||From: Bruno Wolff III||Date: 2004-01-29 13:14:17|
|Subject: Re: COPY command cannot access file...|