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

Re: pg_log deleted - what to do?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Ralf Tschiersch <ralf(at)net-service(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_log deleted - what to do?
Date: 2000-10-01 19:16:41
Message-ID: Pine.LNX.4.21.0010012113280.1031-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Ralf TschierschDate: 2000-10-01 19:25:21
Subject: Re: pg_log deleted - what to do?
Previous:From: Ralf TschierschDate: 2000-10-01 18:14:39
Subject: Re: pg_log deleted - what to do?

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