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 1E7A352849 for ; Thu, 16 Jun 2005 11:36:56 -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 60486-08 for ; Thu, 16 Jun 2005 14:35:59 +0000 (GMT) Received: from as2.cineca.com (as2.cineca.com [130.186.84.242]) by svr1.postgresql.org (Postfix) with ESMTP id 77CDC52863 for ; Thu, 16 Jun 2005 11:35:58 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by as2.cineca.com (Postfix) with ESMTP id 3618765943 for ; Thu, 16 Jun 2005 14:36:01 +0000 (UTC) Received: from cineca.mm.cineca.it (cineca.mm.cineca.it [130.186.10.200]) by as2.cineca.com (Postfix) with ESMTP id 5C2DC65934 for ; Thu, 16 Jun 2005 14:35:58 +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 1C40A4870CD for ; Thu, 16 Jun 2005 16:35:58 +0200 (MEST) Message-ID: <42B18E4D.6070603@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: pgsql-admin@postgresql.org Subject: FATAL: invalid value for parameter "wal_sync_method": "open_datasync" Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Date: Thu, 16 Jun 2005 16:35:58 +0200 (MEST) X-Virus-Scanned: Cineca AppOs 0.85 at as2.cineca.com X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/118 X-Sequence-Number: 17873 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? Best regards.