Postgres Pro
Downloads
Home   >   mailing lists

Re: per backend nofsync - Mailing list pgsql-novice

From Tom Lane
Subject Re: per backend nofsync
Date
Msg-id 22036.980184080@sss.pgh.pa.us
Whole thread Raw
In response to per backend nofsync  (Ameurlain Antoine <aameurlain@prosodie.com>)
List pgsql-novice
Tree view 
Ameurlain Antoine <aameurlain@prosodie.com> writes:
>   I woul like to know if it's possible to set a nofsync behavior of a
> pgsql database at the client connection time.

This works in (IIRC) 7.0.2 and later.  Run the postmaster with fsync by
default, and set PGOPTIONS="-F" on the client side for the clients
that don't want fsync.

            regards, tom lane

pgsql-novice by date:

Previous
From: Ameurlain Antoine
Date:
Subject: per backend nofsync
Next
From: Rick Jones
Date:
Subject: Inserting TEXT with multiple lines