Re: top for postgresql (ptop?)

Mark Wong wrote:
> On 9/25/07, Satoshi Nagayasu <nagayasus@nttdata.co.jp> wrote:
>> Mark,
>>
>> Very interesting. I'm looking for such tool.
>>
>> Unfortunately, I can't compile it on my Solaris right now,
>> but I hope it will be shipped with PostgreSQL distribution.
> 
> I haven't tried it on Solaris but I'm not surprised.  If I can get my
> hands on a Solaris system I can probably get it to work. :)  The code
> for getting the process information is platform specific and I know
> I've broken it for all the platforms I haven't tried it on...

Mark,

I tested it on Solaris and I found two problems there. One is with 
configure. It does not correctly handled CPPFLAGS. Generated makefile 
ignore path to the include files. This line is wrong:

# explicit dependency for the module appropriate to this machine
m_sunos5.o: $(srcdir)/machine/m_sunos5.c$(COMPILE) -o $@ -c $(srcdir)/machine/m_sunos5.c

Second issue is with new interface of get_process_info function. 
Currently it has 4 arguments but in m_sunos5.c is defined only with 3 
arguments.

Last issue is with -m64 switch. Solaris pg installation does not have 
64bit libpg (will be soon) and linker is not able put everything together.

    Zdenek