Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0CE979FA492 for ; Wed, 27 Dec 2006 20:45:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 31387-09 for ; Wed, 27 Dec 2006 20:45:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 592569FA49D for ; Wed, 27 Dec 2006 20:45:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from elasmtp-kukur.atl.sa.earthlink.net (elasmtp-kukur.atl.sa.earthlink.net [209.86.89.65]) by svr4.postgresql.org (Postfix) with ESMTP id 8C7745AF8BC for ; Thu, 28 Dec 2006 00:45:49 +0000 (GMT) Received: from [4.239.186.39] (helo=mindspring.com) by elasmtp-kukur.atl.sa.earthlink.net with asmtp (TLSv1:AES256-SHA:256) (Exim 4.34) id 1GzjP1-00054j-1B for pgsql-admin@postgresql.org; Wed, 27 Dec 2006 19:45:48 -0500 Received: (from lbayuk@localhost) by mindspring.com (8.13.7/8.13.7) id kBS0hSXZ000367 for pgsql-admin@postgresql.org; Wed, 27 Dec 2006 19:43:28 -0500 Date: Wed, 27 Dec 2006 19:43:28 -0500 From: L Bayuk To: pgsql-admin@postgresql.org Subject: 8.2.0 upgrade issue: postmaster -S Message-ID: <20061228004328.GA364@mail.mindspring.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.2i X-ELNK-Trace: 7a0205cf9d42df0a5e89bb4777695beb69025943178dce0bf0268a3030accd04c0ed74e9ec4ea882350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 4.239.186.39 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200612/342 X-Sequence-Number: 24134 Something to watch out for when upgrading to 8.2.0: My server start command for 8.1.5 and many prior releases: $ postmaster -D /opt/postgres/data -S -i Try it at 8.2.0: $ postmaster -D /opt/postgres/data -S -i FATAL: parameter "work_mem" requires an integer value Reason: 'postmaster' and 'postgres' merged into one command. postmaster -S used to mean: silent mode. Now it means: Set memory used for sorting. Unfortunately, the reference manual still documents the old meaning for -S (PostgreSQL Server Applications, postgres command, -S option). Actually it switched. At 8.1.5 the manual said "postgres -S" meant set sort memory, and "postmaster -S" meant silent. At 8.2.0 "postmaster" is a "deprecated alias of postgres", and "postgres -S" is now documented as silent mode. But it isn't. Yes, I know, I should have switched to using "pg_ctl start" before now.