Re: [HACKERS] removing the exec() from doexec()

From: Brett McCormick <brett(at)work(dot)chicken(dot)org>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] removing the exec() from doexec()
Date: 1998-04-30 02:36:31
Message-ID: 13639.57844.621418.82881@abraxas.scene.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


sure enough.. well, try this on your OS and you can find out if perl
knows how to change it. it doesn't work under solaris. the args to
ps might be different for your system.

perl -e '$0 = "it_works!";system "ps -p $$"'

However, the args to the processes are so different that it seems easy
to tell the difference.. if you're a human. computers might have
more trouble. I've been known to use "killall postgres" (yes, I know,
I'm bad!!)

I only do it so that I can restart the postmaster. Our webserver is
pretty much continually connected, and when it deadlocks, all the
clients queue up. It would be nice to have a set of commands to show
you all connections, the machine/remote port they're from (for
identd), the username/dbname they're connected as, when they
connected, idle time, etc. like "finger" for postgres.

I'm willing to work on it, if someone can point me in the right
direction. (First things first though)

On Wed, 29 April 1998, at 23:20:52, The Hermit Hacker wrote:

>
> Under FreeBSD, there is:
>
> setproctitle(3) - set the process title for ps 1
>
> This isn't available under Solaris though, last I checked...
>
> Marc G. Fournier
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-04-30 02:42:39 Re: [HACKERS] removing the exec() from doexec()
Previous Message Brett McCormick 1998-04-30 02:27:09 data compression/encryption