John R Pierce wrote: > On 11/11/2015 12:37 AM, Albe Laurenz wrote: > > It would be good to know of other pitfalls; I (and no doubt not only I) > > keep getting asked why we shouldn't run PostgreSQL on NFS when Oracle > > has no problem with it (and don't tell me that Oracle does not care > > about data corruption). > > Last I looked, Oracle had a very specific set of recommendations for > qualified NFS storage. Like, NetApp Filers, with everything setup > just so.
I had heard that before, so I looked and could not find any information which NFS devices are supported. All you read is: (http://docs.oracle.com/cd/E11882_01/install.112/e47689/app_nas.htm#LADBI1366) Before using the NAS device for the installation, verify that it is certified. For certification information refer to note 359515.1 on the My Oracle Support website I did, and all that contains is a list of mount options you have to use, e.g. for x86-64 Linux rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600 (the "bg" weirds me out) So I opened a service request about a year ago and asked them *what* NFS storage is supported. The answer (in unquotable English) was that it didn't matter what the NFS server was, as long as the NFS client is on a UNIX/Linux certified for Oracle database and you use the right mount options. At least that's what I understood ... 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
