X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 27BDF9FB1E2 for ; Fri, 15 Sep 2006 00:38:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 53479-01 for ; Fri, 15 Sep 2006 03:37:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 392219FB1DE for ; Fri, 15 Sep 2006 00:37:55 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.8/8.13.8) with ESMTP id k8F3bpUv065403 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Sep 2006 21:37:54 -0600 (MDT) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.8/8.13.8) with ESMTP id k8F3bp9q001596; Thu, 14 Sep 2006 21:37:51 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8F3bpKL001595; Thu, 14 Sep 2006 21:37:51 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Sep 2006 21:37:51 -0600 From: Michael Fuhr To: david.lao@sharpasia.com.mo Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: real and effective user ids must match Message-ID: <20060915033750.GA1374@winnie.fuhr.org> References: <006001c6d634$5a0ca760$0c00000a@davidlao> <20060914062633.GA72750@winnie.fuhr.org> <27572.1158238113@sss.pgh.pa.us> <50291.202.86.139.20.1158246823.mailsage.folio@sharpasia.com.mo> <20060915004924.GA32408@winnie.fuhr.org> <1143.202.175.123.162.1158283228.mailsage.folio@sharpasia.com.mo> <20060915014146.GA32900@winnie.fuhr.org> <1479.202.175.123.162.1158284982.mailsage.folio@sharpasia.com.mo> <20060915025331.GA1109@winnie.fuhr.org> <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.817 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL, UNPARSEABLE_RELAY X-Spam-Level: *** X-Archive-Number: 200609/142 X-Sequence-Number: 23056 On Fri, Sep 15, 2006 at 11:13:06AM +0800, david.lao@sharpasia.com.mo wrote: > Thanks, I will try to upgrade new viersion, the ouput of is > < > postmaster successfully started > /usr/bin/postmaster: real and effective user ids must match The postmaster still thinks it's running setuid; this error appears to be coming from backend/main/main.c (excerpt from the 7.2.2 source code): if (getuid() != geteuid()) { fprintf(stderr, gettext("%s: real and effective user ids must match\n"), argv[0]); exit(1); } Can you start the postmaster without using pg_ctl? Please post the output of the following commands (make sure PGDATA is set for the second one): su -l postgres -s /bin/sh -c id su -l postgres -s /bin/sh -c "/usr/bin/postmaster -D $PGDATA" What OS are you running? > the problem start after I restart the postgres service, there are nothing > change in postmaster since last time. When was the last time you successfully started the postmaster the same way you're trying now? How long had you been running PostgreSQL without any problems? If it used to work then something has changed. -- Michael Fuhr