Re: BUG #6372: Error while creating database with fsync parameter as on incase of CIFS - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6372: Error while creating database with fsync parameter as on incase of CIFS
Date
Msg-id 1149.1325535272@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6372: Error while creating database with fsync parameter as on incase of CIFS  (Magnus Hagander <magnus@hagander.net>)
Responses Re: BUG #6372: Error while creating database with fsync parameter as on incase of CIFS  (Magnus Hagander <magnus@hagander.net>)
List pgsql-bugs
Magnus Hagander <magnus@hagander.net> writes:
> On Mon, Jan 2, 2012 at 17:27,  <anjali_524@yahoo.co.in> wrote:
>> PST ERROR:  could not fsync file "base/16409": Invalid argument Dec 30
>> 03:00:26 devok64-8 postgres_cifs_kaz_1[15812]: [2-2] [local] 15812
>> 2011-12-30 03:00:26.511 PST STATEMENT:  CREATE DATABASE "KazDB

The specific error seems to be coming from copydir.c's attempt to fsync
a directory.  We are already ignoring EBADF there, and could presumably
fix at least this symptom if we ignored EINVAL.

> PostgreSQL does not support data directory over CIFS.

I'm wondering what's your basis for asserting we don't support CIFS in
general?  It's probably not terribly bulletproof, but any worse than NFS?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Noah Misch
Date:
Subject: Re: Re: BUG #6264: Superuser does not have inherent Replication permission
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #6372: Error while creating database with fsync parameter as on incase of CIFS