Re: Building and installing pg_proctab

On Tue, 2026-01-20 at 11:28 +0100, Erik Wienhold wrote:
> On 2026-01-20 11:01 +0100, alexander al (leiden) wrote:
> > picture:
> > i've got ubuntu 24.04 with postgresql 18 on it. Now I want to
> > install
> > pg_proctab on it for monitoring reasons.
> >
> > i downloaded it from
> >
> > https://gitlab.com/pg_proctab/pg_proctab/
> >
> > and i tried to make it.
> >
> > the docs says
> >
> > make
> > make install
> > etc.
> >
> > but when i do make in the root of pg_proctab i get the error
> >
> > "Makefile:29: /contrib/contrib-global.mk: No such file or directory
> > make: *** No rule to make target '/contrib/contrib-global.mk'. 
> > Stop."
>
> Judging by the Makefile logic, I think you need to set USE_PGXS=1.
> Without that, the Makefile expects the code to be under Postgres'
> contrib tree.
>

Yes, that was true, but than you have to feed the .h files, and those
are only available when you compile postgresql itself. So I pulled
postgresql 18.1 source, installed too much packages and compiled PG.
After this I could compile pg_proctab. Oh well, lessons learned ;)

regards,

alexander