Re: pidof not working for postgresql-8.3 ?

[Ennio-Sr <nasr(dot)laili(at)tin(dot)it>]

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [280208, 23:24]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> > Besides that I just found out that 'pidof' doen't seem to work for the
> > ordinary user, as far as postgresql is concerned, whereas it works
> > regularly for other processes:
> [...] 
> > Is this a normal behaviour for the new pg_8.3?
> 
> I am not familiar with pidof (doesn't exist on any of my boxen)
> but maybe it is looking at real executable names rather than
> symlinks?  Try looking for "postgres" instead of "postmaster".
> 
> 			regards, tom lane

Hmm... I'm unlucky you don't use pidof. It's part of the Debian/PowerPC
GNU/Linux 'sysvinit-utils' package and I've been using it since I
learned the essentials of postgres. I call that command in a script just
to make sure postgresql is running before starting some other scripts
which use pg. And it still works nicely on my desktop PC (using PG_7.4).

Back to my iBook and PG_8.3 the results I get are quite intriguing (here
are a few examples, but full results are available on request):

user$ pidof  /usr/lib/postgresql/8.3/bin/postgres
2524 2523 2522 2521 2518

user$ pidof  /usr/lib/postgresql/8.3/bin/postmaster
[nihil]

but, doing the same as root, the result is positive for both (postgres
and postmaster)

On the other hand, this is what happens on my desktop PC, running pg_7.4
under Debian/Etch:

user$ pidof /usr/lib/postgresql/bin/postmaster
5652 5651

user$ pidof /usr/lib/postgresql/bin/postgres   # same as root
[nihil]

user$ pidof /usr/lib/postgresql/7,4/bin/postmaster
5652 5651                        =

user$ pidof /usr/lib/postgresql/7.4/bin/postmaster # same as root
5652 5651 5648

user$ pidof /usr/lib/postgresql/7.4/bin/postgres  # positive if root
[nihil]

-------

Perhaps it depends on the sysvinit-utils version being used with the
desktop (2.86.ds1-38) and iBook (2.86.ds1-53), which I couldn't check as
the downgrading threathened to remove some essential packages and I
didn't feel like running any risk at the moment; but I would
be grateful if anybody familiar with pidof could confirm.

Anyway, thank you Tom, for your time and could you suggest a different
command (to be put in a script) aiming at the same goal?

Regards,
	Ennio

-- 
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]