Re: [GENERAL] Data on NAS / NFS

2007-07-30 Thread Hannes Dorbath
On 28.07.2007 06:48, Jean-Denis Girard wrote: The NAS would be from LaCie, using 4 disks (Raid5 + spare) (http://www.lacie.com/fr/products/product.htm?pid=10876), mounted via NFS from a Linux server running Postgresql . Sorry, but that sounds like a sick setup.. 1.) RAID 5 is a bad choice for

Re: [GENERAL] Data on NAS / NFS

2007-07-30 Thread Joseph Shraibman
I've had trouble with NFS files on nfs filesystems disappearing for a second and reappearing. I had to add a retry loop with a delay in my code that does file reading. I wouldn't try running a production level postgres over nfs. ---(end of broadcast)--

Re: [GENERAL] Data on NAS / NFS

2007-07-28 Thread Greg Smith
On Fri, 27 Jul 2007, Jean-Denis Girard wrote: The NAS would be from LaCie, using 4 disks (Raid5 + spare) (http://www.lacie.com/fr/products/product.htm?pid=10876), mounted via NFS from a Linux server running Postgresql . Leaving aside the general issue here for others to chime in on (my opinio

[GENERAL] Data on NAS / NFS

2007-07-28 Thread Jean-Denis Girard
Hi list, I'm looking for advices / experiences concerning PostgreSQL with data storage on NAS via NFS. I've found a few references in the archives or the docs, but they are old, and opinions differ: . "There are a lot of horror stories concerning running databases (not only Postgres) over NFS