Re: postgreSQL on NAS/SAN? - Mailing list pgsql-general

From Daniel Seichter
Subject Re: postgreSQL on NAS/SAN?
Date
Msg-id bcmbvj$kit$1@main.gmane.org
Whole thread Raw
In response to postgreSQL on NAS/SAN?  ("Daniel Seichter" <daniel@dseichter.de>)
Responses Re: postgreSQL on NAS/SAN?
List 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



pgsql-general by date:

Previous
From: Nicolas Boretos
Date:
Subject: Re: connect postgres database with tk interface
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: full featured alter table?