Where does PostgreSQL get the date/time from?

Поиск
Список
Период
Сортировка
От Colin Mangiagalli
Тема Where does PostgreSQL get the date/time from?
Дата
Msg-id 200302190941.h1J9f1728314@mail.wineofthemonth.co.za
обсуждение исходный текст
Список 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

В списке pgsql-cygwin по дате отправления:

Предыдущее
От: s0lao@netscape.net (S. L.)
Дата:
Сообщение: Re: PgAdmin problem
Следующее
От: "Yann.G"
Дата:
Сообщение: Re: What could be the cause?