MADlib apt安装，如何？ [英] MADlib apt install, how to?

问题描述

MADlib是PostgreSQL的最完整，最有效（更快的功能）和最可靠的数学库...在官方下载
没有有关Debian或UBUNTU即插即用安装的线索。

MADlib is the most complete, efficient (faster functions) and reliable Mathematical library for PostgreSQL... At official download no clues about Debian or UBUNTU "plug-and-play installation".

检查其他字体，最好（最简单）是2013年关于 apt-get 的说明。

Checking other fonts, the best (simplest) is an old 2013's instruction for apt-get it.

...还有一些 2014年的丢失脚本 ...评论说可以下载 .rpm 软件包并在Ubuntu中安装，只需将该软件包转换为 .deb 使用 Alien命令它将起作用。

... Also some lost-script of 2014... A comment say "can download the .rpm packages and to install in Ubuntu just convert the package to .deb using Alien command it will work".

问题：安装MADLib的安全和最简单的方法吗？
今天（2017年）在UBUNTU 16 LTS和PostgreSQL v9.6上安装。

Question: secure and simplest way to install MADLib?
today (2017) at UBUNTU 16 LTS and PostgreSQL v9.6.

注意和次要问题： Debian stable 和 UBUNTU LTS 一起是Web服务器上最流行的Linux发行版，因此 .deb 是最重要的分发表格...为什么MADlab维护人员拒绝看到它？为什么不欢迎 .deb 用户？
apt 有一些技术或许可证问题，或者转换后的 .deb ？

Note and secondary question: Debian stable and UBUNTU LTS together are the most popular Linux distributions for web-servers, so .deb is the most important distribution form... Why does the MADlab maintainers refuse to see it? Why not welcome .deb users?
There are some technical or license problems with apt or converted .deb ?

我有两种类型的SQL服务器，如所述的v9.6，但最重要的是 PostgreSQL v9.5.X （！sorry我们打算在所有服务器上使用v9.6。）

I have two types of SQL servers, the v9.6 as stated, but the most important is with PostgreSQL v9.5.X (!sorry we are wayting to use v9.6 in all servers).

在UBUNTU 16 LTS（xenial）中PostgreSQL 9.5.X的情况

• psql --version 并放入其中， select version（）; 显示 v9.5.6 。

命令 pgxnclient install madlib shows

You need to install postgresql-server-dev-X.Y for building 
a server-side extension or libpq-dev for building a client-side application.
ERROR: command returned 1: ['/usr/bin/pg_config', '--libdir']

... pg_config 不是配置文件，而是外壳程序工具...因此，我通过 sudo apt-get install libpq-dev （好！）

... pg_config is not a config file but a shell tool... So I installed it by sudo apt-get install libpq-dev (ok!)

• 命令 pgxnclient install madlib 显示

  INFO: best version: madlib 1.10.0
  INFO: saving /tmp/tmpip4ngh/madlib-1.10.0.zip
  INFO: unpacking: /tmp/tmpip4ngh/madlib-1.10.0.zip
  INFO: running configure
  error: cmake 2.8 or higher must be present to configure and install MADlib
  /tmp/tmpip4ngh/madlib-1.10.0/configure: 13: exit: Illegal number: -1
  ERROR: configure failed with return code 2

...但它不是 CMake版本错误，是无CMake错误，因此使用 apt安装cmake ！

... but it is not a "CMake version error", is "no CMake" error, so used apt install cmake!

但是他们一个cmake问题，

but them a cmake problem,

pgxnclient install madlib
INFO: best version: madlib 1.10.0
INFO: saving /tmp/tmpspQ3zf/madlib-1.10.0.zip
INFO: unpacking: /tmp/tmpspQ3zf/madlib-1.10.0.zip
INFO: running configure
-- The C compiler identification is GNU 5.4.0
-- The CXX compiler identification is GNU 5.4.0
-- Check for working C compiler: /usr/bin/gcc
-- Check for working C compiler: /usr/bin/gcc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/g++
-- Check for working CXX compiler: /usr/bin/g++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Could NOT find Boost
-- No sufficiently recent version (>= 1.47) of Boost was found. Will download.
-- Found PythonInterp: /usr/bin/python (found version "2.7.12") 
CMake Error at src/ports/postgres/cmake/FindPostgreSQL.cmake:161 (message):
  Found pg_config ("/usr/bin/pg_config"), but pg_config.h file not present in
  the server include dir (/usr/include/postgresql/9.5/server).
Call Stack (most recent call first):
  src/ports/postgres/cmake/PostgreSQLUtils.cmake:66 (find_package)
  src/ports/postgres/CMakeLists.txt:360 (determine_target_versions)

-配置不完整，发生了错误！
另请参见 /tmp/tmpspQ3zf/madlib-1.10.0/build/CMakeFiles/CMakeOutput.log。
INFO：构建扩展名
make -C构建所有
make [1]：输入目录'/tmp/tmpspQ3zf/madlib-1.10.0/build'
make [1] ： *没有将目标设为全部的规则。停止。
make [1]：离开目录'/tmp/tmpspQ3zf/madlib-1.10.0/build'
Makefile：5：目标全部的配方失败
make：* [全部]错误2
错误：返回命令2：使PG_CONFIG = / usr / bin / pg_config全部

-- Configuring incomplete, errors occurred! See also "/tmp/tmpspQ3zf/madlib-1.10.0/build/CMakeFiles/CMakeOutput.log". INFO: building extension make -C build all make[1]: Entering directory '/tmp/tmpspQ3zf/madlib-1.10.0/build' make[1]: * No rule to make target 'all'. Stop. make[1]: Leaving directory '/tmp/tmpspQ3zf/madlib-1.10.0/build' Makefile:5: recipe for target 'all' failed make: * [all] Error 2 ERROR: command returned 2: make PG_CONFIG=/usr/bin/pg_config all

推荐答案

Madlib是Postgres 扩展。许多人通过 pgxn.org 分发扩展名，就像 CPAN 或 Rubygems 。因此，安装它的命令是：

Madlib is a Postgres extension. Many people distribute their extensions via pgxn.org, which is like the CPAN or Rubygems of Postgres extensions. So the command to install it is this:

pgxnclient install madlib

之后，您可以在任意数据库中说 CREATE EXTENSION madlib 。

After that, you can say CREATE EXTENSION madlib in whatever database you like.

请注意，您可能需要先安装一些依赖项，例如：

Note you may need to install some dependencies first, for example:

sudo apt-get install cmake postgresql-plpython-9.6 pgxnclient

这是2013年的链接告诉你的，看起来仍然对我正确。 （请注意，虽然我将plpython从9.1更改为9.6。）我尝试在PostgreSQL 9.5 + Ubuntu 14.04上从pgxn自己安装madlib，并且可以使用。

This is what the link from 2013 is telling you, and it looks still correct to me. (Note I changed plpython from 9.1 to 9.6 though.) I tried installing madlib from pgxn myself on Postgres 9.5 + Ubuntu 14.04, and it worked.

至于为什么madlib人们不会分发 .deb 文件：您总是可以问他们，但是pgxn是共享Postgres扩展的主流方法。就像拥有一个用于您的编程语言的程序包管理器一样。

As for why the madlib folks don't distribute a .deb file: you could always ask them, but pgxn is the mainstream way to share Postgres extensions. It's just like having a package manager for your programming language.

这篇关于MADlib apt安装，如何？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！