Re: [HACKERS] Re: pgmonitor and Solaris

Thanks, I think this summarizes Solaris ps display.  We will try to get
7.1 ps display working for Solaris.


> On Wed, Mar 28, 2001 at 07:18:24PM -0500, Bruce Momjian allegedly wrote:
> > > > > Note the last line...
> > > >
> > > > OK, I need someone on Solaris to test ps and /ucb/ps with regard to user
> > > > restriction inside ps, and display of PostgreSQL status display.
> > > >
> > > > I have uploaded a new pgmonitor 0.33 version that has a show_all
> > > > configuration parameter.  This will show all PostgreSQL-owned processes
> > > > for use on operating systems that don't have PostgreSQL status display.
> > >
> > > We don't have Tcl/Tk installed on any of our servers, so I can't test
> > > this. If you want me to test something else, please let me know.
> >
> > I don't need tcl/tk, just someone to run ps and ucb/ps with running
> > backends and tell me if the backend status display is working, and which
> > ps has user-selection capability.
>
> Here goes:
>
> template1=# \set
> VERSION = 'PostgreSQL 7.0.3 on sparc-sun-solaris2.7, compiled by gcc 2.95.2'
> DBNAME = 'template1'
> USER = 'mathijs'
> PORT = '5432'
> ENCODING = 'SQL_ASCII'
> PROMPT1 = '%/%R%# '
> PROMPT2 = '%/%R%# '
> PROMPT3 = '>> '
> HISTSIZE = '500'
> template1=#
> [1]+  Stopped                 psql template1
> jumpstart.l3.ilse.nl:/export/home/mathijs >which ps
> /usr/bin/ps
> jumpstart.l3.ilse.nl:/export/home/mathijs >ps -elf|grep post
>  8 S  mathijs 25810 25808  0  51 20 7156ca68    717 71c789d2 20:44:34 pts/1    0:00 /opt/pgsql/bin/./postmaster
>  8 O  mathijs  1576  1543  0  51 20 71733548    118          02:26:23 pts/3    0:00 grep post
>  8 S  mathijs  1555 25810  0  51 20 71e48760    765 716fdc86 02:26:00 pts/1    0:00 /opt/pgsql/bin/./postmaster
> jumpstart.l3.ilse.nl:/export/home/mathijs >ps -o args,comm|grep post
> grep post                                                                        grep
> jumpstart.l3.ilse.nl:/export/home/mathijs >ps -ef -o args,comm|grep post
> /opt/pgsql/bin/./postmaster                                                      /opt/pgsql/bin/./postmaster
> grep post                                                                        grep
> /opt/pgsql/bin/./postmaster                                                      /opt/pgsql/bin/./postmaster
> jumpstart.l3.ilse.nl:/export/home/mathijs >ps -ef -o user,pid,args,comm|grep post
>  mathijs 25810 /opt/pgsql/bin/./postmaster
/opt/pgsql/bin/./postmaster
>  mathijs  1555 /opt/pgsql/bin/./postmaster
/opt/pgsql/bin/./postmaster
>  mathijs  1604 grep post                                                                        grep
> jumpstart.l3.ilse.nl:/export/home/mathijs >/usr/ucb/ps auxww|grep post
> mathijs   1619  0.1  0.1  944  696 pts/3    S 02:27:16  0:00 grep post
> mathijs   1555  0.0  0.2 6120 3352 pts/1    S 02:26:00  0:00 /opt/pgsql/bin/./postgres mathijs localhost template1
idle
> mathijs  25810  0.0  0.1 5736 2160 pts/1    S 20:44:34  0:00 /opt/pgsql/bin/./postmaster
>
> jumpstart.l3.ilse.nl:/export/home/mathijs >/usr/ucb/ps -h
> /usr/ucb/ps: illegal option -- h
> usage: ps [ -aceglnrSuUvwx ] [ -t term ] [ num ]
> jumpstart.l3.ilse.nl:/export/home/mathijs >id
> uid=106(mathijs) gid=110(ilse)
> jumpstart.l3.ilse.nl:/export/home/mathijs >/usr/ucb/ps -U 106
> ps: rename("/tmp/ps.NHayod","/tmp/ups_data") failed, Permission denied
> ps: Please notify your System Administrator
> jumpstart.l3.ilse.nl:/export/home/mathijs >ps -fU mathijs
>      UID   PID  PPID  C    STIME TTY      TIME CMD
>  mathijs   429   408  0 16:58:40 pts/1    0:01 -bash
>  mathijs 17121 17095  0 20:01:11 pts/0    0:01 -bash
>  mathijs  1543  1520  0 02:25:48 pts/3    0:00 -bash
>  mathijs 25810 25808  0 20:44:34 pts/1    0:00 /opt/pgsql/bin/./postmaster
>  mathijs 19058 18962  0 21:53:38 ?        0:00 ../bin/httpd -
>     root  1773  1543  0 02:30:18 pts/3    0:00 ps -fU mathijs
>  mathijs  1554  1543  0 02:25:58 pts/3    0:00 psql template1
>  mathijs 19057 18962  0 21:53:38 ?        0:00 ../bin/httpd -
>  mathijs  1555 25810  0 02:26:00 pts/1    0:00 /opt/pgsql/bin/./postmaster
>  mathijs 19056 18962  0 21:53:38 ?        0:00 ../bin/httpd -
>  mathijs 25808     1  0 20:44:34 pts/1    0:00 /bin/sh ./pg_ctl -D /opt/pgsql/data start
>  mathijs 19059 18962  0 21:53:38 ?        0:00 ../bin/httpd -
>  mathijs 19060 18962  0 21:53:38 ?        0:00 ../bin/httpd -
>  mathijs 18962     1  0 21:51:55 ?        0:00 ../bin/httpd -
>
> Btw. I don't know what 'ps -U' does, but it sure isn't what you'd
> expect. What it appears to be doing is caching some data in /tmp,
> probably to speed up future lookups (most likely kernel symbols
> (WCHAN) and tty names). ps -U seems to update this file.
>
> I did some more checking. /usr/ucb/ps actually acquires read access
> to the memory space of running programs and seems to get the program
> title from it, while the regular sysv ps command only accesses the
> normal process information (containing the real cmdline arguments).
> You either need root access to read from a program's memory space
> (using the /proc/<pid>/as pseudo file), or you need to be the owner.
>
> jumpstart.l3.ilse.nl:/export/home/mathijs >ls -l /proc/1555/as /proc/1555/psinfo
> -rw-------   1 mathijs  ilse     6266880 Mar 29 02:26 /proc/1555/as
> -r--r--r--   1 mathijs  ilse         336 Mar 29 02:26 /proc/1555/psinfo
>
> /usr/ucb/ps reads both as and psinfo, while the regular ps only reads
> psinfo...
>
> I think grepping the /usr/ucb/ps output is pretty much the only option
> left, since it doesn't allow you to limit on user name/id.
>
> Regards,
>
> Mathijs
> --
> ilse Technology B.V. - Postbus 542 5600 AM Eindhoven
> Telefoon: 040 750 31 00 - Fax: 040 750 31 99
> Web: http://www.ilse.nl/ - E-mail: technology@ilse.nl
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026