From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Bryan Keller <bryanck(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgres on NAS/NFS |
Date: | 2011-02-16 20:45:40 |
Message-ID: | 201102162045.p1GKje507355@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Bryan Keller wrote:
> I am considering running a Postgres with the database hosted on a NAS
> via NFS. I have read a few things on the Web saying this is not
> recommended, as it will be slow and could potentially cause data
> corruption.
>
> My goal is to have the database on a shared filesystem so in case of
> server failure, I can start up a standby Postgres server and point it
> to the same database. I would rather not use a SAN as I have heard
> horror stories about managing them. Also they are extremely expensive.
> A DAS would be another option, but I'm not sure if a DAS can be
> connected to two servers for server failover purposes.
>
> Currently I am considering not using a shared filesystem and instead
> using replication between the two servers.
>
> I am wondering what solutions have others used for my active-passive
> Postgres failover scenario? Is a NAS still not a recommended approach?
> Will a DAS work? Or is replication the best approach?
The last section of this documentation page talks about NFS usage:
http://www.postgresql.org/docs/9.0/static/creating-cluster.html
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-02-16 20:56:13 | Re: Postgres on NAS/NFS |
Previous Message | Scott Marlowe | 2011-02-16 20:35:03 | Re: Replication by schema |