Re: xlogdump enhancements - Mailing list pgsql-hackers

From Diogo Biazus
Subject Re: xlogdump enhancements
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: xlogdump enhancements  ("Jonah H. Harris" <[email protected]>)
List pgsql-hackers


On 7/14/06, Jonah H. Harris <[email protected]> wrote:
On 7/14/06, Martijn van Oosterhout <[email protected]> wrote:
> If you really want to tackle this the hard way, find some other program
> that does it. Here one written in Perl that can decode most tuples, but
> not all. It fails because it doesn't recognise all the types.

Yep Diogo, Martijn is correct.  You have to reassemble the tuple and
then generate the appropriate SQL statement for it.  For this, you'll
definitely need the catalog information to resolve relations, type
handling, etc.

Thanks for the info, I'm taking a look in that program. Is good to have a starting point :-)

--
Diogo Biazus - [email protected]
Móvel Consultoria
http://www.movelinfo.com.br
http://www.postgresql.org.br

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: contrib promotion?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: monolithic distro