From: | "Daniel Seichter" <daniel(at)dseichter(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgreSQL on NAS/SAN? |
Date: | 2003-06-17 06:20:35 |
Message-ID: | bcmbvj$kit$1@main.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-06-17 06:45:28 | Re: full featured alter table? |
Previous Message | Nicolas Boretos | 2003-06-17 05:45:43 | Re: connect postgres database with tk interface |