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: 42B280B5.2090007@cineca.it (view raw or flat)
Thread:
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:
>  
>
>>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.
>
>  
>

In response to

Responses

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-2014 The PostgreSQL Global Development Group