TimescaleDB Windows安装笔记

  1. 原始文档地址:https://docs.timescale.com/timescaledb/latest/how-to-guides/install-timescaledb/self-hosted/windows/installation-windows/#installation-windows
  2. PostgreSQL安装的过程中,发现数据库实例没有初始化成功,手动初始化见:https://blog.csdn.net/qq_36294121/article/details/117654849 ,之前初始化失败的原因似乎是因为刚开始locale选成了大陆简体中文
  3. setup脚本安装过程中,多次出现dll copy因权限原因失败,解决办法,是用管理员身份运行那个setup脚本。
  4. 下面是安装日志,从中可以看出具体做了哪些操作
2021/11/18 13:21:32 WELCOME to TimescaleDB Windows installer!
2021/11/18 13:21:32 timescaledb-tune is a program that modifies your postgresql.conf configuration to be optimized for your machine's resources.
Do you want to run timescaledb-tune.exe now? [(y)es / (n)o]: y
Please enter the path to your postgresql.conf:
D:\Dev\PostgreSQL\14\data
== Using postgresql.conf at this path:
D:\********\PostgreSQL\14\data\postgresql.conf

== Writing backup to:
C:\Users\********\AppData\Local\Temp/timescaledb_tune.backup202111181321

SUCCESS: shared_preload_libraries is set correctly

-- Tune memory/parallelism/WAL and other settings? [(y)es/(n)o]: y
== Recommendations based on 15.86 GB of available memory and 12 CPUs for PostgreSQL 14

== Memory settings recommendations
SUCCESS: memory settings are already tuned

== Parallelism settings recommendations
SUCCESS: parallelism settings are already tuned

== WAL settings recommendations
SUCCESS: WAL settings are already tuned

== Miscellaneous settings recommendations
SUCCESS: miscellaneous settings are already tuned
== Saving changes to: D:\Dev\PostgreSQL\14\data\postgresql.conf
2021/11/18 13:21:48 Installing TimescaleDB library files...
2021/11/18 13:21:48 Success!
2021/11/18 13:21:48 Installing TimescaleDB control file...
2021/11/18 13:21:48 Success!
2021/11/18 13:21:48 Installing TimescaleDB SQL files...
2021/11/18 13:21:49 Success!
TimescaleDB installation completed successfully.
Press ENTER/Return key to close...
上一篇:通过History Trends Unlimited通过统计服务器上Chrome浏览器Top10网页历史访问量(2021.11.23)


下一篇:Idea的快捷键