Re: postgreSQL on NAS/SAN?

Hello Scott,

> RAID5 is fine for a database. It provides a fair compromise between
> speed, safety, and economy. If you need more speed, you might need to go
> to a RAID 1+0 (or 0+1).
Ok, well, because a progress-person (not postgresql) said, that it will be
not good for running a (general, not only progress) database on a RAID5
System.

> running postgresql on a NAS or SAN is quite doable, but you should test
> your configuration carefully. Note that many NAS units report write
> completion upon receipt of the data (i.e. before it's actually written) so
> you may have data integrity issues should the power go out in the middle
> of a transaction.
Ok, then we should use a SAN, if we need to use one.

> One thing you CANNOT do is allow two postmasters to write to the same data
> store. That WILL corrupt your database and cause problems.
This means, that postgreSQL isn't for configuring clusters? We don't need
one, but we do not know what the future brings :o(

Daniel