Re: "Time of latest checkpoint" stays too old on both master andslave - Mailing list pgsql-general

From rihad
Subject Re: "Time of latest checkpoint" stays too old on both master andslave
Date
Msg-id a1536865-27d5-e8c5-38a7-0db01fa764c2@mail.ru
Whole thread Raw
In response to Re: "Time of latest checkpoint" stays too old on both master andslave  (rihad <rihad@mail.ru>)
Responses Re: "Time of latest checkpoint" stays too old on both master and slave
List pgsql-general
On 06/30/2019 10:59 AM, rihad wrote:
> Damn. Sorry, and please disregard my post. The master server had the 
> wrong time. Not wrong TZ, simply wrong time.
>
> $ date
> Sun Jun 30 08:34:52 +04 2019
>
> while it's currently 10:58

There's a weird problem, even when the time is initially set by openntpd 
it keeps lagging by one second every few seconds:


$ sudo /usr/local/etc/rc.d/openntpd restart
Performing sanity check on openntpd configuration:
configuration OK
Stopping openntpd.
Waiting for PIDS: 85893.
Performing sanity check on openntpd configuration:
configuration OK
Starting openntpd.
$ ssh good-server date; date
Sun Jun 30 11:04:17 +04 2019
Sun Jun 30 11:04:17 +04 2019
$ ssh good-server date; date
Sun Jun 30 11:04:25 +04 2019
Sun Jun 30 11:04:24 +04 2019
$ ssh good-server date; date
Sun Jun 30 11:04:32 +04 2019
Sun Jun 30 11:04:31 +04 2019
$ ssh good-server date; date
Sun Jun 30 11:04:39 +04 2019
Sun Jun 30 11:04:37 +04 2019
$ ssh good-server date; date
Sun Jun 30 11:04:48 +04 2019
Sun Jun 30 11:04:45 +04 2019


Really weird. But this isn't a PG problem at all, just a server glitch 
maybe. sorry again.




pgsql-general by date:

Previous
From: rihad
Date:
Subject: Re: "Time of latest checkpoint" stays too old on both master andslave
Next
From: Mohsen Bande
Date:
Subject: Re: Postgresql 12 Beta2 Crashes for any Insert/Update