Message-ID: <437545deb5676b1fea07fcd2c94cd9b2fc503df6.camel@scred.nl>
Subject: Re: Building and installing pg_proctab
From: "alexander al (leiden)" <alexander@scred.nl>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Sat, 24 Jan 2026 13:17:55 +0100
In-Reply-To: <b952c2b1-8f91-468b-8105-b0c18774e2e2@ewie.name>
References: <74911db1cbeed5636c8f36c565c5d4c9c30342d0.camel@scred.nl>
	 <b952c2b1-8f91-468b-8105-b0c18774e2e2@ewie.name>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3-0ubuntu1.1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/437545deb5676b1fea07fcd2c94cd9b2fc503df6.camel%40scred.nl>
Precedence: bulk

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.
> >=20
> > i downloaded it from
> >=20
> > https://gitlab.com/pg_proctab/pg_proctab/
> >=20
> > and i tried to make it.
> >=20
> > the docs says
> >=20
> > make
> > make install
> > etc.
> >=20
> > but when i do make in the root of pg_proctab i get the error
> >=20
> > "Makefile:29: /contrib/contrib-global.mk: No such file or directory
> > make: *** No rule to make target '/contrib/contrib-global.mk'.=C2=A0
> > Stop."
>=20
> Judging by the Makefile logic, I think you need to set USE_PGXS=3D1.
> Without that, the Makefile expects the code to be under Postgres'
> contrib tree.
>=20

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