Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group