search

phrrngtn / federated-data-logging

MIT License
0 stars 0 forks source link

Get Timescale docker image working on Windows 10 WSL2 and Mac #5

Open phrrngtn opened 2 years ago

phrrngtn commented 2 years ago

For mac: https://docs.docker.com/desktop/mac/install/

https://docs.timescale.com/timescaledb/latest/how-to-guides/install-timescaledb/self-hosted/docker/installation-docker/

Would be nice to have the tooling in #3 working with this. Note that Telegraf does not yet support direct insertion of data in Timescale. Xref https://github.com/influxdata/telegraf/pull/8651 Also, there is a forked version of Telagraf that does support Timescale as an output destination: https://blog.timescale.com/blog/introducing-the-postgresql-timescaledb-output-plugin-for-telegraf/

phrrngtn commented 2 years ago

actually, it looks like there is a version of timescaledb for ARM as well https://hub.docker.com/r/timescale/timescaledb/tags

phrrngtn commented 2 years ago

I was able to run the docker image on WSL2 on Windows 10 via Docker desktop and connect to the instance via psql:


C:\Program Files\PostgreSQL\14\bin>.\psql.exe -w -U postgres

postgres=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges
-----------+----------+----------+------------+------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(3 rows)

postgres=# \dx
                                      List of installed extensions
    Name     | Version |   Schema   |                            Description
-------------+---------+------------+-------------------------------------------------------------------
 plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
 timescaledb | 2.4.2   | public     | Enables scalable inserts and complex queries for time-series data
(2 rows)