Re: BUG #9849: walreceiver's DEBUG message reports wrong timestamp

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: harukat@sraoss.co.jp
Cc: pgsql-bugs@postgresql.org
Date: 2014-04-04T14:49:57Z
Lists: 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