Troubleshooting

    `

    `

    If your PostgreSQL logs have this error preventing it from starting up, you should double check that the TimescaleDB files have been installed to the correct location. Our installation methods use to get PostgreSQL’s location. However if you have multiple versions of PostgreSQL installed on the same machine, the location pg_config points to may not be for the version you expect. To check which version TimescaleDB used:

    2. $ pg_config --version
    3. PostgreSQL 12.3

    If that is the correct version, double check that the installation path is the one you’d expect. For example, for PostgreSQL 11.0 installed via Homebrew on macOS it should be :

    2. export PATH = /usr/local/Cellar/postgresql/11.0/bin:$PATH

    Then, reinstall TimescaleDB and it should find the correct installation path.

    Install or upgrade of TimescaleDB Toolkit fails

    `

    `

    In some cases, when you create the TimescaleDB Toolkit extension, or upgrade it with the ALTER EXTENSION timescaledb_toolkit UPDATE command, it might fail with the above error.

    1. If you’re installing Toolkit from a package, check your package manager’s local repository list. Make sure the TimescaleDB repository is available and contains Toolkit. For instructions on adding the TimescaleDB repository, see the installation guides:

    2. Update your local repository list with or yum update.

    3. Restart your PostgreSQL service.

    4. Check that the right version of Toolkit is among your available extensions:

      1. SELECT * FROM pg_available_extensions

    5. Retry CREATE EXTENSION or .