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 exists with the message exit: could not find postgresql.conf on Mac1 #98

Closed Rajakavitha1 closed 2 years ago

Rajakavitha1 commented 2 years ago

When you install TimescaleDB on Mac1 with home-brew Timescaledb-tune exists with message: exit: could not find postgresql.conf at any of these locations: /usr/local/var/postgres/postgresql.conf

When you specify the location of the conf file it works:

timescaledb-tune --conf-path=/opt/homebrew/var/postgres/postgresql.conf
Using postgresql.conf at this path:
/opt/homebrew/var/postgres/postgresql.conf

Writing backup to:
/var/folders/6d/5c405z253n35bqph1mh4bdp00000gn/T/timescaledb_tune.backup202206171221

shared_preload_libraries needs to be updated
Current:
#shared_preload_libraries = ''
Recommended:
shared_preload_libraries = 'timescaledb'
Is this okay? [(y)es/(n)o]: yes
success: shared_preload_libraries will be updated

Tune memory/parallelism/WAL and other settings? [(y)es/(n)o]: yes
Recommendations based on 8.00 GB of available memory and 8 CPUs for PostgreSQL 14
svenklemm commented 2 years ago

This should be fixed now. Please reopen if you still experience this with latest version.