Re: [GENERAL] embedded pgsql media-failure

2009-02-03 Thread Sam Mason
On Wed, Feb 04, 2009 at 12:35:33AM +0900, Craig Ringer wrote: > BTW, I'm not sure how much good OS-level RAID on a single device will do > for you. Linux will try to reset the interface to the drive on I/O > errors, will hang for long periods waiting for reads, etc and I wouldn't > be at all surpri

Re: [GENERAL] embedded pgsql media-failure

2009-02-03 Thread Sam Mason
On Tue, Feb 03, 2009 at 03:36:15PM +0100, Kokas Zsolt wrote: > > I've got (second-hand) recommendations of > > YAFFS, and have heard good things about JFFS2 as well. > > What I see from them is that they supported wear-leveling before > wear-leveling was included into the drives. Or for smaller,

Re: [GENERAL] embedded pgsql media-failure

2009-02-03 Thread Sam Mason
On Tue, Feb 03, 2009 at 12:03:11PM +0100, Kokas Zsolt wrote: > The businees's side wants to make it as secure as it is possible, > meaning, that the CF card will have two partitions, and the DB should > be mirrored or distributed somehow on this two partiton, in case of a > one-point disk-error the

Re: [GENERAL] embedded pgsql media-failure

2009-02-03 Thread Craig Ringer
Kokas Zsolt wrote: >> I've got (second-hand) recommendations of >> YAFFS, and have heard good things about JFFS2 as well. > > What I see from them is that they supported wear-leveling before > wear-leveling was included into the drives. AFAIK jffs2 and yaffs are really for simple (generally memor

Re: [GENERAL] embedded pgsql media-failure

2009-02-03 Thread Kokas Zsolt
> partitions. The OS should be able to deal with disk issues much more > robustly than PG. If you were more or less worried about things I As I see it now, it will be really the Soft-RAID what will suit for everybody here (including me) as well. > I'm not sure if you're trying to solve the wron

Re: [GENERAL] embedded pgsql media-failure

2009-02-03 Thread Thomas Markus
Hi, on a linux system try software raid1 for pg data. check if pg is the right choice for your needs here. maybe flat files for config+log is less problematic. regards thomas Kokas Zsolt schrieb: Hi! I'd need some advice. I'm working on a quite special field, I have to set up an embedded D