From david.lao@sharpasia.com.mo Tue Sep 12 06:52:19 2006 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 AE0299FA2CA for ; Tue, 12 Sep 2006 03:52:19 -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 33449-07 for ; Tue, 12 Sep 2006 06:52:11 +0000 (UTC) X-Greylist: delayed 00:25:52.478298 by SQLgrey- Received: from smtp1.macau.ctm.net (smtp1.macau.ctm.net [202.175.3.59]) by postgresql.org (Postfix) with ESMTP id 2DA269FA2A9 for ; Tue, 12 Sep 2006 03:52:11 -0300 (ADT) Received: from smtp1.macau.ctm.net (localhost [127.0.0.1]) by localhost.macau.ctm.net (Postfix) with ESMTP id 2B5FF1A628E for ; Tue, 12 Sep 2006 14:26:13 +0800 (HKT) Received: from davidlao (z123l162.static.ctm.net [202.175.123.162]) by smtp1.macau.ctm.net (Postfix) with ESMTP id EC0441A628A for ; Tue, 12 Sep 2006 14:26:08 +0800 (HKT) Message-ID: <006001c6d634$5a0ca760$0c00000a@davidlao> From: "Liustech" To: Subject: real and effective user ids must match Date: Tue, 12 Sep 2006 14:26:11 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005D_01C6D677.65649260" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200609/120 X-Sequence-Number: 23034 This is a multi-part message in MIME format. ------=_NextPart_000_005D_01C6D677.65649260 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable My postgres can not start up, I get this error message: postmaster successfully started /usr/bin/postmaster: real and effective user ids must match and Sep 12 14:18:26 TWeb su(pam_unix)[6683]: session opened for user = postgres by (uid=3D0) Sep 12 14:18:26 TWeb su(pam_unix)[6683]: session closed for user = postgres Sep 12 14:18:29 TWeb su(pam_unix)[6702]: session opened for user = postgres by (uid=3D0) Sep 12 14:18:29 TWeb su(pam_unix)[6702]: session closed for user = postgres Sep 12 14:18:30 TWeb postgresql: Starting postgresql service: failed what is happen and how to fix it? regards David ------=_NextPart_000_005D_01C6D677.65649260 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
My postgres can not start up,  I get this error = message:
 
postmaster successfully = started
/usr/bin/postmaster: real=20 and effective user ids must match
 
and
 
Sep 12 14:18:26 TWeb su(pam_unix)[6683]: session = opened for=20 user postgres by (uid=3D0)
Sep 12 14:18:26 TWeb su(pam_unix)[6683]: = session=20 closed for user postgres
Sep 12 14:18:29 TWeb su(pam_unix)[6702]: = session=20 opened for user postgres by (uid=3D0)
Sep 12 14:18:29 TWeb = su(pam_unix)[6702]:=20 session closed for user postgres
Sep 12 14:18:30 TWeb postgresql: = Starting=20 postgresql service:  failed
what is happen and how to fix it?
 
regards
David
------=_NextPart_000_005D_01C6D677.65649260-- From mike@fuhr.org Thu Sep 14 06:26:44 2006 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 A5C109FA43B for ; Thu, 14 Sep 2006 03:26: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 65026-08 for ; Thu, 14 Sep 2006 06:26:41 +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 221179FA36A for ; Thu, 14 Sep 2006 03:26:40 -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 k8E6QYAx064122 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Sep 2006 00:26:36 -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 k8E6QX0r072907; Thu, 14 Sep 2006 00:26:33 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8E6QXcA072906; Thu, 14 Sep 2006 00:26:33 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Sep 2006 00:26:33 -0600 From: Michael Fuhr To: Liustech Cc: pgsql-admin@postgresql.org Subject: Re: real and effective user ids must match Message-ID: <20060914062633.GA72750@winnie.fuhr.org> References: <006001c6d634$5a0ca760$0c00000a@davidlao> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <006001c6d634$5a0ca760$0c00000a@davidlao> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200609/124 X-Sequence-Number: 23038 On Tue, Sep 12, 2006 at 02:26:11PM +0800, Liustech wrote: > My postgres can not start up, I get this error message: > > postmaster successfully started > /usr/bin/postmaster: real and effective user ids must match How are you starting the postmaster? The error suggests that the postmaster or the program that runs the postmaster is setuid. For security reasons PostgreSQL refuses to run that way. -- Michael Fuhr From tgl@sss.pgh.pa.us Thu Sep 14 12:48:51 2006 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 4CB769FA088 for ; Thu, 14 Sep 2006 09:48:51 -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 52517-09 for ; Thu, 14 Sep 2006 12:48:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 38BB89FA2EA for ; Thu, 14 Sep 2006 09:48:42 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8ECmXg7027573; Thu, 14 Sep 2006 08:48:33 -0400 (EDT) To: Michael Fuhr cc: Liustech , pgsql-admin@postgresql.org Subject: Re: real and effective user ids must match In-reply-to: <20060914062633.GA72750@winnie.fuhr.org> References: <006001c6d634$5a0ca760$0c00000a@davidlao> <20060914062633.GA72750@winnie.fuhr.org> Comments: In-reply-to Michael Fuhr message dated "Thu, 14 Sep 2006 00:26:33 -0600" Date: Thu, 14 Sep 2006 08:48:33 -0400 Message-ID: <27572.1158238113@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/126 X-Sequence-Number: 23040 Michael Fuhr writes: > On Tue, Sep 12, 2006 at 02:26:11PM +0800, Liustech wrote: >> My postgres can not start up, I get this error message: >> >> postmaster successfully started >> /usr/bin/postmaster: real and effective user ids must match > How are you starting the postmaster? The error suggests that the > postmaster or the program that runs the postmaster is setuid. Another possibility is that he's doing su postgres -c "postmaster ..." where it should be su - postgres -c "postmaster ..." I'm not certain this would produce exactly the described failure, but it's something to check. regards, tom lane From mike@fuhr.org Fri Sep 15 00:50:41 2006 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 08A059FB221 for ; Thu, 14 Sep 2006 21:50:41 -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 32312-03-8 for ; Thu, 14 Sep 2006 21:50:15 -0300 (ADT) 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 C28E09FB2A2 for ; Thu, 14 Sep 2006 21:49:29 -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 k8F0nOB9065250 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Sep 2006 18:49:27 -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 k8F0nOFX032601; Thu, 14 Sep 2006 18:49:24 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8F0nOF5032600; Thu, 14 Sep 2006 18:49:24 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Sep 2006 18:49:24 -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: <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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <50291.202.86.139.20.1158246823.mailsage.folio@sharpasia.com.mo> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.16 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/139 X-Sequence-Number: 23053 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 From david.lao@sharpasia.com.mo Fri Sep 15 01:20:44 2006 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 From mike@fuhr.org Fri Sep 15 01:41:56 2006 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 42E299FB1D7 for ; Thu, 14 Sep 2006 22:41:56 -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 34357-08 for ; Thu, 14 Sep 2006 22:41:34 -0300 (ADT) 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 CB6209FA0FF for ; Thu, 14 Sep 2006 22:41:51 -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 k8F1flHg065293 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Sep 2006 19:41:49 -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 k8F1fkF1032942; Thu, 14 Sep 2006 19:41:46 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8F1fkSi032941; Thu, 14 Sep 2006 19:41:46 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Sep 2006 19:41:46 -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: <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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1143.202.175.123.162.1158283228.mailsage.folio@sharpasia.com.mo> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.159 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/140 X-Sequence-Number: 23054 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 From david.lao@sharpasia.com.mo Fri Sep 15 01:49:55 2006 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 From mike@fuhr.org Fri Sep 15 02:53:51 2006 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 808F49FA0C4 for ; Thu, 14 Sep 2006 23:53:51 -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 30904-09 for ; Fri, 15 Sep 2006 02:53:39 +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 E17499FA0C0 for ; Thu, 14 Sep 2006 23:53:38 -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 k8F2rXoo065366 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Sep 2006 20:53:36 -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 k8F2rXlR001224; Thu, 14 Sep 2006 20:53:33 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8F2rV8m001223; Thu, 14 Sep 2006 20:53:31 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Sep 2006 20:53:31 -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: <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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1479.202.175.123.162.1158284982.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/141 X-Sequence-Number: 23055 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 From david.lao@sharpasia.com.mo Fri Sep 15 03:13:49 2006 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 From mike@fuhr.org Fri Sep 15 03:38:08 2006 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 From david.lao@sharpasia.com.mo Fri Sep 15 03:57:07 2006 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 From mike@fuhr.org Fri Sep 15 04:55:34 2006 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 99FB99F9F7E for ; Fri, 15 Sep 2006 01:55:34 -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 78805-08 for ; Fri, 15 Sep 2006 04:55:21 +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 44BD49F9F2F for ; Fri, 15 Sep 2006 01:31:28 -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 k8F4VOhi065484 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 14 Sep 2006 22:31:27 -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 k8F4VNBP001993; Thu, 14 Sep 2006 22:31:23 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8F4VNdL001992; Thu, 14 Sep 2006 22:31:23 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 14 Sep 2006 22:31:23 -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: <20060915043123.GA1845@winnie.fuhr.org> References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3005.202.175.123.162.1158292578.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/143 X-Sequence-Number: 23057 On Fri, Sep 15, 2006 at 11:56:18AM +0800, david.lao@sharpasia.com.mo wrote: > su -l postgres -s /bin/sh -c id output: > uid=0(root) gid=26 euid=26(postgres) groups=26 I don't have a Linux box to test but that output isn't what I'd expect, and it's not what I get with the equivalent commands on Solaris and FreeBSD. The above output shows that the real uid and effective uid are different, which is what the postmaster is complaining about. I'd expect them to be the same: both postgres. Can anybody else with a Linux box test the above command? Do you have sudo? If so then what does "sudo -u postgres id" show? If uid and euid are the same (both postgres) then you might be able to start the postmaster with sudo instead of su. > >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. What do you mean by "the hacker"? Do you know or suspect that you've been hacked? If so then I'd recommend that you reinstall your system from trustworthy media, make sure you have current security patches, and close any configuration holes that might have let an intruder in. -- Michael Fuhr From david.lao@sharpasia.com.mo Fri Sep 15 04:50:01 2006 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 5A08D9FA268 for ; Fri, 15 Sep 2006 01:50:01 -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 78781-07 for ; Fri, 15 Sep 2006 04:49:40 +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 809D59FA0FD for ; Fri, 15 Sep 2006 01:49:40 -0300 (ADT) Received: from mailnull by sharpasia.com.mo with FOLIO-Scan (FOLIO Messaging Router) id 1GO5dw-000Bfi-IP; Fri, 15 Sep 2006 12:49:36 +0800 Message-ID: <3865.202.175.123.162.1158295775.mailsage.folio@sharpasia.com.mo> In-Reply-To: <20060915043123.GA1845@winnie.fuhr.org> References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> Date: Fri, 15 Sep 2006 12:49:35 +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.5806 X-FolioEngine-Probability: 0.0000 X-FolioEngine-Signature: 450a30e0448687540917984 Received: from sharpasia.com.mo (localhost.sharpasia.com.mo [127.0.0.1]) by mailrelay.com.mo (FOLIO Messaging Relay) with ESMTP id A38481E3752; Fri, 15 Sep 2006 12:49:33 +0800 (HKT) Received: from 202.175.123.162 by sharpasia.com.mo with HTTP; Fri, 15 Sep 2006 12:49:35 +0800 (HKT) X-Folio-Scanned: by FolioScan Scanner (sharpasia.com.mo:61b6q/KOv25uY) X-Folio-Delivery: 1158295776 (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/167 X-Sequence-Number: 23081 >Do you have sudo? If so then what does "sudo -u postgres id" show? >If uid and euid are the same (both postgres) then you might be able >to start the postmaster with sudo instead of su. "sudo -u postgres id" show uid=0(root) gid=26 euid=26(postgres) groups=26 >What do you mean by "the hacker"? Do you know or suspect that >you've been hacked? If so then I'd recommend that you reinstall >your system from trustworthy media, make sure you have current >security patches, and close any configuration holes that might have >let an intruder in. Yes, I have been hacked, because I found a new unknown a/c in my system. and in log file get this message: Sep 3 22:55:00 TWeb su(pam_unix)[24299]: session opened for user root by (uid=0) Sep 3 22:55:17 TWeb su(pam_unix)[24299]: session closed for user root David From jeff@frostconsultingllc.com Fri Sep 15 05:24:56 2006 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 C035E9FA6B7 for ; Fri, 15 Sep 2006 02:24:56 -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 86419-06 for ; Fri, 15 Sep 2006 05:24:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [64.127.99.90]) by postgresql.org (Postfix) with ESMTP id 17ACB9FB205 for ; Fri, 15 Sep 2006 02:24:42 -0300 (ADT) Received: from adsl-69-226-222-65.dsl.pltn13.pacbell.net ([69.226.222.65]:52188 helo=discord.home.frostconsultingllc.com) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.62) (envelope-from ) id 1GO6Bg-0001he-U5; Thu, 14 Sep 2006 22:24:37 -0700 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.home.frostconsultingllc.com (8.13.7/8.13.7) with ESMTP id k8F5OTLo017574; Thu, 14 Sep 2006 22:24:29 -0700 Date: Thu, 14 Sep 2006 22:24:29 -0700 (PDT) From: Jeff Frost X-X-Sender: jeff@discord.home.frostconsultingllc.com To: Michael Fuhr cc: david.lao@sharpasia.com.mo, Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <20060915043123.GA1845@winnie.fuhr.org> Message-ID: References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-SA-Exim-Connect-IP: 69.226.222.65 X-SA-Exim-Mail-From: jeff@glacier.frostconsultingllc.com Subject: Re: real and effective user ids must match X-SA-Exim-Version: 4.2 (built Tue, 02 May 2006 07:39:18 -0400) X-SA-Exim-Scanned: Yes (on glacier.frostconsultingllc.com) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.951 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200609/144 X-Sequence-Number: 23058 On Thu, 14 Sep 2006, Michael Fuhr wrote: > On Fri, Sep 15, 2006 at 11:56:18AM +0800, david.lao@sharpasia.com.mo wrote: > > I don't have a Linux box to test but that output isn't what I'd > expect, and it's not what I get with the equivalent commands on > Solaris and FreeBSD. The above output shows that the real uid and > effective uid are different, which is what the postmaster is > complaining about. I'd expect them to be the same: both postgres. > Can anybody else with a Linux box test the above command? On my FC4 machine running 2.6.16-1.2111_FC4: uid=26(postgres) gid=26(postgres) groups=26(postgres) context=user_u:system_r:unconfined_t -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From mike@fuhr.org Fri Sep 15 14:30:04 2006 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 6DBAE9FB2E1 for ; Fri, 15 Sep 2006 11:30:04 -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 77201-04 for ; Fri, 15 Sep 2006 11:29:52 -0300 (ADT) 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 B41459FB202 for ; Fri, 15 Sep 2006 11:29:51 -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 k8FETcdQ066234 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 15 Sep 2006 08:29:40 -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 k8FETbcd005230; Fri, 15 Sep 2006 08:29:37 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8FETbbf005229; Fri, 15 Sep 2006 08:29:37 -0600 (MDT) (envelope-from mfuhr) Date: Fri, 15 Sep 2006 08:29:37 -0600 From: Michael Fuhr To: Jeff Frost Cc: david.lao@sharpasia.com.mo, Tom Lane , pgsql-admin@postgresql.org Subject: Re: real and effective user ids must match Message-ID: <20060915142937.GA5150@winnie.fuhr.org> References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.155 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/155 X-Sequence-Number: 23069 On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote: > On Thu, 14 Sep 2006, Michael Fuhr wrote: > >Can anybody else with a Linux box test the above command? > > On my FC4 machine running 2.6.16-1.2111_FC4: > > uid=26(postgres) gid=26(postgres) groups=26(postgres) > context=user_u:system_r:unconfined_t That's what I'd expect. David's box appears to be behaving oddly, which could be signs of tampering if he has indeed been hacked. If that's happened then commands like "ls" and "ps" can't be trusted. Can anybody think of a way for David to be seeing the behavior he's seeing that doesn't involve a tampered-with system? -- Michael Fuhr From jeff@frostconsultingllc.com Fri Sep 15 15:22:03 2006 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 876819FB286 for ; Fri, 15 Sep 2006 12:22:03 -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 81445-08 for ; Fri, 15 Sep 2006 12:21:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [64.127.99.90]) by postgresql.org (Postfix) with ESMTP id 16E5D9FB223 for ; Fri, 15 Sep 2006 12:21:48 -0300 (ADT) Received: from adsl-69-226-222-65.dsl.pltn13.pacbell.net ([69.226.222.65]:41015 helo=discord.home.frostconsultingllc.com) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.62) (envelope-from ) id 1GOFVW-0005Aj-Va; Fri, 15 Sep 2006 08:21:46 -0700 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.home.frostconsultingllc.com (8.13.7/8.13.7) with ESMTP id k8FFLZ6H017783; Fri, 15 Sep 2006 08:21:36 -0700 Date: Fri, 15 Sep 2006 08:21:35 -0700 (PDT) From: Jeff Frost X-X-Sender: jeff@discord.home.frostconsultingllc.com To: Michael Fuhr cc: david.lao@sharpasia.com.mo, Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <20060915142937.GA5150@winnie.fuhr.org> Message-ID: References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> <20060915142937.GA5150@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-SA-Exim-Connect-IP: 69.226.222.65 X-SA-Exim-Mail-From: jeff@glacier.frostconsultingllc.com Subject: Re: real and effective user ids must match X-SA-Exim-Version: 4.2 (built Tue, 02 May 2006 07:39:18 -0400) X-SA-Exim-Scanned: Yes (on glacier.frostconsultingllc.com) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.258 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/157 X-Sequence-Number: 23071 On Fri, 15 Sep 2006, Michael Fuhr wrote: > On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote: >> On Thu, 14 Sep 2006, Michael Fuhr wrote: >>> Can anybody else with a Linux box test the above command? >> >> On my FC4 machine running 2.6.16-1.2111_FC4: >> >> uid=26(postgres) gid=26(postgres) groups=26(postgres) >> context=user_u:system_r:unconfined_t > > That's what I'd expect. David's box appears to be behaving oddly, > which could be signs of tampering if he has indeed been hacked. If > that's happened then commands like "ls" and "ps" can't be trusted. > > Can anybody think of a way for David to be seeing the behavior he's > seeing that doesn't involve a tampered-with system? It's probably worthwhile to get a copy of chkrootkit and/or rkhunter and run them to see if there is a problem. Might also be worthwhile to run the ps and ls from the install CD to see if there are any suprising results. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From david.lao@sharpasia.com.mo Sat Sep 16 01:25:21 2006 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 58E2F9FA195 for ; Fri, 15 Sep 2006 22:25:21 -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 05565-03 for ; Fri, 15 Sep 2006 22:25:17 -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 783A19FA2D4 for ; Fri, 15 Sep 2006 22:25:16 -0300 (ADT) Received: from mailnull by sharpasia.com.mo with FOLIO-Scan (FOLIO Messaging Router) id 1GOOvf-00082m-4c; Sat, 16 Sep 2006 09:25:11 +0800 Message-ID: <3511.202.175.123.162.1158369909.mailsage.folio@sharpasia.com.mo> In-Reply-To: References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> <20060915142937.GA5150@winnie.fuhr.org> Date: Sat, 16 Sep 2006 09:25:09 +0800 (HKT) Subject: Re: real and effective user ids must match From: david.lao@sharpasia.com.mo To: Jeff Frost , Michael Fuhr Cc: david.lao@sharpasia.com.mo, 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: Spam X-FolioEngine-Confidence: 0.4856 X-FolioEngine-Probability: 1.0000 X-FolioEngine-Signature: 450b5276309195196536231 X-FolioEngine-User: mailnull Received: from sharpasia.com.mo (localhost.sharpasia.com.mo [127.0.0.1]) by mailrelay.com.mo (FOLIO Messaging Relay) with ESMTP id A26BB1E38D9; Sat, 16 Sep 2006 09:25:08 +0800 (HKT) Received: from 202.175.123.162 by sharpasia.com.mo with HTTP; Sat, 16 Sep 2006 09:25:09 +0800 (HKT) X-Folio-Scanned: by FolioScan Scanner (sharpasia.com.mo:29v9PVb.HaBaY) X-Folio-Delivery: 1158369910 (10cc6c014fa2a4dc7fb7b2b7bf48103c) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.051 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, MSGID_FROM_MTA_HEADER, NO_REAL_NAME, UNPARSEABLE_RELAY X-Spam-Level: ** X-Archive-Number: 200609/168 X-Sequence-Number: 23082 is there any way to correct this problem? please help. On Fri, 15 Sep 2006, Michael Fuhr wrote: > On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote: >> On Thu, 14 Sep 2006, Michael Fuhr wrote: >>> Can anybody else with a Linux box test the above command? >> >> On my FC4 machine running 2.6.16-1.2111_FC4: >> >> uid=26(postgres) gid=26(postgres) groups=26(postgres) >> context=user_u:system_r:unconfined_t > > That's what I'd expect. David's box appears to be behaving oddly, > which could be signs of tampering if he has indeed been hacked. If > that's happened then commands like "ls" and "ps" can't be trusted. > > Can anybody think of a way for David to be seeing the behavior he's > seeing that doesn't involve a tampered-with system? It's probably worthwhile to get a copy of chkrootkit and/or rkhunter and run them to see if there is a problem. Might also be worthwhile to run the ps and ls from the install CD to see if there are any suprising results. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From jeff@frostconsultingllc.com Sat Sep 16 01:28:05 2006 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 CD4A39FA2D4 for ; Fri, 15 Sep 2006 22:28:05 -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 23868-06 for ; Sat, 16 Sep 2006 01:27:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [64.127.99.90]) by postgresql.org (Postfix) with ESMTP id A572E9FA195 for ; Fri, 15 Sep 2006 22:27:56 -0300 (ADT) Received: from adsl-69-226-222-65.dsl.pltn13.pacbell.net ([69.226.222.65]:57524 helo=discord.home.frostconsultingllc.com) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.62) (envelope-from ) id 1GOOyC-0007KC-Ae; Fri, 15 Sep 2006 18:27:54 -0700 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.home.frostconsultingllc.com (8.13.7/8.13.7) with ESMTP id k8G1Roo4009954; Fri, 15 Sep 2006 18:27:50 -0700 Date: Fri, 15 Sep 2006 18:27:50 -0700 (PDT) From: Jeff Frost X-X-Sender: jeff@discord.home.frostconsultingllc.com To: david.lao@sharpasia.com.mo cc: Michael Fuhr , Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <3511.202.175.123.162.1158369909.mailsage.folio@sharpasia.com.mo> Message-ID: References: <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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> <20060915142937.GA5150@winnie.fuhr.org> <3511.202.175.123.162.1158369909.mailsage.folio@sharpasia.com.mo> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-SA-Exim-Connect-IP: 69.226.222.65 X-SA-Exim-Mail-From: jeff@glacier.frostconsultingllc.com Subject: Re: real and effective user ids must match X-SA-Exim-Version: 4.2 (built Tue, 02 May 2006 07:39:18 -0400) X-SA-Exim-Scanned: Yes (on glacier.frostconsultingllc.com) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/162 X-Sequence-Number: 23076 Did you get a copy of chkrootkit and/or rkhunter and run them on this machine? If so, let us know if it find a rootkit. If so, that's your problem. I think you may have to ask on one of the linux system administration lists. Which linux distribution and version did you indicate this is again? On Sat, 16 Sep 2006, david.lao@sharpasia.com.mo wrote: > > is there any way to correct this problem? please help. > > On Fri, 15 Sep 2006, Michael Fuhr wrote: > >> On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote: >>> On Thu, 14 Sep 2006, Michael Fuhr wrote: >>>> Can anybody else with a Linux box test the above command? >>> >>> On my FC4 machine running 2.6.16-1.2111_FC4: >>> >>> uid=26(postgres) gid=26(postgres) groups=26(postgres) >>> context=user_u:system_r:unconfined_t >> >> That's what I'd expect. David's box appears to be behaving oddly, >> which could be signs of tampering if he has indeed been hacked. If >> that's happened then commands like "ls" and "ps" can't be trusted. >> >> Can anybody think of a way for David to be seeing the behavior he's >> seeing that doesn't involve a tampered-with system? > > It's probably worthwhile to get a copy of chkrootkit and/or rkhunter and run > them to see if there is a problem. Might also be worthwhile to run the ps and > ls from the install CD to see if there are any suprising results. > > -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From mike@fuhr.org Sun Sep 17 18:39:07 2006 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 20D319FA4A7 for ; Sun, 17 Sep 2006 15:39: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 39563-06 for ; Sun, 17 Sep 2006 18:39:03 +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 50A909FA47B for ; Sun, 17 Sep 2006 15:39:03 -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 k8HIcmVV069311 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 17 Sep 2006 12:38:50 -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 k8HIcluM008350; Sun, 17 Sep 2006 12:38:47 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id k8HIcl9G008349; Sun, 17 Sep 2006 12:38:47 -0600 (MDT) (envelope-from mfuhr) Date: Sun, 17 Sep 2006 12:38:47 -0600 From: Michael Fuhr To: david.lao@sharpasia.com.mo Cc: Jeff Frost , Tom Lane , pgsql-admin@postgresql.org Subject: Re: real and effective user ids must match Message-ID: <20060917183847.GA8240@winnie.fuhr.org> References: <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo> <20060915033750.GA1374@winnie.fuhr.org> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org> <20060915142937.GA5150@winnie.fuhr.org> <3511.202.175.123.162.1158369909.mailsage.folio@sharpasia.com.mo> <50012.202.86.138.90.1158516574.mailsage.folio@sharpasia.com.mo> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <50012.202.86.138.90.1158516574.mailsage.folio@sharpasia.com.mo> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200609/171 X-Sequence-Number: 23085 On Mon, Sep 18, 2006 at 02:09:34AM +0800, david.lao@sharpasia.com.mo wrote: > it find SHV4 and SHV5 rootkit, is there any way to easy and fast move > db to new system, I am using Redhat 8.0 If the new system has the same major release of PostgreSQL as the infected system then you could copy the $PGDATA directory from the infected system to the new one. Be careful how you communicate between the two systems or you could end up infecting the new system. -- Michael Fuhr