Am Montag, 26. Juni 2006 22:15 schrieb Tom Lane: > mack@xxxxxxxxxxxxxxxx writes: > > I don't have a pg_stat_activity on this 7.4.6, so using ps gives me: > > > > postgres@is20 ~ 4 > ps -ef | grep postmaster > > postgres 4499 4498 0 08:59:18 ? 0:04 > > /usr/local/pgsql/bin/postmaster -i -p 5356 -o -e > > What platform is that? If it's Solaris, see our doc/FAQ_Solaris about > getting more useful info from "ps". > Yes, it's Solaris 10. Looking at http://www.postgresql.org/docs/faqs.FAQ_Solaris.html , I did not find anything related. Same with the doc/FAQ_Solaris from the postgresql-8.1.4 sources. ... Ok, I tried on a Linux server with 8.0.0, where I could get some useful informations out of ps. I tried /usr/ucb/ps on Solaris, which revealed more information, but I did not see a test query from a remote client for some magic reason (select * from t1, t2 with 250,000 and 512,000 rows). I think, I can live with it for now, as I will upgrade later this year. Thanks, Thomas Mack TU Braunschweig, Institut für Informationssysteme
