public inbox for [email protected]  
help / color / mirror / Atom feed
Building and installing pg_proctab
4+ messages / 3 participants
[nested] [flat]

* Building and installing pg_proctab
@ 2026-01-20 10:01 alexander al (leiden) <[email protected]>
  2026-01-20 10:28 ` Re: Building and installing pg_proctab Erik Wienhold <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: alexander al (leiden) @ 2026-01-20 10:01 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

Hello,

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."

so i'm stuck now. 

cant find a thing on the big internet and even ai isnt very helpfull.

is there someone who can point me in the right directory?

best regards,

alexander al.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Building and installing pg_proctab
  2026-01-20 10:01 Building and installing pg_proctab alexander al (leiden) <[email protected]>
@ 2026-01-20 10:28 ` Erik Wienhold <[email protected]>
  2026-01-24 12:17   ` Re: Building and installing pg_proctab alexander al (leiden) <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Erik Wienhold @ 2026-01-20 10:28 UTC (permalink / raw)
  To: alexander al (leiden) <[email protected]>; +Cc: Pgsql-admin <[email protected]>

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.

-- 
Erik Wienhold





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Building and installing pg_proctab
  2026-01-20 10:01 Building and installing pg_proctab alexander al (leiden) <[email protected]>
  2026-01-20 10:28 ` Re: Building and installing pg_proctab Erik Wienhold <[email protected]>
@ 2026-01-24 12:17   ` alexander al (leiden) <[email protected]>
  2026-01-24 16:03     ` Re: Building and installing pg_proctab Tom Lane <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: alexander al (leiden) @ 2026-01-24 12:17 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Building and installing pg_proctab
  2026-01-20 10:01 Building and installing pg_proctab alexander al (leiden) <[email protected]>
  2026-01-20 10:28 ` Re: Building and installing pg_proctab Erik Wienhold <[email protected]>
  2026-01-24 12:17   ` Re: Building and installing pg_proctab alexander al (leiden) <[email protected]>
@ 2026-01-24 16:03     ` Tom Lane <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2026-01-24 16:03 UTC (permalink / raw)
  To: alexander al (leiden) <[email protected]>; +Cc: Pgsql-admin <[email protected]>

"alexander al (leiden)" <[email protected]> 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






^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2026-01-24 16:03 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-01-20 10:01 Building and installing pg_proctab alexander al (leiden) <[email protected]>
2026-01-20 10:28 ` Erik Wienhold <[email protected]>
2026-01-24 12:17   ` alexander al (leiden) <[email protected]>
2026-01-24 16:03     ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox