Re: BUG #9849: walreceiver's DEBUG message reports wrong timestamp - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #9849: walreceiver's DEBUG message reports wrong timestamp
Date
Msg-id 6802.1396622997@sss.pgh.pa.us
Whole thread Raw
In response to BUG #9849: walreceiver's DEBUG message reports wrong timestamp  (harukat@sraoss.co.jp)
List pgsql-bugs
harukat@sraoss.co.jp writes:
> We get the folloging message at the standby server.

>  DEBUG:  sendtime 2014-04-04 11:26:02.425368+09 receipttime 2014-04-04
> 11:26:02.425368+09 replication apply delay 0 ms transfer latency 224043 ms

> Though sendtime equals receipttime, transfer latency is large.
> This receipttime may be wrong.

Yeah, somebody forgot that timestamptz_to_str returns a static buffer.

strdupa is not a portable solution though.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Shahar
Date:
Subject: Re: BUG #9833: daterange is not utilizing index correctly
Next
From:
Date:
Subject: Re: Configuring Standby Server in PostgreSQL 9.3.3