Skip site navigation (1) Skip section navigation (2)

Re: FATAL: invalid value for parameter "wal_sync_method":

From: Francesco Dalla Ca' <f(dot)dallaca(at)cineca(dot)it>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: FATAL: invalid value for parameter "wal_sync_method":
Date: 2005-06-17 07:50:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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:
>>SuSE SLES-8 (i386)
>>VERSION = 8.1
>>After some test with the "syncbench" posted on performance mailing-list 
>>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.

In response to


pgsql-admin by date

Next:From: Tomas KratochvilDate: 2005-06-17 08:22:31
Subject: pgAdminII download
Previous:From: Gourish SingbalDate: 2005-06-17 06:25:33
Subject: checkpoint are too frequent

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group