| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Kouber Saparev <postgresql(at)saparev(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Help me recovering data |
| Date: | 2005-02-15 09:18:21 |
| Message-ID: | 4211BE5D.3010604@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2005-02-15 09:22:03 | Re: UTF8 or Unicode |
| Previous Message | Kouber Saparev | 2005-02-15 08:48:56 | Re: Help me recovering data |