| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | david(dot)lao(at)sharpasia(dot)com(dot)mo |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: real and effective user ids must match |
| Date: | 2006-09-15 00:49:24 |
| Message-ID: | 20060915004924.GA32408@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Sep 14, 2006 at 11:13:43PM +0800, david(dot)lao(at)sharpasia(dot)com(dot)mo wrote:
> I starting my postgres with standard startup script /etc/rc.d/init.d/postgressql
I didn't notice anything wrong with the script you posted. What
happens if you run the "su" command that starts the postmaster
directly from the command line? That is, the "su" on line 151
(you'll have to set the PGDATA environment variable or replace it
with the path to your data directory):
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start
What's the output of the following command?
ls -l /bin/sh /usr/bin/pg_ctl /usr/bin/postmaster /usr/bin/postgres
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | david.lao | 2006-09-15 01:20:28 | Re: real and effective user ids must match |
| Previous Message | Tom Lane | 2006-09-14 23:50:58 | Re: [ADMIN] Vacuum error on database postgres |