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 D492B9F9F80 for ; Fri, 15 Sep 2006 00:57:07 -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 56172-02 for ; Fri, 15 Sep 2006 03:56:52 +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 3D6EF9F9F3D for ; Fri, 15 Sep 2006 00:56:22 -0300 (ADT) Received: from mailnull by sharpasia.com.mo with FOLIO-Scan (FOLIO Messaging Router) id 1GO4oO-0008z6-4U; Fri, 15 Sep 2006 11:56:20 +0800 Message-ID: <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> In-Reply-To: <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> <20060915033750.GA1374@winnie.fuhr.org> Date: Fri, 15 Sep 2006 11:56:18 +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=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-FolioEngine-Result: Innocent X-FolioEngine-Confidence: 0.6183 X-FolioEngine-Probability: 0.0000 X-FolioEngine-Signature: 450a2463345385804811194 Received: from sharpasia.com.mo (localhost.sharpasia.com.mo [127.0.0.1]) by mailrelay.com.mo (FOLIO Messaging Relay) with ESMTP id 22C161E3B98; Fri, 15 Sep 2006 11:56:17 +0800 (HKT) Received: from 202.175.123.162 by sharpasia.com.mo with HTTP; Fri, 15 Sep 2006 11:56:18 +0800 (HKT) X-Folio-Scanned: by FolioScan Scanner (sharpasia.com.mo:42DI/ZAbpZ0HU) X-Folio-Delivery: 1158292579 (10cc6c014fa2a4dc7fb7b2b7bf48103c) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.913 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, MSGID_FROM_MTA_HEADER, NO_REAL_NAME, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL, UNPARSEABLE_RELAY X-Spam-Level: **** X-Archive-Number: 200609/166 X-Sequence-Number: 23080 Hi, su -l postgres -s /bin/sh -c id output: uid=0(root) gid=26 euid=26(postgres) groups=26 su -l postgres -s /bin/sh -c "/usr/bin/postmaster -D $PGDATA" output /usr/bin/postmaster: real and effective user ids must match I am running Redhat 8, it is same way to start the postgres "/etc/rc.d/init.d/postgresql start", >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. I am running Redhat 8, it is same way to start the postgres "/etc/rc.d/init.d/postgresql start", I running postgre about 2 years ago, maybe it is the hacker do it, because before I found one unknown user and delect it, and then I restart the service with error. David