CREATE EXTENSION tablefunc returns tablefunc.control": No such file or directory

[J3throSanidad]

Hello,

We already try the following but still the same

yum install postgresql-contrib

psql omdfs_dw

omdfs_dw=# CREATE EXTENSION tablefunc; ERROR: could not open extension control file "/usr/local/greenplum-db-6.7.1/share/postgresql/extension/tablefunc.control": No such file or directory

I also tried to download the postgres-master.zip and try to install the tablefunc but I have also errors:

export PATH="/usr/local/greenplum-db-6.7.1/bin:$PATH" export USE_PGXS=1

cd /data/postgres-master/postgres-master/contrib/tablefunc

[gpadmin@gbpi-fmstr-uat-danalytics-01 tablefunc]$ make gcc -m64 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fno-aggressive-loop-optimizations -Wno-unused-but-set-variable -Wno-address -m64 -O3 -fargument-noalias-global -fno-omit-frame-pointer -g -std=gnu99 -Werror=uninitialized -Werror=implicit-function-declaration -fPIC -I. -I./ -I/usr/local/greenplum-db-6.7.1/include/postgresql/server -I/usr/local/greenplum-db-6.7.1/include/postgresql/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/tmp/build/f8c7ee08/gpdb_src/gpAux/ext/rhel7_x86_64/include -c -o tablefunc.o tablefunc.c tablefunc.c:39:28: fatal error: common/pg_prng.h: No such file or directory

include "common/pg_prng.h"

                        ^

compilation terminated. make: *** [tablefunc.o] Error 1

[expaso]

Ehm.. are you sure that this is about the Home Assistant Timescale Addon?

I don't see any link to my addon anywhere in your request.

If so, please reopen this issue.