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