Re: NAS

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Marco Fortina <marco(dot)fortina(at)bsc(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: NAS
Date: 2009-09-17 23:53:29
Message-ID: 4AB2CBF9.9010106@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marco Fortina wrote:
>
> Hello there!
>
> A customer of our company would like to create a 2 nodes cluster
> connected to an external NAS storage. I would like to know if
> PostgreSQL supports its datafiles on this kind of storage and if this
> solution is certified.
>

active/standby type cluster, where only one server has the database
software running at a time? in theory, should work. NAS storage is
often NOT recommended for database table storage, however, as it often
has funny quirks with regards to random access, concurrent access, and
so forth. early versions of NFS were especially bad about this. most
shared active/standby database high availability clusters use SAN block
storage for this reason (fiberchannel, iscsi), and those often use
'fencing hardware' to be sure that the current standby system doesn't
mount the file system when the other member is active.

afaik, postgresql doesn't 'certify' anything, and certainly most of us
on this email list do not speak for postgresql.org, we're mostly just users.

In response to

  • NAS at 2009-09-17 14:06:32 from Marco Fortina

Responses

  • Re: NAS at 2009-09-18 01:28:46 from Scott Marlowe

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-09-18 01:28:46 Re: NAS
Previous Message Brent Wood 2009-09-17 23:50:47 Re: haversine formula with postgreSQL