Re: FATAL: invalid value for parameter "wal_sync_method": - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: FATAL: invalid value for parameter "wal_sync_method":
Date
Msg-id 1118933212.3382.93.camel@state.g2switchworks.com
Whole thread Raw
In response to FATAL: invalid value for parameter "wal_sync_method": "open_datasync"  (Francesco Dalla Ca' <f.dallaca@cineca.it>)
Responses Re: FATAL: invalid value for parameter "wal_sync_method":  (Francesco Dalla Ca' <f.dallaca@cineca.it>)
List pgsql-admin
On Thu, 2005-06-16 at 09:35, Francesco Dalla Ca' wrote:
> O.S.:
> SuSE SLES-8 (i386)
> VERSION = 8.1
>
> After some test with the "syncbench" posted on performance mailing-list
> (http://archives.postgresql.org/pgsql-performance/2004-09/msg00080.php)
> i have obtained that open() with O_DSYNC was the fastest sync method.
> I want to test this for parameter "wal_sync_method" on a test workload
> directly on Postgres and i have configured that on postgresql.conf file:
>
> wal_sync_method = open_datasync
>
> But at the server start:
>
>  > pg_ctl -D /db10/postgres/data start
> postmaster starting
>  > FATAL:  invalid value for parameter "wal_sync_method": "open_datasync"
>
> What's wrong?

Not all methods are supported on all platforms.  It appears this one
isn't supported on yours.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


pgsql-admin by date:

Previous
From: Francesco Dalla Ca'
Date:
Subject: FATAL: invalid value for parameter "wal_sync_method": "open_datasync"
Next
From: grupos
Date:
Subject: Re: [SQL] PostgreSQL and Delphi 6