timescale / docs Goto Github PK
View Code? Open in Web Editor NEWTimescale product documentation π
Home Page: https://docs.timescale.com/
Timescale product documentation π
Home Page: https://docs.timescale.com/
Users asks what -infintiy
for next_start
means in jobs. E.g., on newly created continuous aggregate policy. I don't find if it is explained in the documentation so it will be great to explain.
Language quick-starts don't contain the guide for Java developers:
https://docs.timescale.com/timescaledb/latest/quick-start/
Just noticed that this page (https://docs-dev.timescale.com/docs-fix-windows-url/timescaledb/fix-windows-url/how-to-guides/install-timescaledb/self-hosted/windows/installation-source-windows/) mentions PG13 in the content, but has a label at the top about requiring PG11 or PG12. Perhaps we can get that fixed too?
Originally posted by @Loquacity in #102 (comment)
The link to "Timescale and Prometheus tutorial" gives a not-found error.
https://docs.timescale.com/timescaledb/latest/tutorials/tutorial-setup-timescale-prometheus/
https://docs.timescale.com/timescaledb/latest/tutorials/promscale/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
Our docs on self managed don't have any information on helm charts for K8s
No deadline
This is currently the only user-facing stuff we have on www/blog/docs that's readily available
https://blog.timescale.com/blog/new-helm-charts-for-deploying-timescaledb-on-kubernetes/
Hi,
I am attempting to gather info for a self hosted install of TimescaleDB via the AWS ami mentioned in the documentation. There is a link in the docs to information about instance sizing that is going to 404.
The link at the bottom to the Instance configuration page that is supposed to have info on selecting an appropriate instance type does not work.
Add content to the docs about full disk management.
25 May 2021
Blog post: https://docs.google.com/document/d/13krpideE2M3dhXM1TZgNNMmN0A_vNKVNWx30E4sMuF4/edit
Oh, I'm sorry for not being on time here @Loquacity.
I mean "seamless" that the latest version can automatically decompress the chunk in real-time to insert data into some compressed chunk and backfill it as "compressed" while in previous versions we need to: "decompress manually, insert data, compress manually".
Originally posted by @jonatas in #104 (comment)
In fixing #45 I noticed that we have a comprehensive blog post on real time continuous aggregates, but no specific section in the docs. Let's add a new topic in the CA section for real time.
@svenklemm and @mfreed wrote the blog post: https://blog.timescale.com/blog/achieving-the-best-of-both-worlds-ensuring-up-to-date-results-with-real-time-aggregation/
[When does this need to be addressed]
[Anything else you want to add, or further links]
The link to "run_job" gives a not found error.
old link: https://docs.timescale.com/api/latest/actions-and-automation/run_job/
new link: https://docs.timescale.com/api/latest/actions/run_job/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
Add a new page to show what extensions are allowed on the forge service.
pg_available_extensions
by default doesnβt match with what can actually be installed at Forge.
Here is query that can show the allowed extensions:
select pae.* from current_setting('extwlist.extensions') AS cs(e) cross join regexp_split_to_table(e, ',') as ext(allowed) join pg_available_extensions as pae on (allowed=name) order by 1;
Here is the output from my forge testing instance:
name | default_version | comment
------------------------+-----------------+----------------------------------------------------------------------
bloom | 1.0 | bloom access method - signature file based index
btree_gin | 1.3 | support for indexing common datatypes in GIN
btree_gist | 1.5 | support for indexing common datatypes in GiST
citext | 1.6 | data type for case-insensitive character strings
cube | 1.4 | data type for multidimensional cubes
dict_int | 1.0 | text search dictionary template for integers
dict_xsyn | 1.0 | text search dictionary template for extended synonym processing
fuzzystrmatch | 1.1 | determine similarities and distance between strings
hstore | 1.6 | data type for storing sets of (key, value) pairs
intarray | 1.2 | functions, operators, and index support for 1-D arrays of integers
isn | 1.2 | data types for international product numbering standards
lo | 1.1 | Large Object maintenance
ltree | 1.1 | data type for hierarchical tree-like structures
pg_stat_statements | 1.7 | track execution statistics of all SQL statements executed
pg_trgm | 1.4 | text similarity measurement and index searching based on trigrams
pgcrypto | 1.3 | cryptographic functions
pgrouting | 3.1.0 | pgRouting Extension
postgis | 3.1.1 | PostGIS geometry and geography spatial types and functions
postgis_raster | 3.1.1 | PostGIS raster types and functions
postgis_sfcgal | 3.1.1 | PostGIS SFCGAL functions
postgis_tiger_geocoder | 3.1.1 | PostGIS tiger geocoder and reverse geocoder
postgis_topology | 3.1.1 | PostGIS topology spatial types and functions
promscale | 0.1.2 | Promscale support functions
seg | 1.3 | data type for representing line segments or floating-point intervals
tablefunc | 1.0 | functions that manipulate whole tables, including crosstab
tcn | 1.0 | Triggered change notifications
timescale_analytics | 0.2 | timescale_analytics
timescaledb | 2.2.0 | Enables scalable inserts and complex queries for time-series data
tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent | 1.1 | text search dictionary that removes accents
uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs)
(32 rows)
At some point we also need to document David's backup tool, which has been on my plate for a long time.
https://github.com/timescale/timescaledb-backup
Originally posted by @ryanbooz in #62 (comment)
links to installation on os's other than windows are broken as the docs page has moved.
This page has no content: https://docs.timescale.com/timescaledb/latest/how-to-guides/replication-and-ha/
Move the content on https://docs.timescale.com/timescaledb/latest/how-to-guides/replication-and-ha/replication/ up one level and remove the blank landing page.
This link is broken. https://docs.timescale.com/timescaledb/latest/getting-started/setup-multi-node-basic/
latest
The two links marked in the screenshot are broken and result in a 404 page.
latest
There are multiple broken links on the Tutorial: Time-series forecasting page that results in 404 pages.
I found "Hello Timescale Tutorial" linked text listed twice that lead to 404. Additional linked text "Installed and set up PostGIS in database" leads to 404. See screenshots below for reference.
latest
There are more links on that "Introduction to time-series forecasting" docs page that I believe are not the correct URL destination. I'll create a new ticket following this one to detail those other links I'm referring to.
Use this template for reporting bugs in the docs.
missing links where there are brackets in the first sentence under the Compression section on docs. See attached screenshot with highlighted text that needs links.
https://docs.timescale.com/api/latest/compression/
latest
If known, who is a good person to ask about this topic
I'm not sure what the target URLs are for the two links being blog post and a tutorial or I'd include those on here as well.
Details here:
https://github.com/timescale/timescaledb/issues/3357
Create a new section with information about securing your Cloud instance.
[If known, who is a good person to ask about this topic]
[When does this need to be addressed]
[Anything else you want to add, or further links]
Forge screenshots need an update. The compute sizes have changed.
The images show older options.
The images should show the current options.
https://docs.timescale.com/timescale-forge/latest/create-a-service/#step-create-your-first-service
latest
[If known, who is a good person to ask about this topic]
[Attach images of screenshots showing the bug]
https://docs.timescale.com/timescaledb/latest/overview/release-notes/
The "Unreleased" section is confusing. Should it just be removed?
Create a new section for discussing HA on Forge.
[If known, who is a good person to ask about this topic]
[When does this need to be addressed]
[Anything else you want to add, or further links]
The link to "alter_job" gives a not-found error.
old link: https://docs.timescale.com/api/latest/actions-and-automation/alter_job/
new link: https://docs.timescale.com/api/latest/actions/alter_job/
https://docs.timescale.com/timescaledb/latest/how-to-guides/user-defined-actions/alter-and-delete/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
Create a new section for backing up/restoring on Forge
[When does this need to be addressed]
[Anything else you want to add, or further links]
Add the appropriate label(s) -->
Describe the bug
The Link for downloading the windows version of timescale does not work, the variable substitution seems broken:
https://timescalereleases.blob.core.windows.net/windows/timescaledb-postgresql-:pg_version:_x.y.z-windows-amd64.zip
Location
Screenshots
Device and browser
Desktop
When I click on the H3 heading in the Visualize missing data tutorial and in the Setup alerts tutorial, a new page opens and gives a Not Found error. I think it should not happen. I should stay on the same page.
Tried to explain the bug as much as possible. But not sure if I am making sense :-/
Once I click on the H3 heading, a new page opens and gives a Not Found error.
After clicking on the H3 heading, I should stay on the same page and navigate to the section I clicked on.
I found the same bug on these two pages:
https://docs.timescale.com/timescaledb/latest/tutorials/grafana/visualize-missing-data/
https://docs.timescale.com/timescaledb/latest/tutorials/grafana/setup-alerts/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
Add Promscale blog to a new docs section
Blog authors: @cevian @JLockerman @Harkishen-Singh
[When does this need to be addressed]
H/T @Harkishen-Singh
Relevant system information:
I just added support for installing timescaledb via MacPorts:
port -v install timescaledb +postgresqlXX
where XX is the appropriate variant, e.g. 96, 10, 11, 12.
Can this be added to your docs?
Add the appropriate label(s) -->
Describe the bug
There is a broken link on the Ingesting Data page. Broken link - https://docs.timescale.com/timescaledb/latest/how-to-guides/writing-data/
Location
https://docs.timescale.com/timescaledb/latest/how-to-guides/ingest-data
The Writing Data
link in the first paragraph is broken.
Screenshots
Device and browser
Desktop
Isn't obvious to users in the compression section that it's easy to turn off compression:
ALTER TABLE <hypertable> SET (timescaledb.compress=false);
Clarify what this will also do to existing compressed chunks.
Steps to reproduce
implementation "org.postgresql:postgresql:42.0.0"
import java.sql.DriverManager
val props = new Properties()
props.setProperty("user", username)
props.setProperty("password", password)
val connection = DriverManager.getConnection(jdbcUrl, props)
val copyManager = new CopyManager(connection.asInstanceOf[BaseConnection])
val result = copyManager.copyIn(s"""COPY $tableName FROM STDIN WITH DELIMITER as E'\t' """, bufferedReader)
driver throws exception:
org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
hanged
Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
Fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes #1903 (#1905) There is a small behaviour change here as a result. If closeOnCompletion is called on an existing statement and the statement is executed a second time it will fail.
the works out of the box.
It would be great to provide minimal required driver version. Users usually blindly copy-paste deps from project to project and don't really look at lib versions.
BTW
timescale/timescaledb:2.2.1-pg12
42.0.0
work, so it's unexpected that it doesn't work at forge. I tried all stuff locally before going to forge and start to spend money.
Use this template for reporting bugs in the docs.
The link to "install TimescaleDB" gives a not-found error.
https://docs.timescale.com/timescaledb/latest/getting-started/installation/
https://docs.timescale.com/timescaledb/latest/how-to-guides/install-timescaledb/
https://docs.timescale.com/timescaledb/latest/tutorials/visualize-with-tableu/#prerequisites
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
The link to "delete_job" gives a not found error.
https://docs.timescale.com/api/latest/actions-and-automation/delete_job/
https://docs.timescale.com/api/latest/actions/delete_job/
https://docs.timescale.com/timescaledb/latest/how-to-guides/user-defined-actions/alter-and-delete/# Version affected
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
The link to "setup Grafana" gives a not-found error.
https://docs.timescale.com/timescaledb/latest/getting-started/installation-grafana/
https://docs.timescale.com/timescaledb/latest/tutorials/grafana/installation/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
Use this template for reporting bugs in the docs.
Link to Data retention doc is broken
Links to:
https://docs.timescale.com/timescaledb/latest/how-to-guides/data-retention-with-continuous-aggregates/
'data retention documentation' should link to proper page
https://docs.timescale.com/timescaledb/latest/how-to-guides/continuous-aggregates/drop-raw-data/
[Which version of the site you noticed the bug on]
[If known, who is a good person to ask about this topic]
[Attach images of screenshots showing the bug]
[Anything else you want to add, or further links]
I think we need to add to our docs the fact that user can get out (or get into π ) "read-only" mode by changing default_transaction_read_only
postgres parameter.
The link to "upgrade documentation" gives a not found error.
https://docs.timescale.com/timescaledb/latest/v2.0/update-timescaledb/
https://docs.timescale.com/timescaledb/latest/how-to-guides/update-timescaledb/
https://docs.timescale.com/timescaledb/latest/overview/release-notes/changes-in-timescaledb-2
latest
[If known, who is a good person to ask about this topic]
All four links in the Conclusion section in the Tableau tutorial give a Not-found error.
https://docs.timescale.com/timescaledb/latest/tutorials/tutorial-forecasting/
https://docs.timescale.com/timescaledb/latest/tutorials/continuous-aggs-tutorial/
https://docs.timescale.com/timescaledb/latest/tutorials/other-sample-datasets/
https://docs.timescale.com/timescaledb/latest/getting-started/migrating-data/
https://docs.timescale.com/timescaledb/latest/tutorials/time-series-forecast/
https://docs.timescale.com/timescaledb/latest/how-to-guides/continuous-aggregates/
https://docs.timescale.com/timescaledb/latest/tutorials/sample-datasets/
https://docs.timescale.com/timescaledb/latest/how-to-guides/migrate-data/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
The link to "run_job" gives a not found error.
old link: https://docs.timescale.com/timescaledb/latest/api/#run_job
new link: https://docs.timescale.com/api/latest/actions/run_job/
https://docs.timescale.com/timescaledb/latest/how-to-guides/user-defined-actions/test-and-debug/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
The current How To pages (https://docs.timescale.com/timescaledb/latest/how-to-guides/) lack consistency. This issue tracks a high level review of these docs to bring them up to standard in terms of wording, writing style, syntax, etc. In preparation for a more comprehensive review of the structure later on.
@Loquacity for writing guidance
Timescale 2.3 Release notes
@NunoFilipeSantos , @erimatnor and @mfreed for this release.
May 25, 2021
Use this template for reporting bugs in the docs.
[Provide as much detail as you can]
[Provide the URL to the page you noticed the bug on]
[Which version of the site you noticed the bug on]
[If known, who is a good person to ask about this topic]
[Attach images of screenshots showing the bug]
[Anything else you want to add, or further links]
The link to "upgrade Timescale 2.0" gives a not-found error.
https://docs.timescale.com/timescaledb/latest/how-to-guides/update-timescaledb/update-tsdb-2/
https://docs.timescale.com/timescaledb/latest/how-to-guides/update-timescaledb/update-timescaledb-2/
https://docs.timescale.com/timescaledb/latest/overview/release-notes/changes-in-timescaledb-2/
latest
[If known, who is a good person to ask about this topic]
[Anything else you want to add, or further links]
Hi! I am not sure this is the right place to ask, kindly forgive me and point me to the correct forum if it isn't. I am looking for Timescale 1.7.* docs but I only found v2.* documentation at https://docs.timescale.com/ .
There are a couple of broken links in the timescale documentation under the "Migrate Existing Data" pages.
https://docs.timescale.com/timescaledb/latest#same-db
https://docs.timescale.com/timescaledb/latest#different-db
Report from the Timescale community Slack.
Links for reference:
timescaledb/getting-started/migrate-data.md
15:data, [follow these instructions][same-db].
36:## Migrate from the Same PostgreSQL Database [](same-db)
256:[same-db]: #same-db
timescaledb/how-to-guides/migrate-data/index.md
16:data, [follow these instructions][same-db].
37:## Migrate from the Same PostgreSQL Database [](same-db)
258:[same-db]: #same-db
It looks like a general issue with the local headers. I was checking the python tutorial, if you try to click on the first link it's also pointing to the main page.
The Forge docs currently have a section for configuring services, let's add a section for hardware config: https://docs.timescale.com/timescale-forge/latest/customize-configuration/
[If known, who is a good person to ask about this topic]
[When does this need to be addressed]
[Anything else you want to add, or further links]
A declarative, efficient, and flexible JavaScript library for building user interfaces.
π Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. πππ
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google β€οΈ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.