> >
> >> We should return the timestamp of last valid checkpoint rather than NULL
> >> in that
> >> case?
> >
> > Well, I think this behavior would be more appreciated by postgresql users
> > in general. The case where the slave can be restarted after a clean
> > shutdown is rare but we need to
On Fri, Dec 10, 2010 at 1:24 AM, Gabi Julien wrote:
> On Wednesday 08 December 2010 21:58:46 you wrote:
>> On Thu, Dec 9, 2010 at 1:37 AM, Gabi Julien
>> wrote:
>> > slave# /etc/init.d/postgresql start
>> > slave# psql -hlocalhost my_db -c "select pg_last_xact_replay_timestamp(),
>> > now() as
On Wednesday 08 December 2010 21:58:46 you wrote:
> On Thu, Dec 9, 2010 at 1:37 AM, Gabi Julien wrote:
> > slave# /etc/init.d/postgresql start
> > slave# psql -hlocalhost my_db -c "select pg_last_xact_replay_timestamp(),
> > now() as not_modified_since;"
> > pg_last_xact_replay_timestamp |
On Thu, Dec 9, 2010 at 1:37 AM, Gabi Julien wrote:
> slave# /etc/init.d/postgresql start
> slave# psql -hlocalhost my_db -c "select pg_last_xact_replay_timestamp(),
> now() as not_modified_since;"
> pg_last_xact_replay_timestamp | not_modified_since
> ---+---
Gabi Julien writes:
> I just tried with postgresql 9.1alpha from
> http://www.enterprisedb.com/products/pgdevdownload.do (linux x86-32):
> postgres=# select pg_last_xact_replay_timestamp(), now() as
> not_modified_since;
> ERROR: function pg_last_xact_replay_timestamp() does not exist
> LINE 1:
I just tried with postgresql 9.1alpha from
http://www.enterprisedb.com/products/pgdevdownload.do (linux x86-32):
postgres=# select pg_last_xact_replay_timestamp(), now() as not_modified_since;
ERROR: function pg_last_xact_replay_timestamp() does not exist
LINE 1: select pg_last_xact_replay_times
On Tuesday 07 December 2010 21:58:56 you wrote:
> On Wed, Dec 8, 2010 at 1:31 AM, Gabi Julien wrote:
> > pg_last_xact_replay_timestamp() returns null when the server is restarted
> > until a new transaction is streamed to the hot standby server. It might
> > take a long time before this happens.
On Wed, Dec 8, 2010 at 1:31 AM, Gabi Julien wrote:
> pg_last_xact_replay_timestamp() returns null when the server is restarted
> until a new transaction is streamed to the hot standby server. It might take
> a long time before this happens. Because of this, we can't rely this function
> complet
