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 978EE9FA0FF for ; Thu, 14 Sep 2006 22:20:44 -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 16363-04 for ; Fri, 15 Sep 2006 01:20:36 +0000 (UTC) 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 D1A419FA0FD for ; Thu, 14 Sep 2006 22:20:35 -0300 (ADT) Received: from mailnull by sharpasia.com.mo with FOLIO-Scan (FOLIO Messaging Router) id 1GO2NZ-000PBB-UQ; Fri, 15 Sep 2006 09:20:29 +0800 Message-ID: <1143.202.175.123.162.1158283228.mailsage.folio@sharpasia.com.mo> In-Reply-To: <20060915004924.GA32408@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> Date: Fri, 15 Sep 2006 09:20:28 +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.5399 X-FolioEngine-Probability: 0.0000 X-FolioEngine-Signature: 4509ffdd967911626714475 Received: from sharpasia.com.mo (localhost.sharpasia.com.mo [127.0.0.1]) by mailrelay.com.mo (FOLIO Messaging Relay) with ESMTP id 1EDB41E3B24; Fri, 15 Sep 2006 09:20:27 +0800 (HKT) Received: from 202.175.123.162 by sharpasia.com.mo with HTTP; Fri, 15 Sep 2006 09:20:28 +0800 (HKT) X-Folio-Scanned: by FolioScan Scanner (sharpasia.com.mo:28q0At.YFOCk6) X-Folio-Delivery: 1158283229 (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/163 X-Sequence-Number: 23077 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 Best, David ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ On Thu, Sep 14, 2006 at 11:13:43PM +0800, david.lao@sharpasia.com.mo wrote: > I starting my postgres with standard startup script /etc/rc.d/init.d/postgressql I didn't notice anything wrong with the script you posted. What happens if you run the "su" command that starts the postmaster directly from the command line? That is, the "su" on line 151 (you'll have to set the PGDATA environment variable or replace it with the path to your data directory): su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start What's the output of the following command? ls -l /bin/sh /usr/bin/pg_ctl /usr/bin/postmaster /usr/bin/postgres -- Michael Fuhr