mack(at)ifis(dot)cs(dot)tu-bs(dot)de writes:
> I don't have a pg_stat_activity on this 7.4.6, so using ps gives me:
> postgres(at)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".
regards, tom lane