Re: Postgres on NAS/NFS

From: Scott Marlowe <scott(dot)marlowe(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-14 18:27:45
Message-ID: AANLkTindysuR+iX-q2BAH0CBnk6k6acVd9x8RwP_613d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Feb 14, 2011 at 11:05 AM, Bryan Keller <bryanck(at)gmail(dot)com> wrote:
> Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I a still going to shoot for using iSCSI, given it is a block-level protocol rather than file-level, it seems to me it would be better suited to database I/O.

Please note that until you've tested what happens when you pull the
power plugs on the NAS server midday to simulate a motherboard / PS /
UPS failure you don't really know how well this setup will survive
when things go wrong. The worst time to find out your pgsql -> NAS
setup can't handle sudden power loss etc is when the lights just went
out.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bineeta Guha 2011-02-15 04:34:49 pg_dump not working
Previous Message Bryan Keller 2011-02-14 18:05:43 Re: Postgres on NAS/NFS