Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations - Mailing list pgsql-general

From Fujii Masao
Subject Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations
Date
Msg-id AANLkTi=2_OKfRdroCDMWGs8ysREzQ12B6aNX3_Dg7MZW@mail.gmail.com
Whole thread Raw
In response to Postgresql 9.1 pg_last_xact_replay_timestamp limitations  (Gabi Julien <gabi.julien@broadsign.com>)
List pgsql-general
Tree view 
On Wed, Dec 8, 2010 at 1:31 AM, Gabi Julien <gabi.julien@broadsign.com> wrote:
> pg_last_xact_replay_timestamp() returns null when the server is restarted until a new transaction is streamed to the
hotstandby server. It might take a long time before this happens. Because of this, we can't rely this function
completely.

I couldn't reproduce this. Could you provide a self-contained test case?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

pgsql-general by date:

Previous
From: ray
Date:
Subject: Service Doesn't Start
Next
From: bubba postgres
Date:
Subject: Abusing Postgres in interesting ways