RE: [GENERAL] backend corruption

2001-01-08 Thread Mikheev, Vadim
> I think that under 7.1, pg_log is not so critical anymore, but I'm not > sure. Vadim, any comment? Still critical till we implement UNDO and true changes rollback on transaction abort. Vadim

Re: [GENERAL] backend corruption

2001-01-06 Thread Brett W. McCoy
On Sat, 6 Jan 2001, Tom Lane wrote: > Yeah, but those files are only half the truth. The other half lives in > pg_log and the installation-wide tables (pg_database, etc). George is > correct: you cannot recover using only the contents of $PGDATA/base/foo. > You really need all of $PGDATA. Real

Re: [GENERAL] backend corruption

2001-01-06 Thread Tom Lane
"Brett W. McCoy" <[EMAIL PROTECTED]> writes: > On Sat, 6 Jan 2001, George Johnson wrote: >> So basically, I've wiped all my databases, it looks like, and no, there is >> no directory/structure which atomically can be called "your database", other >> than the ENTIRE data/base directory. > Sure the

Re: [GENERAL] backend corruption

2001-01-06 Thread Brett W. McCoy
On Sat, 6 Jan 2001, George Johnson wrote: > So basically, I've wiped all my databases, it looks like, and no, there is > no directory/structure which atomically can be called "your database", other > than the ENTIRE data/base directory. Sure there is -- under my $PGHOME/data/base, each separate