PG V9 on NFS

On 2/11/2013 4:22 PM, Gauthier, Dave wrote:

Can PG V9.1* support a DB that's on an NFS disk?

I googled around, but nothing popped out.

Also, would you happen to know the answer to this for MySQL v5.5*?

Thanks in Advance.

That would be (IMHO) very ill-advised. In the event of a disruption
between the two systems you're virtually guaranteed to suffer data
corruption which is (much worse) rather likely to go undetected.

--
-- Karl Denninger
/The Market Ticker ®/ <http://market-ticker.org&gt;
Cuda Systems LLC

On Mon, Feb 11, 2013 at 5:22 PM, Gauthier, Dave <dave.gauthier@intel.com>wrote:

Can PG V9.1* support a DB that's on an NFS disk?****

I googled around, but nothing popped out.****

Also, would you happen to know the answer to this for MySQL v5.5*? ****

Thanks in Advance.

I've done this before, and I really wish I hadn't. NFS has gotten speedier
and more reliable, but the tendency to lock up an entire system and crash
unexpectedly is still there. The other thing with NFS is that it is a lot
easier for people to try and run multi-headed clusters ( which, isn't
supported in postgres and will cause corruption if you do it). If network
based storage is really a need, take a look at iSCSI or ATA over ethernet.
I've had great luck there.

--Scott

Hi,

On Mon, 2013-02-11 at 22:22 +0000, Gauthier, Dave wrote:

Can PG V9.1* support a DB that's on an NFS disk?

/messages/by-id/25517.1191038302@sss.pgh.pa.us

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

On Tue, Feb 12, 2013 at 2:25 AM, Devrim GÜNDÜZ <devrim@gunduz.org> wrote:

Hi,

On Mon, 2013-02-11 at 22:22 +0000, Gauthier, Dave wrote:

Can PG V9.1* support a DB that's on an NFS disk?

/messages/by-id/25517.1191038302@sss.pgh.pa.us

Note that that email is more than 5 years old. A lot has happened in
the linux kernel since then.

It's perfectly possible to run PostgreSQL reliable on NFS. But it's
quite hard to set all the parameters correct to get both decent
performance and some sort of reliability. And it's very easy to get it
wrong, and end up with data corruption. If you don't know exactly what
to do there, I would definitely advice you not to try it.

And don't even consider it without a high-end dedicated filer as the backend.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

OK, with the help of this feedback, they caved and will keep it local storage.
Thanks !

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 2/12/2013 5:28 AM, Magnus Hagander wrote:

And don't even consider it without a high-end dedicated filer as the backend.

Oracle supports a Netapp Filer with NFSv4, and a specific set of
configurations. they don't support anything else NFS last I heard.
whats good for Oracle is generally good for Postgres.

of course, Netapp Filer is some of the most expensive storage per
gigabyte you'll ever deal with.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

John R Pierce wrote:

Oracle supports a Netapp Filer with NFSv4, and a specific set of
configurations. they don't support anything else NFS last I heard.
whats good for Oracle is generally good for Postgres.

Oracle supports NFS everywhere except on Windows.
The new "direct NFS" feature (where the database server
acts as NFS client) does not support NFS v4, but
other than that it is supported.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general