I believe I have found the cause of the pgmonitor problem on Solaris.
pgmonitor assumes you have a working 'ps' status display, which shows
user/database/connection, and query type. I have learned from a Great
Bridge employee that his Solaris box is not updating the ps display for
7.1beta, and I assume the same trouble exists for 7.0.3.
Can someone confirm that 'ps' status display doesn't work on Solaris,
and if it doesn't, can someone come up with a fix that we can put into
7.1.1? You can look in /pg/backend/utils/misc/ps_status.c for all the
ps status code. It has many options for ps status updating.
Thanks.
--
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