Comments (18)
Yes, we do not yet support Postgres 10, but as its release date gets nearer we'll certainly add it to our roadmap.
from timescaledb.
We're working on this!
from timescaledb.
TimescaleDB on PG10 is now available also via apt
using the following command:
sudo apt-get install timescaledb-postgresql-10
We will be updating docs with the next release to reflect these new naming conventions we'll be using going forward.
from timescaledb.
I ran sudo apt-get install timescaledb-postgresql-10
on Ubuntu 16.04, which shows
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
timescaledb-postgresql-10 : Depends: postgresql-10 but it is not installable
Depends: postgresql-server-dev-10 but it is not installable
E: Unable to correct problems, you have held broken packages.
from timescaledb.
Hi @jbkoh
Unfortunately PG10 is not available in Ubuntu's default repositories for 16.04, so you have to follow the instructions at the following link to include Postgresql's repos with have PG10:
http://yallalabs.com/linux/how-to-install-and-use-postgresql-10-on-ubuntu-16-04/
from timescaledb.
Release candidate 1 is out. Stable pg10 is around the corner. Is it time to revisit? :)
from timescaledb.
Out already :)
from timescaledb.
Any updates on the timeline for this?
from timescaledb.
@njern Initial support has landed on master, so we welcome volunteers to play around with it and see if there are any issues. This support will also be in 0.7.0, but a few of our release channels will still be based on 9.6 (Ubuntu and RPM most likely).
from timescaledb.
Nice, will take master
for a spin - thanks for the quick answer!
from timescaledb.
PG10 with timescale is working for me so far. Good job
from timescaledb.
Going to close this thread, please feel free to file individual bug reports if you come across something that doesn't work in PG10
from timescaledb.
@RobAtticus Is PG10 support in master
?
How to make it install into /usr/share/postgresql/10
?
What is the env var to specify the version, or how does it detect?
/app/timescaledb/build$ sudo make install
[ 2%] Built target sqlfile
[ 4%] Built target sqlupdatefile
[100%] Built target timescaledb
Install the project...
-- Install configuration: "Release"
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb.control
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.8.0-dev.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.7.1--0.8.0-dev.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.1.0--0.2.0.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.2.0--0.3.0.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.3.0--0.4.0.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.4.0--0.4.1.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.4.1--0.4.2.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.4.2--0.5.0.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.5.0--0.6.0.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.6.0--0.6.1.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.6.1--0.7.0.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.6.1--0.7.1.sql
-- Up-to-date: /usr/share/postgresql/9.6/extension/timescaledb--0.7.0--0.7.1.sql
-- Up-to-date: /usr/lib/postgresql/9.6/lib/timescaledb.so
from timescaledb.
@vjpr our build system relies on pg_config
to tell us where the PostgreSQL installation lives. If the pg_config
in your PATH
is 9.6 (you can check with pg_config --version
) then it will install for that.
You may have to prepend the value of the path to PG10 and it's binaries to your PATH
in order to override this behavior.
from timescaledb.
hi, does timescale support postgresql 10 now?
from timescaledb.
Yes it does.
from timescaledb.
From http://docs.timescale.com/latest/getting-started/installation/linux/installation-apt
Note: PostgreSQL 9.6 is required for TimescaleDB on Ubuntu distros. Releases with PostgreSQL 10 are coming soon
To get it working you can manually install on Ubuntu@16 like so:
sudo add-apt-repository 'deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
sudo apt-key add -
sudo apt-get update
sudo apt-get install -y postgresql-10 postgresql-contrib libpq-dev postgresql-server-dev-10
sudo apt-get install -y cmake
# TODO: Peg this to a specific version.
git clone https://github.com/timescale/timescaledb.git
cd timescaledb/
sudo ./bootstrap
cd build
sudo make
sudo make install
@RobAtticus Any chance the distros for Ubuntu will be released soon?
from timescaledb.
Thanks it works!
from timescaledb.
Related Issues (20)
- [Enhancement]: Allow specifying application_name for custom jobs
- [Bug]: average(time_weight('linear')) yields incorrect result
- [Bug]: UPDATE is hundreds of times less effective as UPSERT statement HOT 7
- [Bug]: realtime aggregation select planning and execution time is poor HOT 4
- [Bug]: Upgradee PostgreSQL 15.3 with TS 2.15 to PostgreSQL 16.3 failed HOT 1
- Continuous aggregation calculation error HOT 1
- [Enhancement]: Remove requirement that `compress_after` be larger than refresh policy's `start_offset` HOT 1
- ERROR: unsupported subplan type for SkipScan: Result HOT 3
- [Bug]: Insert directly into compressed chunk doesn't update compression state HOT 2
- How to perform linear interpolation? HOT 2
- [Question]: Postgres 13.5 instance started reporting "extension not found while getting version" HOT 1
- [Bug]: there is only policy_telemetry in timescaledb_information.job_history HOT 4
- [Bug]: live-migration - could not access file "wal2json" HOT 4
- [Bug]: DML decompression crash with by reference scankey on 32 bit systems HOT 3
- INSERT INTO hypertable using a PL/pgSQL function results in high RAM usage HOT 8
- [Bug]: reading a chunk ends up in DataFileRead hanging, other chunks work fine HOT 9
- [Bug]: `time_bucket_gapfill` in real-time CAGGs with time buckets fails to recursively aggregate results from source hypertable HOT 1
- [Bug]: time_bucket function doesn't account for time zone when applying offset HOT 1
- [Bug]: query planner not using index with subquery & multiple chunks HOT 5
- [Bug]: TimescaleDB always performs a sequential scan in chunks instead of index HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from timescaledb.