Re: [HACKERS] WAL dump tool

2009-05-17 Thread Rodrigo E . De León Plicet 
On Sun, May 10, 2009 at 12:23 AM, Robert Treat
xzi...@users.sourceforge.net wrote:
 On Saturday 09 May 2009 00:20:43 Jaime Casanova wrote:
 On Fri, May 8, 2009 at 3:43 AM, higepon hige...@gmail.com wrote:
  Hi.
  Is the following todo item still necessary?
 
   Create dump tool for write-ahead logs for use in determining
  transaction id for point-in-time recovery.
     This is useful for checking PITR recovery.
 
  If so, I want to make it.
  What is the expected output of the dump tool?
  TransactionId, TimeLineID and ?

 don't know if this project ever works
 http://pgfoundry.org/projects/xlogviewer but seems like is a start (it
 was made for 8.2 so you will have to adjust for 8.3 or even better
 8.4)

 It did work at one point. We used it for some disaster recovery work maybe a
 year or so ago. We had to update it for 8.3, and remove some linuxisms to get
 it to compile for Solaris. I think it might have still had issues actually
 dumping data, but it did do a good job at finding corrupted xlogs.  istr Theo
 submitted a patch, but I think the author had abandoned it. Personally I'd
 love to see it moved into postgresql proper (and get the cleaning/updating
 that implies).

Would this allow functionality similar to that of LogMiner (
http://www.oracle.com/technology/deploy/availability/htdocs/LogMinerOverview.htm
), or is it something else entirely?

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] NULL OR ZERO

2008-02-06 Thread Rodrigo E. De León Plicet 
On Feb 3, 2008 7:41 PM, Jaime Casanova [EMAIL PROTECTED] wrote:
 On Feb 3, 2008 7:26 PM, Omar Bettin [EMAIL PROTECTED] wrote:
  Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO.
  I know about standards...
 

 NULL means unknown value, ZERO is a known value

NULL represents absence of a value. You get the UNKNOWN truth value if
you compare NULL with any data value or another NULL (damn you, 3VL!).

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq