Where does PostgreSQL get the date/time from?

From: "Colin Mangiagalli" <colin(at)camara(dot)co(dot)za>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Where does PostgreSQL get the date/time from?
Date: 2003-02-19 09:41:01
Message-ID: 200302190941.h1J9f1728314@mail.wineofthemonth.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Hi

Where does PostgreSQL get the date/time from, because it certainly
isn't from my system clock.

If I change the system time, it doesn't change in Postgresql.

It looks like postmaster gets the date and time when you start
up the server and then keeps its own time from then on.

All the computers on our network update their time from the domain
controller, but then the time giving by CURRENT_TIMESTAMP isn't
the same as the time on the computer running the database.

Is there a way to fix this?

Thanks
Colin

Browse pgsql-cygwin by date

  From Date Subject
Next Message Yann.G 2003-02-19 19:12:03 Re: What could be the cause?
Previous Message S. L. 2003-02-19 06:33:41 Re: PgAdmin problem