From: | Jim Mlodgenski <jimmy76(at)gmail(dot)com> |
---|---|
To: | Bryan Keller <bryanck(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgres on NAS/NFS |
Date: | 2011-02-09 22:49:20 |
Message-ID: | AANLkTi=vkCQfQhQdp_cghbwrJaYYUVSt6E1_mLkEARn9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Feb 9, 2011 at 2:59 PM, Bryan Keller <bryanck(at)gmail(dot)com> 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?
DAS will absolutely work. Just be careful to fence things properly so
that you don't end up with 2 servers trying to start the data
directory at the same time. It will lead to some pretty nasty
corruption.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2011-02-10 05:15:54 | Re: Determining the WAL file needed by a standby |
Previous Message | Nicholson, Brad (Toronto, ON, CA) | 2011-02-09 20:37:04 | Determining the WAL file needed by a standby |