From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
Cc: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, HACKERS <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: (A) native Windows port |
Date: | 2002-07-10 15:48:21 |
Message-ID: | 1026316101.11766.67.camel@taru.tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Wed, 2002-07-10 at 16:20, Lamar Owen wrote:
> On Wednesday 10 July 2002 09:11 am, Hannu Krosing wrote:
> > On Wed, 2002-07-10 at 01:09, Lamar Owen wrote:
> > > The wc utility isn't in the path in an OS install situation. The df
> > > utility isn't in the path, either. You can use python, though. :-) Not
> > > that that would be a good thing in this context, however.
>
> > Why not ?
>
> > The following is wc in python
>
> [snip]
>
> > And I have written custom postgres table dumpers in python without too
> > much effort (except reverse-engineering the page structure ;) for both
> > 6.x and 7.x database tables, so we could actually use python here too.
>
> I'm willing to look into this. However, the dump still has to be pulled with
> a standalone backend -- no networking availability can be assumed.
Actually it works on raw table file ;)
I attach code that dumps data from page file for table of 4 ints all NOT
NULL, like
create table fourints(
i1 int not null,
i2 int not null,
i3 int not null,
i4 int not null
);
the script is meant for quick and dirty resque operations, and requires
that one writes their own data-field extractor code. I have used it
mainly to resurrect accidentally deleted data.
it is for 7.x style pagefile layout
-------------------
Hannu
Attachment | Content-Type | Size |
---|---|---|
dump4int.py | text/x-python | 2.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-07-10 15:54:01 | Re: Serious Crash last Friday |
Previous Message | Bruno Wolff III | 2002-07-10 15:47:21 | Re: ORDER BY and null values |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2002-07-10 15:54:15 | Re: (A) native Windows port |
Previous Message | Josh Berkus | 2002-07-10 15:44:59 | Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org |