X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8A93C9FA0EF for ; Fri, 15 Sep 2006 00:13:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62077-08 for ; Fri, 15 Sep 2006 00:13:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sharpasia.com.mo (z83l17.static.ctm.net [202.175.83.17]) by postgresql.org (Postfix) with ESMTP id DFC279FA0C4 for ; Fri, 15 Sep 2006 00:13:10 -0300 (ADT) Received: from mailnull by sharpasia.com.mo with FOLIO-Scan (FOLIO Messaging Router) id 1GO48a-0006O9-9u; Fri, 15 Sep 2006 11:13:08 +0800 Message-ID: <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo> In-Reply-To: <20060915025331.GA1109@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> Date: Fri, 15 Sep 2006 11:13:06 +0800 (HKT) Subject: Re: real and effective user ids must match From: david.lao@sharpasia.com.mo To: Michael Fuhr , david.lao@sharpasia.com.mo Cc: Tom Lane , pgsql-admin@postgresql.org X-Mailer: MailSage FolioMail X-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) MIME-Version: 1.0 Content-Type: text/plain;charset=gb2312 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-FolioEngine-Result: Innocent X-FolioEngine-Confidence: 0.5561 X-FolioEngine-Probability: 0.0000 X-FolioEngine-Signature: 450a1a43245594127693746 Received: from sharpasia.com.mo (localhost.sharpasia.com.mo [127.0.0.1]) by mailrelay.com.mo (FOLIO Messaging Relay) with ESMTP id 127471E3B0E; Fri, 15 Sep 2006 11:13:05 +0800 (HKT) Received: from 202.175.123.162 (FOLIO Mail Server authenticated as david) by sharpasia.com.mo with HTTP; Fri, 15 Sep 2006 11:13:06 +0800 (HKT) X-Folio-Scanned: by FolioScan Scanner (sharpasia.com.mo:59vCPnympyVZg) X-Folio-Delivery: 1158289987 (10cc6c014fa2a4dc7fb7b2b7bf48103c) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.005 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, MSGID_FROM_MTA_HEADER, NO_REAL_NAME, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL, UNPARSEABLE_RELAY X-Spam-Level: *** X-Archive-Number: 200609/165 X-Sequence-Number: 23079 Hi, 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 problem start after I restart the postgres service, there are nothing change in postmaster since last time. Best, David On Fri, Sep 15, 2006 at 09:49:42AM +0800, david.lao@sharpasia.com.mo wrote: > I am running postgresql 7.2.2-1. If you're going to run 7.2 then you should run the latest version, 7.2.8, because earlier versions have serious data-loss bugs. But since 7.2 is no longer supported, I'd recommend upgrading to a modern version like 8.1.4 as soon as possible. As for getting the postmaster running, what's the output of the su command that I've requested a couple of times? When did this problem start? What has changed since the last time the postmaster started successfully? -- Michael Fuhr