Skip site navigation (1) Skip section navigation (2)

Re: Setting date and time

From: George Weaver <gweaver(at)shaw(dot)ca>
To: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Setting date and time
Date: 2004-01-29 13:28:47
Message-ID: 002a01c3e66b$d39321b0$6400a8c0@Dell4500 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi Manuel,

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>
Cc: <pgsql-novice(at)postgresql(dot)org>
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 SugawaraDate: 2004-01-29 16:31:35
Subject: Re: Setting date and time
Previous:From: Bruno Wolff IIIDate: 2004-01-29 13:14:17
Subject: Re: COPY command cannot access file...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group