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