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, [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match