I’m new to Timescale DB. Now I’m connecting with localhost(not using the cloud). But I can only see tutorials using the cloud only. where can I find comprehensive tutorials that cover basic to advanced concepts and cover all the errors themselves?
Welcome, @Vimal_Aathythan !
That’s a great question!
You can find a variety of tutorials for TimescaleDB that cover basic to advanced concepts on the TimescaleDB Tutorials page. These tutorials are not limited to cloud usage and can be applied to your local host setup as well. Most of these tutorials require a working installation of TimescaleDB.
Some tutorials you might find helpful include:- Introduction to TimescaleDB
- Time-series forecasting
- Analyze cryptocurrency data
- Analyze intraday stock data
- Build custom TimescaleDB dashboardsIf you encounter any issues or need troubleshooting help, you can refer to the Troubleshooting section for Timescale Cloud or the Troubleshooting section for TimescaleDB.
Our youtube channel is also full of materials and tutorials.
What is your type of application and what you’re looking to learn?
I facing this issue,
when I try to convert a table to hyper table. I’m getting this error
ERROR: function create_hypertable(unknown, unknown) does not exist
LINE 1: SELECT create_hypertable(‘conditions’, ‘time’);
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SELECT * FROM pg_extension WHERE extname=‘timescaledb’;
CREATE EXTENSION IF NOT EXISTS timescaledb;
I tried the above commands also.
it throws another error.
FATAL: extension “timescaledb” must be preloaded
HINT: Please preload the timescaledb library via shared_preload_libraries.
This can be done by editing the config file at: C:/Program Files/PostgreSQL/15/data/postgresql.conf
and adding ‘timescaledb’ to the list in the shared_preload_libraries config.
# Modify postgresql.conf:
shared_preload_libraries = ‘timescaledb’
Hi @Vimal_Aathythan, It’s very hard to debug an issue without having the proper environment here to follow you. Please, try to use docker on Windows or sign up for a trial at Timescale cloud to give it a try.