Remote mode does not work. Stored function 'pg_cputime' is missing.
Closed this issue · 3 comments
Sammers21 commented
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 commented
The pg_proctab extension needs to be loaded into the database you are connecting too. That can be installed from pgxn or source.