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

Some additions to pg_filedump...

From: "Darren Reed" <darrenr+postgres(at)fastmail(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Some additions to pg_filedump...
Date: 2008-04-21 11:51:21
Message-ID: 1208778681.11353.1248996817@webmail.messagingengine.com (view raw or flat)
Thread:
Lists: pgsql-admin
I did a bit of hacking on pg_filedump to make it slightly more
useful...but it wasn't clear where or to whom the patches should
be sent, so I'm sending an email to pgsql-admins 'cause they're
the kind of folks that probably care about them...

The changes I added are two command line options:
-F <filter> to filter out which items get dumped.
   presently only works on the infomask field.
-T <types> to dump out each item according to either
   int,char,varchar,bool types (yes, I know, that's
   not all of the postgres types.)
-q to supress lots of additional output (quiet)

Now, combined they allow data to be recovered from a situation
where the index is fubar'd but you've still got good data and
you don't want to recover from backup...that said, there is
great danger because pg_filedump doesn't know which item from
the dataset is the most recent/alive one.

If there's further interest, I can add more types but the
warning above holds.  pg_filedump shouldn't be used for what
the above makes easy but I can't see why that shouldn't be
a decision we (and not the db) gets to make...

Cheers,
Darren

http://coombs.anu.edu.au/~avalon/pg_fd_FT.patch.gz

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-04-21 18:56:40
Subject: Re: Help Postgresql to start on Suse 10.2
Previous:From: Monalee BhandgeDate: 2008-04-21 09:18:59
Subject: Help Postgresql to start on Suse 10.2

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