Public | Automated Build

Last pushed: 6 months ago
Short Description
Short description is empty for this repo.
Full Description

centos-postgres-madlib

CentOS 6 dockerfile for PostgreSQL 9.6 and MADlib 1.10 (https://github.com/apache/incubator-madlib).
MADlib is a collection of UDFs for scalable in-database analytics and statistical modeling.

  1. This image is available on dockerhub
    $ docker pull gmodena/centos-pgsql-madlib
    
    Alternatively, you can clone the git repo and build with
    $ ./build.sh
    
  2. Run

PostreSQL listens on port 5432 in the container; if port 5432 is open on your host you can run:

$ docker run  -dit -p 5432:5432 gmodena/centos-pgsql-madlib

otherwise, to assign a random port that maps to 5432 on the container:

$ docker run  -dit -p 5432 gmodena/centos-pgsql-madlib

You can see the random port the container is listening on with:

$ docker ps

It might take a while for pgsql to start up. You cam monitor the service status with

$ pg_isready -h localhost -p 5432
localhost:5432 - accepting connections
  1. Usage and test
    ```
    $ psql -h localhost -p 5432 -d maddb -U madlib --password
    maddb=# \d
               List of relations
    
    Schema | Name | Type | Owner
    --------+-------------------------+----------+--------
    madlib | migrationhistory | table | madlib
    madlib | migrationhistory_id_seq | sequence | madlib

```
The default password for this user and database is password.

Examples for getting started with MADlib can be found at https://github.com/madlib/madlib-examples

Docker Pull Command
Owner
gmodena
Source Repository

Comments (0)