Re: Building and installing pg_proctab

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "alexander al (leiden)" <alexander(at)scred(dot)nl>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Building and installing pg_proctab
Date: 2026-01-24 16:03:18
Message-ID: 3257413.1769270598@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"alexander al (leiden)" <alexander(at)scred(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Олег Самойлов 2026-01-26 05:31:24 autoanalyze did not run
Previous Message alexander al (leiden) 2026-01-24 12:17:55 Re: Building and installing pg_proctab