当前位置：文江博客话题详情

PostgreSQL-未找到超置槽扩展

发布于 2025-02-03 08:27:14 字数 776 浏览 1 评论 0原文

有人可以更好地解释（嗯，以一种让假人理解的方式），或更正确地安装 hyperloglog hll hll postgresql 在我的Mac M1机器上。

运行创建扩展hll;

我得到：

查询1错误：错误：无法打开扩展控制文件“/opt/homebrew/share/postgresql/extension/extension/hll.control”：没有这样的文件或目录

我是新的，所以此文档 https://github.com/citusdata/postgresql-hll 对我没有很多帮助。

我安装了除此之外所需的所有其他扩展程序。

当键入W HICH POSTGRES时，我得到：

/opt/homebrew/bin/postgres

Postgres（PostgreSQL）14.3

我看到了有关配置的信息pg_config，但我不明白我在这里应该做什么？

我将感谢它的帮助，希望这篇文章能够用于其他假人作为I. :)

原文

Can someone explain in a better way (well, in a way for dummies to understand), or more correctly how to install HyperLogLog hll extension for PostgreSQL on my Mac M1 machine.

When running CREATE EXTENSION hll;

I get:

Query 1 ERROR: ERROR: could not open extension control file "/opt/homebrew/share/postgresql/extension/hll.control": No such file or directory

I am new at this, so this documentation https://github.com/citusdata/postgresql-hll did not helped me a lot.

I installed all other extensions that I need except this one..

When typing which postgres I get:

/opt/homebrew/bin/postgres

And version: postgres (PostgreSQL) 14.3

I saw about configuring PG_CONFIG but I do not understand what exactly I should be doing here?

I will appreciate the help and I hope that this post will be of use for other dummies as I. :)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

心在旅行 2025-02-10 08:27:14

我们可以通过将所有以下所有内容复制到您的终端中简化上面的脚本并执行内联脚本：

> yes |
#!/bin/bash

# download latest release
curl -s https://api.github.com/repos/citusdata/postgresql-hll/releases/latest \
| grep '"tarball_url":' \
| sed -E 's/.*"([^"]+)".*/\1/' \
| xargs curl -o package.tar.gz -L

# extract to new hll directory
mkdir hll && tar xf package.tar.gz -C hll --strip-components 1

# build and install extension to postgres extensions folder
cd hll
make
make install

# remove hll directory
cd ../
rm -r ./hll

# connect to PostgreSQL and install extension
psql -U postgres -c "CREATE EXTENSION hll;"

We can simplify the script above and execute it inline by copying and pasting all of the following into your terminal:

> yes |
#!/bin/bash

# download latest release
curl -s https://api.github.com/repos/citusdata/postgresql-hll/releases/latest \
| grep '"tarball_url":' \
| sed -E 's/.*"([^"]+)".*/\1/' \
| xargs curl -o package.tar.gz -L

# extract to new hll directory
mkdir hll && tar xf package.tar.gz -C hll --strip-components 1

# build and install extension to postgres extensions folder
cd hll
make
make install

# remove hll directory
cd ../
rm -r ./hll

# connect to PostgreSQL and install extension
psql -U postgres -c "CREATE EXTENSION hll;"

回复收藏 0 原文

软糖 2025-02-10 08:27:14

我为自己编写了脚本以获取最后一个软件包并安装它。
我通过使用make来构建它。

# check if Makefile installed
make -v

# download latest release
curl -s https://api.github.com/repos/citusdata/postgresql-hll/releases/latest \
| grep '"tarball_url":' \
| sed -E 's/.*"([^"]+)".*/\1/' \
| xargs curl -o package.tar.gz -L 

# extract to hll directory
mkdir hll && tar xf package.tar.gz -C hll --strip-components 1

cd hll

# build and instll extension to postgres extensions folder
make 
make install


# remove hll directory
cd ../
rm -r ./hll

# connect to PostgreSQL
psql -U postgres 

# install extension in your DB
CREATE EXTENSION hll;

I wrote the script for myself to get the last package and install it.
I build it by using make.

# check if Makefile installed
make -v

# download latest release
curl -s https://api.github.com/repos/citusdata/postgresql-hll/releases/latest \
| grep '"tarball_url":' \
| sed -E 's/.*"([^"]+)".*/\1/' \
| xargs curl -o package.tar.gz -L 

# extract to hll directory
mkdir hll && tar xf package.tar.gz -C hll --strip-components 1

cd hll

# build and instll extension to postgres extensions folder
make 
make install


# remove hll directory
cd ../
rm -r ./hll

# connect to PostgreSQL
psql -U postgres 

# install extension in your DB
CREATE EXTENSION hll;

回复收藏 0 原文

~没有更多了~