[
https://issues.apache.org/jira/browse/MADLIB-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17841378#comment-17841378
]
Ed Espino edited comment on MADLIB-1518 at 4/26/24 11:04 PM:
-------------------------------------------------------------
[~justatheory], the README instructions are more developer centric. There is no
need to create a build directory and cd into it. The PGXN client utility is
used to retrieve the package and perform necessary compilation steps. Here is
the general workflow I was able to follow:
I built PostgreSQL 15.6 from source. Starting with a default Google Cloud Rocky
9 VM, I installed the following packages for PostgreSQL Building:
{{ sudo dnf -d0 -y install wget gcc m4 flex bison readline-devel zlib-devel
libxml2-devel python-devel perl}}
My PostgreSQL 15.6 configure is:
{{{} ./configure --prefix=$HOME/pg15.6{}}}{{{}-bin --with-python
--with-perl --with-libxml{}}}
To validate the PostgreSQL's installation, I successfully ran
installcheck-world:
For pgxn client installation, the Apache MADlib PGXN package only needs one
additional package ({{{}cmake{}}}) on the system. This is used during the
extension's build phase. The package installation for building PostgreSQL
brings the additional build time dependencies.
{{ sudo pip install pgxnclient}}
{{ sudo chmod 777 /usr/local}}
{{ /usr/local/bin/pgxn install madlib}}
Once installed on the system, there are several python modules required for
general Apache MADlib extension use.
{{ export PGVER=15.6}}
{{ export PATH=$HOME/pg${PGVER}-bin/bin:$PATH}}
{{ export PGDATA=$HOME/pg${PGVER}-data}}
{{ export PGPORT=5432}}
{{ psql template1 -c 'CREATE DATABASE madlibtest'}}
{{ ## Rewquired by Apache MADlib's madpack utility to install extension
into PostgreSQL}}
{{ sudo pip install pyyaml}}
{{ /usr/local/madlib/bin/madpack -c localhost:${PGPORT}/madlibtest -s
madlib -p postgres install}}
{{ ## Required for Apache MADlib's madpack utility to execute install-check
command}}
{{ sudo pip install pyxb}}
{{ /usr/local/madlib/bin/madpack -c localhost:${PGPORT}/madlibtest -s
madlib -p postgres install-check}}
{{ ## Required for Apache MADlib's madpack utility to execute dev-check
command}}
{{ sudo pip install numpy rtree tensorflow==2.10.0 dill pandas xgboost
scikit-learn}}
{{ /usr/local/madlib/bin/madpack -c localhost:${PGPORT}/madlibtest -s
madlib -p postgres dev-check}}
was (Author: espino):
[~justatheory], the README instructions are more developer centric. The PGXN
client utility is used to retrieve the package and perform necessary
compilation steps. Here is the general workflow I was able to follow:
I built PostgreSQL 15.6 from source. Starting with a default Google Cloud Rocky
9 VM, I installed the following packages for PostgreSQL Building:
{{ sudo dnf -d0 -y install wget gcc m4 flex bison readline-devel zlib-devel
libxml2-devel python-devel perl}}
My PostgreSQL 15.6 configure is:
{{{} ./configure --prefix=$HOME/pg15.6{}}}{{{}-bin --with-python
--with-perl --with-libxml{}}}
To validate the PostgreSQL's installation, I successfully ran
installcheck-world:
For pgxn client installation, the Apache MADlib PGXN package only needs one
additional package ({{{}cmake{}}}) on the system. This is used during the
extension's build phase. The package installation for building PostgreSQL
brings the additional build time dependencies.
{{ sudo pip install pgxnclient}}
{{ sudo chmod 777 /usr/local}}
{{ /usr/local/bin/pgxn install madlib}}
Once installed on the system, there are several python modules required for
general Apache MADlib extension use.
{{ export PGVER=15.6}}
{{ export PATH=$HOME/pg${PGVER}-bin/bin:$PATH}}
{{ export PGDATA=$HOME/pg${PGVER}-data}}
{{ export PGPORT=5432}}
{{ psql template1 -c 'CREATE DATABASE madlibtest'}}
{{ ## Rewquired by Apache MADlib's madpack utility to install extension
into PostgreSQL}}
{{ sudo pip install pyyaml}}
{{ /usr/local/madlib/bin/madpack -c localhost:${PGPORT}/madlibtest -s
madlib -p postgres install}}
{{ ## Required for Apache MADlib's madpack utility to execute install-check
command}}
{{ sudo pip install pyxb}}
{{ /usr/local/madlib/bin/madpack -c localhost:${PGPORT}/madlibtest -s
madlib -p postgres install-check}}
{{ ## Required for Apache MADlib's madpack utility to execute dev-check
command}}
{{ sudo pip install numpy rtree tensorflow==2.10.0 dill pandas xgboost
scikit-learn}}
{{ /usr/local/madlib/bin/madpack -c localhost:${PGPORT}/madlibtest -s
madlib -p postgres dev-check}}
> Files missing from PGXN Release
> -------------------------------
>
> Key: MADLIB-1518
> URL: https://issues.apache.org/jira/browse/MADLIB-1518
> Project: Apache MADlib
> Issue Type: Bug
> Reporter: David E. Wheeler
> Assignee: Ed Espino
> Priority: Major
> Attachments: MADlib-setup.out
>
>
> Starting with the 1.19.0 release, the PGXN distribution is missing most of
> its files. Compare:
> * [v1.18.0|https://api.pgxn.org/src/madlib/madlib-1.18.0/]
> * [v1.19.0|https://api.pgxn.org/src/madlib/madlib-1.19.0/]
> * [v1.20.0|https://api.pgxn.org/src/madlib/madlib-1.20.0/]
> This means users can no longer use the PGXN client to build and install
> madlib. Was this intentional?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
