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

From Francesco Dalla Ca'
Subject Re: FATAL: invalid value for parameter "wal_sync_method":
Date
Msg-id 42B280B5.2090007@cineca.it
Whole thread Raw
In response to Re: FATAL: invalid value for parameter "wal_sync_method":  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: FATAL: invalid value for parameter "wal_sync_method":  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
This mean that method isn't supported by postgres on my platform?
Must i give some extra options at build time?
(i use postgresql 8.0.2 sources)

The test "syncbench" that i run on this server with the "open(O_DSYNC)"
method, give me results without problems.

Thanks and best regards.


Scott Marlowe wrote:

>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.
>
>
>

pgsql-admin by date:

Previous
From: Gourish Singbal
Date:
Subject: checkpoint are too frequent
Next
From: "Tomas Kratochvil"
Date:
Subject: pgAdminII download