X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E858952836 for ; Fri, 17 Jun 2005 04:50:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44745-03 for ; Fri, 17 Jun 2005 07:50:18 +0000 (GMT) Received: from as1.cineca.com (as1.cineca.com [130.186.84.251]) by svr1.postgresql.org (Postfix) with ESMTP id A174A5280D for ; Fri, 17 Jun 2005 04:50:17 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by as1.cineca.com (Postfix) with ESMTP id 6405265939; Fri, 17 Jun 2005 07:50:17 +0000 (UTC) Received: from cineca.mm.cineca.it (cineca.mm.cineca.it [130.186.10.200]) by as1.cineca.com (Postfix) with ESMTP id F391B6592A; Fri, 17 Jun 2005 07:50:14 +0000 (UTC) Received: from [130.186.7.197] (dhcp7-197.cineca.it [130.186.7.197]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) as user f.dallaca@cineca.it by cineca.mm.cineca.it (Postfix) with ESMTP id 2F3DE2CD400; Fri, 17 Jun 2005 09:50:14 +0200 (MEST) Message-ID: <42B280B5.2090007@cineca.it> From: Francesco Dalla Ca' Organization: CINECA User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050513 Fedora/1.7.8-1.3.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Scott Marlowe Cc: pgsql-admin@postgresql.org Subject: Re: FATAL: invalid value for parameter "wal_sync_method": References: <42B18E4D.6070603@cineca.it> <1118933212.3382.93.camel@state.g2switchworks.com> In-Reply-To: <1118933212.3382.93.camel@state.g2switchworks.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Date: Fri, 17 Jun 2005 09:50:14 +0200 (MEST) X-Virus-Scanned: Cineca AppOs 0.85 at as1.cineca.com X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/123 X-Sequence-Number: 17878 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. > > >