Re: NFS/NAS

From: "James Kelty" <jamesk(at)ashlandagency(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: NFS/NAS
Date: 2002-06-28 17:24:26
Message-ID: DAEBINOFJKIEABJAMLLCAEHNCHAA.jamesk@ashlandagency.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hmmmm. Ok well, thanks for the input. Do you know of any decent replication
services then so I can use a satalite server farm?

-James

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
Sent: Thursday, June 27, 2002 8:56 PM
To: James Kelty
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] NFS/NAS

"James Kelty" <jamesk(at)ashlandagency(dot)com> writes:
> How well does Postgres handle running the DB from a NAS?

Postgres doesn't care, although a lot of the oldtimers here will tell
you not to use NFS for any data you care about. Check the archives
for some horror stories.

> For instance, can I
> have 10 single cpu systems all running the Postgres daemon with the data
> directory on a NetApp or some other device?

This will NOT work. One data directory, one postmaster, no more.

Multi CPUs in an SMP box is fine, but not independent systems.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message stev knowles 2002-06-28 19:08:32 Re: command length?
Previous Message Brian Johnson 2002-06-28 14:05:06 PostgreSQL setup on dual boot laptop