Thread: NFS/NAS

How well does Postgres handle running the DB from a NAS? 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? With a load balancer in front
you could really scale the hell out of it. What are the implications?

Thanks!

-James

James Kelty
Sr. Unix Systems Administrator
Everbase Systems, LLC
541.488.0801
jamesk@everbase.net

"James Kelty" <jamesk@ashlandagency.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

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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Thursday, June 27, 2002 8:56 PM
To: James Kelty
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] NFS/NAS


"James Kelty" <jamesk@ashlandagency.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