Skip site navigation (1) Skip section navigation (2)

Re: Proposed doc-patch: Identifying the Current WAL file

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>, "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-docs(at)postgresql(dot)org
Subject: Re: Proposed doc-patch: Identifying the Current WAL file
Date: 2006-04-16 08:22:08
Message-ID: c2d9e70e0604160122w7bd6da4w1fd03caeb7471791@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
On 4/15/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > The point is that the test does not have a
> > one-second window of showing the wrong answer, meaning I could wait for
> > 60 seconds, and still see the wrong WAL file at the top.
>
> Oh, I see your point: you can lose at most one second's worth of data,
> but that second could be arbitrarily long ago if it was the latest
> activity in the database.  Yeah, that's a bit unpleasant.  So we really
> do need both parts of the ordering rule, and there seems no way to do
> that with just 'ls'.
>
> I wonder if you could do anything with find(1)'s -newer switch?
> It seems to be a '>' condition not a '>=' condition, so it'd be
> pretty awkward ... certainly not a one-liner.
>
> I think everyone agrees that adding a SQL function would be a reasonable
> thing to do, anyway.
>
>                        regards, tom lane
>

specially for those using windows that hadn't those wonderfull tools... :)

--
regards,
Jaime Casanova

"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
                           Randal L. Schwartz

In response to

pgsql-docs by date

Next:From: Simon RiggsDate: 2006-04-16 14:22:05
Subject: Re: Proposed doc-patch: Identifying the Current WAL file
Previous:From: Bruce MomjianDate: 2006-04-15 20:20:45
Subject: Re: Proposed doc-patch: Identifying the Current WAL file

pgsql-patches by date

Next:From: Simon RiggsDate: 2006-04-16 14:22:05
Subject: Re: Proposed doc-patch: Identifying the Current WAL file
Previous:From: Nicolas BarbierDate: 2006-04-15 21:21:54
Subject: Re: Documentation patch: change a name in a grammar rule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group