From: Tom Lane <tgl@sss.pgh.pa.us>
To: "alexander al (leiden)" <alexander@scred.nl>
cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Building and installing pg_proctab
In-reply-to: <437545deb5676b1fea07fcd2c94cd9b2fc503df6.camel@scred.nl>
References: <74911db1cbeed5636c8f36c565c5d4c9c30342d0.camel@scred.nl>
 <b952c2b1-8f91-468b-8105-b0c18774e2e2@ewie.name>
 <437545deb5676b1fea07fcd2c94cd9b2fc503df6.camel@scred.nl>
Comments: In-reply-to "alexander al (leiden)" <alexander@scred.nl>
	message dated "Sat, 24 Jan 2026 13:17:55 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3257412.1769270598.1@sss.pgh.pa.us>
Date: Sat, 24 Jan 2026 11:03:18 -0500
Message-ID: <3257413.1769270598@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3257413.1769270598%40sss.pgh.pa.us>
Precedence: bulk

"alexander al (leiden)" <alexander@scred.nl> writes:
> On Tue, 2026-01-20 at 11:28 +0100, Erik Wienhold wrote:
>> Judging by the Makefile logic, I think you need to set USE_PGXS=1.

> 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 ;)

If you normally get Postgres via a packaging system: most distros
offer an add-on package that includes our .h files and other stuff
needed to compile dependent code, typically named something like
postgresql-dev or postgresql-devel.  Installing that would've saved
you some effort.

			regards, tom lane