markwkm/pg_top

Remote mode does not work. Stored function 'pg_cputime' is missing.

Closed this issue · 3 comments

Problem

I'm trying to connect to a PostgreSQL located in a docker container using remote mode

$ pg_top -r -h localhost -p 5432 -U postgres -W
Password: 
Stored function 'pg_cputime' is missing.

Version

$ pg_top --version
pg_top 3.7.0

$ select version();
PostgreSQL 9.6.14 on x86_64-pc-linux-gnu (Debian 9.6.14-1.pgdg90+1), compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 2
0170516, 64-bit

@markwkm , is PostgreSQL 9.6.14 compatible with remote mode?

The pg_proctab extension needs to be loaded into the database you are connecting too. That can be installed from pgxn or source.

@markwkm, thank you