| Lists: | pgsql-bugs |
|---|
| From: | "Armin Jenewein" <jenewein(at)googlemail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4875: /etc/init.d/postgresql status shows postmaster is stopped when executed as user |
| Date: | 2009-06-23 15:06:15 |
| Message-ID: | 200906231506.n5NF6Fth016382@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4875
Logged by: Armin Jenewein
Email address: jenewein(at)googlemail(dot)com
PostgreSQL version: 8.1.11
Operating system: CentOS 5.3
Description: /etc/init.d/postgresql status shows postmaster is
stopped when executed as user
Details:
When i run "/etc/init.d/postgresql status" as a non-root user, it shows
"postmaster is stopped" while it actually is running. If i run it as root it
reports correctly.
I was able to reproduce this on several CentOS 5.3 machines. The exactly
same init script with the same postgres version (8.1.11) on CentOS 4.4 makes
no problems at all. Also, i wasn't able to reproduce this on any
Debian/Ubuntu machine.
Tho i don't think a user should play around with init scripts, the output
should NEVER lie to a user, be it a root user or not.
Yours sincerely,
Armin Jenewein
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Armin Jenewein" <jenewein(at)googlemail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4875: /etc/init.d/postgresql status shows postmaster is stopped when executed as user |
| Date: | 2009-06-28 04:32:33 |
| Message-ID: | 27896.1246163553@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Armin Jenewein" <jenewein(at)googlemail(dot)com> writes:
> When i run "/etc/init.d/postgresql status" as a non-root user, it shows
> "postmaster is stopped" while it actually is running. If i run it as root it
> reports correctly.
AFAICS this just depends on "pidof postmaster". Perhaps you should be
filing a bug against pidof.
regards, tom lane
| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Armin Jenewein <jenewein(at)googlemail(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4875: /etc/init.d/postgresql status shows postmaster is stopped when executed as user |
| Date: | 2009-06-29 11:08:00 |
| Message-ID: | 1246273680.11346.12.camel@ayaki |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Sun, 2009-06-28 at 00:32 -0400, Tom Lane wrote:
> "Armin Jenewein" <jenewein(at)googlemail(dot)com> writes:
> > When i run "/etc/init.d/postgresql status" as a non-root user, it shows
> > "postmaster is stopped" while it actually is running. If i run it as root it
> > reports correctly.
>
> AFAICS this just depends on "pidof postmaster". Perhaps you should be
> filing a bug against pidof.
First, though, make sure that SELinux isn't hiding the `postmaster'
process from your normal users. Make sure you can actually see it with
`ps aux' or `ps -ef' .
--
Craig Ringer