[PDB Tech] Clock skew?

[Sander Steffann]

Hi!

There seems to be a problem with the clock on the server. I am seeing updated timestamps in the future after a sync:

peeringmanager=# select id,name,status,created,updated from peeringdb_organization where updated>CURRENT_TIMESTAMP order by updated desc;
  id   |                 name                 | status |        created         |        updated
-------+--------------------------------------+--------+------------------------+------------------------
 25094 | MYDCHUB                              | ok     | 2020-02-05 04:33:05+01 | 2020-02-05 04:33:05+01
 25093 | Westpac Bank                         | ok     | 2020-02-05 03:34:14+01 | 2020-02-05 03:34:14+01
 25092 | N DOS SANTOS & SANTOS LTDA - ME - ME | ok     | 2020-02-05 02:38:08+01 | 2020-02-05 02:40:34+01
 25091 | hybris GmbH                          | ok     | 2020-02-04 23:36:50+01 | 2020-02-05 01:36:19+01
 16124 | Data Space Sp. z o.o.                | ok     | 2017-01-29 16:58:31+01 | 2020-02-05 01:28:41+01
(5 rows)

peeringmanager=# select CURRENT_TIMESTAMP;
       current_timestamp
-------------------------------
 2020-02-04 23:35:06.646783+01
(1 row)

Cheers,
Sander

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <http://lists.peeringdb.com/pipermail/pdb-tech/attachments/20200204/bfb51036/attachment.sig>