[
https://issues.apache.org/jira/browse/MADLIB-959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Frank McQuillan resolved MADLIB-959.
------------------------------------
Resolution: Fixed
> Installation with PGXN not available
> ------------------------------------
>
> Key: MADLIB-959
> URL: https://issues.apache.org/jira/browse/MADLIB-959
> Project: Apache MADlib
> Issue Type: Bug
> Components: Build System
> Reporter: Rahul Iyer
> Assignee: Rahul Iyer
> Fix For: v1.9.1
>
>
> Report from Caleb Welton:
> PGXN recently came up in a discussion I was having with respect to MADlib
> and I wanted to post some information here to the dev list for the
> community to consider.
> PGXN, the PostGres eXtension Network, is a portal/tool that provides easy
> access to common Postgres extensions, similar to CPAN for perl, PyPI for
> Python, or CRAN for R.
> It comes with a command line tool to aid with installation, e.g. if I had a
> postgres installation and I wanted to install orafce I could do the
> following:
> bash$ pgxn install orafce
> bash$ pgxn load orafce -D mydb
> The first command downloads the orafce package and compiles it, the second
> command installs the package into the default database.
> MADlib has some support for PGXN, however there are a few issues:
> 1. The version is an older release - 1.7.4 [1]
> 2. A default search on PGXN is a documentation search and the URL it finds
> for MADlib is stale: [2]
> 3. The package downloads and compiles fine (e.g. pgxn install), however it
> does not work with pgxn load:
> bash$ pgxn load madlib
> INFO: best version: madlib 1.7.4
> The extension 'madlib' doesn't contain a control file:
> it will be installed as a loose set of objects.
> Do you want to continue? [y/N] y
> ERROR: cannot find sql file for extension 'madlib': 'madlib--1.7.4.sql'
> I bring this up because pgxn is a widely used tool in the Postgres tool and
> providing installations instructions of `pgxn install madlib; pgxn load
> madlib` is a much cleaner solution to our current installation instructions
> [3].
> In order to support pgxn load we would need to support the Postgres CREATE
> EXTENSION syntax [4], or at a minimum install "loose objects" via a SQL
> file instead of the existing madpack mechanism.
> [1] http://pgxn.org/dist/madlib/
> [2] http://pgxn.org/dist/madlib/deploy/packagemaker/welcome.html
> [3] https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide
> [4] http://www.postgresql.org/docs/9.1/static/sql-createextension.html
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
