Re: Help me recovering data - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Help me recovering data
Date
Msg-id 4211BE5D.3010604@familyhealth.com.au
Whole thread Raw
In response to Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Help me recovering data  (pgsql@mohawksoft.com)
List pgsql-hackers
> The checkpointer is entirely incapable of either detecting the problem
> (it doesn't have enough infrastructure to examine pg_database in a
> reasonable way) or preventing backends from doing anything if it did
> know there was a problem.

Well, I guess I meant 'some regularly running process'...

>>I think people'd rather their db just stopped accepting new transactions 
>>rather than just losing data...
> 
> Not being able to issue new transactions *is* data loss --- how are you
> going to get the system out of that state?

Not allowing any transactions except a vacuum...

> autovacuum is the correct long-term solution to this, not some kind of
> automatic hara-kiri.

Yeah, seems like it should really happen soon...

Chris


pgsql-hackers by date:

Previous
From: "Kouber Saparev"
Date:
Subject: Re: Help me recovering data
Next
From: Karel Zak
Date:
Subject: Re: UTF8 or Unicode