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

Re: pg_log deleted - what to do?

From: Ralf Tschiersch <ralf(at)net-service(dot)de>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_log deleted - what to do?
Date: 2000-10-01 19:25:21
Message-ID: Pine.LNX.4.10.10010012119040.30597-100000@dilbert.net-service.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi -

that's my understanding of pg_log, too. But what does the trick to
re-generate the indexes to make the tuples valid? If I do a select on one
of the larger tables (>100.000 tuples), all data is being loaded since it
take the "usual" moment of accessing the corresponding file. But then, the
tuples are not valid in some way, you see.

I only remember like a "flash", that the pg_log-file was large. We have no
blobs inside the tables. Would'nt it be possible to "scan" the raw
table-files an to re-engineer the data? This seems easier to me than
fiddling with transaction-logs. The pity is, that the transaction-log also
affects the system's tables....

Whatever is possible, time is no problem. Getting the data back is what
has to be done....

Ralf

PS: "COMMIT *" or what? Bitter joke... or "ROLLBACK 'rm'". 

On Sun, 1 Oct 2000, Peter Eisentraut wrote:

> Bruce Momjian writes:
> 
> > Can the user rename the /data directory, do initdb, save the pg_log
> > file, move the old /data back into place, add the new pg_log, and do a
> > backup of his data?
> 
> My understanding is that pg_log contains flags about which transactions
> have committed, from which is inferred what tuples are valid.  So
> theoretically you could set "all transactions have committed" in pg_log
> and pick out the tuples you like from the tables (after having gotten past
> the horribly corrupted indexes).  But that seems like a pretty complicated
> undertaking in any case.
> 
> 
> -- 
> Peter Eisentraut      peter_e(at)gmx(dot)net       http://yi.org/peter-e/
> 


In response to

pgsql-admin by date

Next:From: Ralf TschierschDate: 2000-10-01 20:02:32
Subject: Re: pg_log deleted - what to do?
Previous:From: Peter EisentrautDate: 2000-10-01 19:16:41
Subject: Re: pg_log deleted - what to do?

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