timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.86k stars 884 forks source link

[Feature]: Support for Ventura #5320

Open NetFlareSuperAdmin opened 1 year ago

NetFlareSuperAdmin commented 1 year ago

What problem does the new feature solve?

I'd like to run timescale on Ventura.

But I am not seeing any support information on macos Ventura. The latest version supported is Monterey.

What does the feature do?

Would allow one to run timescale on Ventura.

Implementation challenges

No response

xvaara commented 1 year ago

I've ran it daily on my m1 since Ventura betas. What is your problem with it? It just seems that the documentation is a little out of date.

wellhat commented 1 year ago

@xvaara Starting from Mac OS Ventura 13.2 I installed PostgreSQL brew install postgresql, following on to step 3 from these docs I tried to install TimescaleDB brew install timescaledb

I got this error output:

clang: error: linker command failed with exit code 1 (use -v to see invocation)
make[2]: *** [tsl/src/timescaledb-tsl-2.10.0.so] Error 1
make[1]: *** [tsl/src/CMakeFiles/timescaledb-tsl.dir/all] Error 2
[100%] Linking C shared module timescaledb-2.10.0.so
ld: library not found for -lSystem
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make[2]: *** [src/timescaledb-2.10.0.so] Error 1
make[1]: *** [src/CMakeFiles/timescaledb.dir/all] Error 2
make: *** [all] Error 2

If reporting this issue please do so at (not Homebrew/brew or Homebrew/homebrew-core):
  https://github.com/timescale/homebrew-tap/issues

These open issues may also help:
Unable to install Timescaledb, mac Catalina https://github.com/timescale/homebrew-tap/issues/15
Error "Unsupported PostgreSQL version" with timescaleDB 2.2 and postgresql 13.1 https://github.com/timescale/homebrew-tap/issues/19
xvaara commented 1 year ago

@wellhat seems that your developer tools are messed up.

can you try sudo xcode-select --install and brew doctor if they output something relevant.

I have the whole xcode suite installed, don't know if that's somehow different.

ralexx commented 1 year ago

@wellhat seems that your developer tools are messed up.

can you try sudo xcode-select --install and brew doctor if they output something relevant.

I have the whole xcode suite installed, don't know if that's somehow different.

I had the identical error to @wellhat running Ventura 13.2 on an Intel Mac Mini. Reinstalling Xcode command line tools as described here allowed brew install timescaledb to proceed with Postgresql 14 already installed via homebrew.

kelvinlau20100 commented 1 year ago

I'm facing this error when trying to replicate what you guys have mentioned above, do you konw where I might be going wrong?

❯ arch -arm64 brew install timescaledb
==> Fetching timescale/tap/timescaledb
==> Downloading https://github.com/timescale/timescaledb/archive/refs/tags/2.10.1.tar.gz
Already downloaded: /Users/klau/Library/Caches/Homebrew/downloads/4e18dbc79acd80b00af64c380dfb0e64d1a1277c55fd4bf937a392b90f2c234d--timescaledb-2.10.1.tar.gz
==> Installing timescaledb from timescale/tap
==> ./bootstrap -DCMAKE_BUILD_TYPE=RelWithDebInfo -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF -DWARNINGS_AS_ERRORS=OFF -DLINTER=OFF -DPROJECT_INSTALL_METHOD="brew" -DOPENSSL_ROOT_DIR="/opt/h
==> make -C build
Last 15 lines from /Users/klau/Library/Logs/Homebrew/timescaledb/02.make:
[ 96%] Building C object src/CMakeFiles/timescaledb.dir/nodes/constraint_aware_append/constraint_aware_append.c.o
[ 97%] Building C object src/CMakeFiles/timescaledb.dir/planner/planner.c.o
[ 97%] Building C object src/CMakeFiles/timescaledb.dir/planner/add_hashagg.c.o
[ 98%] Building C object src/CMakeFiles/timescaledb.dir/planner/agg_bookend.c.o
[ 98%] Building C object src/CMakeFiles/timescaledb.dir/planner/constify_now.c.o
[ 98%] Building C object src/CMakeFiles/timescaledb.dir/planner/constraint_cleanup.c.o
[ 99%] Building C object src/CMakeFiles/timescaledb.dir/planner/expand_hypertable.c.o
[ 99%] Building C object src/CMakeFiles/timescaledb.dir/planner/partialize.c.o
[100%] Building C object src/CMakeFiles/timescaledb.dir/planner/space_constraint.c.o
[100%] Linking C shared module timescaledb-2.10.1.so
ld: can't link with a main executable file '/opt/homebrew/Cellar/postgresql@14/14.7/bin/postgres' for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make[2]: *** [src/timescaledb-2.10.1.so] Error 1
make[1]: *** [src/CMakeFiles/timescaledb.dir/all] Error 2
make: *** [all] Error 2

If reporting this issue please do so at (not Homebrew/brew or Homebrew/homebrew-core):
  https://github.com/timescale/homebrew-tap/issues

These open issues may also help:
Unable to install Timescaledb, mac Catalina https://github.com/timescale/homebrew-tap/issues/15
Error "Unsupported PostgreSQL version" with timescaleDB 2.2 and postgresql 13.1 https://github.com/timescale/homebrew-tap/issues/19
ralexx commented 1 year ago

ld: can't link with a main executable file '/opt/homebrew/Cellar/postgresql@14/14.7/bin/postgres' for architecture x86_64

Not my area of expertise but you appear to be targeting an ARM or aarch system while the compiler is looking for x86_64 PostgresSQL. Does not appear to be the same issue.

GuidoMelano commented 1 year ago

Same problem here. It isn't a way to use TimeScaleDB in MacOS Ventura? Please i need help.

divakarlasrinivas commented 1 year ago

I am using Ventura, 13.3.1, I had my Xcode and xcodebuild tool fully up and running and have been using for other day to day purpose, and I too was unsuccessful in installing timescale DB what worked for me is run sudo xcode-select --install brew install timescaledb