pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: david.lao@sharpasia.com.mo
To: Michael Fuhr <mike@fuhr.org>
To: david.lao@sharpasia.com.mo
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: real and effective user ids must match
Date: Fri, 15 Sep 2006 11:56:18 +0800 (HKT)
Message-ID: <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> (raw)
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>

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





view thread (19+ messages)  latest in thread

Message-ID: <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo>
Permalink:  ../3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo/
Also on:    postgresql.org/message-id/3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: david.lao@sharpasia.com.mo, mike@fuhr.org, tgl@sss.pgh.pa.us
  Subject: Re: real and effective user ids must match
  In-Reply-To: <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo>
  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> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox