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:13:06 +0800 (HKT)
Message-ID: <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo> (raw)
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>

Hi,

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 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





view thread (19+ messages)  latest in thread

Message-ID: <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo>
Permalink:  ../2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo/
Also on:    postgresql.org/message-id/2411.202.175.123.162.1158289986.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: <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>

* 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