I've attempted to install timescaledb on Ubuntu 18.04 (32bit) with Postgresql 12 using: https://docs.timescale.com/latest/getting-started/installation/ubuntu/installation-apt-ubuntu
When I run sudo apt install timescaledb-2-postgresql-12 I get the error:
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package timescaledb-2-postgresql-12
I then tried to go through and build the code locally (from the repository https://github.com/timescale/timescaledb) which was successful (on the make) but I was not able to see the "next steps" for what to do after the build. When I attempt to add the extension in the postgres.conf file by adding "shared_preload_libraries = 'timescaledb' " then restarting. On the restart I get the error
2021-02-22 07:24:28.711 EST [18311] syorke@postgres ERROR: could not open extension control file "/usr/share/postgresql/12/extension/timescaledb.control": No such file or directory
In the timescaledb.control is:
# timescaledb extension
comment = 'Enables scalable inserts and complex queries for time-series data'
default_version = '2.0.1'
module_pathname = '$libdir/timescaledb-2.0.1'
#extension cannot be relocatable once installed because it uses multiple schemas and that is forbidden by PG.
#(though this extension is relocatable during installation).
relocatable = false
My question is am I going about this correctly where the package was not found? Should I replace the /usr/share/postgresql/12/extension/timescaledb.control with the timescaledb.control.in in the directory where I did my build for timescaledb?
In that control file from the build is:
# timescaledb extension
comment = 'Enables scalable inserts and complex queries for time-series data'
default_version = '@PROJECT_VERSION_MOD@'
module_pathname = '$libdir/timescaledb-@PROJECT_VERSION_MOD@'
#extension cannot be relocatable once installed because it uses multiple schemas and that is forbidden by PG.
#(though this extension is relocatable during installation).
relocatable = false
What would '@PROJECT_VERSION_MOD@' be replaced with and where is the $libdir set?
Thanks for any help.
