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 944779FA2D4 for ; Thu, 14 Sep 2006 22:49:55 -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 33497-10 for ; Thu, 14 Sep 2006 22:49:30 -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 4AD589FA0FD for ; Thu, 14 Sep 2006 22:49:47 -0300 (ADT) Received: from mailnull by sharpasia.com.mo with FOLIO-Scan (FOLIO Messaging Router) id 1GO2ps-0001ce-G4; Fri, 15 Sep 2006 09:49:44 +0800 Message-ID: <1479.202.175.123.162.1158284982.mailsage.folio@sharpasia.com.mo> In-Reply-To: <20060915014146.GA32900@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> Date: Fri, 15 Sep 2006 09:49:42 +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=big5 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-FolioEngine-Result: Innocent X-FolioEngine-Confidence: 0.7848 X-FolioEngine-Probability: 0.0000 X-FolioEngine-Signature: 450a06b862381048411440 Received: from sharpasia.com.mo (localhost.sharpasia.com.mo [127.0.0.1]) by mailrelay.com.mo (FOLIO Messaging Relay) with ESMTP id E11601E3834; Fri, 15 Sep 2006 09:49:41 +0800 (HKT) Received: from 202.175.123.162 (FOLIO Mail Server authenticated as david) by sharpasia.com.mo with HTTP; Fri, 15 Sep 2006 09:49:42 +0800 (HKT) X-Folio-Scanned: by FolioScan Scanner (sharpasia.com.mo:731WNskkEru76) X-Folio-Delivery: 1158284983 (10cc6c014fa2a4dc7fb7b2b7bf48103c) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.097 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, MSGID_FROM_MTA_HEADER, NO_REAL_NAME, UNPARSEABLE_RELAY X-Spam-Level: * X-Archive-Number: 200609/164 X-Sequence-Number: 23078 Hi, I am running postgresql 7.2.2-1. Best, David On Fri, Sep 15, 2006 at 09:20:28AM +0800, david.lao@sharpasia.com.mo wrote: > this is the command output > > lrwxrwxrwx 1 root root 4 Apr 3 2003 /bin/sh -> bash > -rwxr-xr-x 1 root root 9468 Sep 5 2002 /usr/bin/pg_ctl > -rwxr-xr-x 1 root root 3074760 Sep 5 2002 /usr/bin/postgres > lrwxrwxrwx 1 root root 8 Oct 29 2005 /usr/bin/postmaster -> postgres What version of PostgreSQL are you running? If those dates are correct then I'd guess 7.2.x or earlier. What about the output of the su command? -- Michael Fuhr