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

On Mon, Jan 2, 2012 at 17:27,  <anjali_524@yahoo.co.in> wrote:
> The following bug has been logged on the website:
>
> Bug reference: =A0 =A0 =A06372
> Logged by: =A0 =A0 =A0 =A0 =A0Anjali Arora
> Email address: =A0 =A0 =A0anjali_524@yahoo.co.in
> PostgreSQL version: 9.0.4
> Operating system: =A0 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: =A0could 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: =A0CREATE DATABASE "KazDB
>
> Please help to make it work.

PostgreSQL does not support data directory over CIFS.

--=20
=A0Magnus Hagander
=A0Me: http://www.hagander.net/
=A0Work: http://www.redpill-linpro.com/