Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
cbellnuv opened this issue Dec 7, 2021 · 4 comments
Open

Comments

@cbellnuv
Copy link

cbellnuv commented Dec 7, 2021

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
Copy link
Member

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

@agrega-dev
Copy link

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
Copy link

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

@beevor
Copy link

beevor commented Nov 10, 2022

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants