| From: | Bryan Keller <bryanck(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Postgres on NAS/NFS |
| Date: | 2011-02-09 19:31:29 |
| Message-ID: | 77A74B6C-A4BE-4659-A07A-2F03B617DF7B@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryan Keller | 2011-02-09 19:34:56 | Postgres with NAS/NFS |
| Previous Message | Prabhjot S. Sheena | 2011-02-09 18:57:15 | Intallation of postgres 9.0.3 gives an error on already installed postgres 8.4 on the same machine |