pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: 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: Thu, 14 Sep 2006 21:37:51 -0600
Message-ID: <20060915033750.GA1374@winnie.fuhr.org> (raw)
In-Reply-To: <2411.202.175.123.162.1158289986.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>

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 <su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start> 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



view thread (19+ messages)  latest in thread

Message-ID: <20060915033750.GA1374@winnie.fuhr.org>
Permalink:  ../20060915033750.GA1374@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20060915033750.GA1374@winnie.fuhr.org

 · 

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: mike@fuhr.org, david.lao@sharpasia.com.mo, tgl@sss.pgh.pa.us
  Subject: Re: real and effective user ids must match
  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>

* 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