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 B62A632A00B for ; Mon, 18 Oct 2004 23:10:25 +0100 (BST) 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 46876-06 for ; Mon, 18 Oct 2004 22:10:15 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A247032A04C for ; Mon, 18 Oct 2004 23:10:17 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9IMAGCG008789; Mon, 18 Oct 2004 18:10:16 -0400 (EDT) To: "Taber, Mark" Cc: pgsql-admin@postgresql.org Subject: Re: postmaster -i option... In-reply-to: <7660B79A29B9D411999F00D0B78EC890726F5B@NTRK2> References: <7660B79A29B9D411999F00D0B78EC890726F5B@NTRK2> Comments: In-reply-to "Taber, Mark" message dated "Mon, 18 Oct 2004 14:07:16 -0700" Date: Mon, 18 Oct 2004 18:10:16 -0400 Message-ID: <8788.1098137416@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/224 X-Sequence-Number: 15217 "Taber, Mark" writes: > I restarted our dev postgres instance today with the -i option, and now, > using 'ps,', I am not able to see connections to the database any longer. > The production instance (running only with the -D option) shows the > connections. Am I going crazy, missing something obvious? I'm using the > command 'ps -ax | grep postgres' Is this Solaris by any chance? Solaris' ps has some weird interaction that causes it to not show the replacement command line unless same is longer than the original. So you generally want to keep the postmaster invocation to just "postmaster"; use a PGDATA environment variable instead of -D, and specify everything else in postgresql.conf. regards, tom lane