Re: BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

On Mon, Jan 2, 2012 at 17:27, <anjali_524(at)yahoo(dot)co(dot)in> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6372
> Logged by:          Anjali Arora
> Email address:      anjali_524(at)yahoo(dot)co(dot)in
> PostgreSQL version: 9.0.4
> Operating system:   Cent OS
> Description:
>
> The 8.2.2 postgres version works well with default fsync value on CIFS
> 2.6.32.

It does not, really. It may appear to, but it does not.

> This problem seems to be specific to postgres 9.0.4 release
>
> Error Message:
>
> 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
>
> Please help to make it work.

PostgreSQL does not support data directory over CIFS.

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