search

timescale / timescaledb-tune

A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.
https://www.timescale.com/
Apache License 2.0
437 stars 40 forks source link

timescaledb-tune is looking for wrong postgresql conf file version #93

Open cbellnuv opened 2 years ago

cbellnuv commented 2 years ago

I followed the instructions for setting up TimescaleDB on Ubuntu here and installed the package sudo apt install timescaledb-2-postgresql-13.

When I try to run timescaledb-tune, it's searching for postgres 14 config files. Here's the output:

exit: could not find postgresql.conf at any of these locations: /etc/postgresql/14/main/postgresql.conf /var/lib/pgsql/14/data/postgresql.conf /var/lib/postgres/data/postgresql.conf /var/lib/postgresql/data/postgresql.conf

My config file is located at /etc/postgresql/13/main/postgresql.conf.

I assume the package timescaledb-2-postgresql-13 should be looking for postgresql-13 config files, not postgresql-14? Following the instructions on that page verbatim installs postgres 13.

Running this command appears to work properly: sudo timescaledb-tune --conf-path=/etc/postgresql/13/main/postgresql.conf

svenklemm commented 2 years ago

Do you have postgres 14 installed too, it consults pg_config for the version to look for?

agrega-dev commented 1 year ago

Same error with version 14 timescaledb-tune exit: could not find postgresql.conf at any of these locations: /etc/postgresql/15/main/postgresql.conf /var/lib/pgsql/15/data/postgresql.conf /var/lib/postgres/data/postgresql.conf /var/lib/postgresql/data/postgresql.conf

timescaledb-tune is looking for version 15 and is not installed in the server

agrega-dev commented 1 year ago

I found the error, please verify the version of psql client, it should be the same version of database.

beevor commented 1 year ago

I found the error, please verify the version of psql client, it should be the same version of database.

To add to the answer from @agrega-dev, if installing postgresql-client via apt-get, make sure the version to be installed matches the installed postgres version. Also, run dpkg -l to verify that you only have one installed version, otherwise you will run into errors with timescale-tune unless you specifically pass it a config file.