Skip to content
dvarrazzo edited this page Apr 26, 2011 · 4 revisions

This is a study tool for a client for PGXN. Example usage:

$ sudo pgxn install --pg_config=/usr/local/pg91a5/bin/pg_config pair
INFO: best version: pair 0.1.2
INFO: saving /tmp/tmp2E6sYV/pair-0.1.2.pgz
INFO: unpacking: /tmp/tmp2E6sYV/pair-0.1.2.pgz
INFO: building extension
cp sql/pair.sql sql/pair--0.1.2.sql
cp sql/pair--unpackaged.sql sql/pair--unpackaged--0.1.2.sql
INFO: installing extension
/bin/mkdir -p '/usr/local/pg91a5/share/postgresql/extension'
/bin/mkdir -p '/usr/local/pg91a5/share/doc/postgresql/extension'
/bin/sh /usr/local/pg91a5/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./pair.control '/usr/local/pg91a5/share/postgresql/extension'
/bin/sh /usr/local/pg91a5/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./sql/pair--0.1.2.sql '/usr/local/pg91a5/share/postgresql/extension'
/bin/sh /usr/local/pg91a5/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./sql/pair--unpackaged--0.1.2.sql '/usr/local/pg91a5/share/postgresql/extension'
/bin/sh /usr/local/pg91a5/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./sql/pair--0.1.2.sql '/usr/local/pg91a5/share/postgresql/extension'

$ PGDATABASE=regression pgxn load --pg_config=/usr/local/pg91a5/bin/pg_config pair
INFO: best version: pair 0.1.2
CREATE EXTENSION

All the commands currently implemented:

usage: pgxn [-h] [--version] [--mirror URL] [--verbose]
            {load,search,user,install,mirror,download,check} ...

Interact with the PostgreSQL Extension Network (PGXN).

optional arguments:
  -h, --help            show this help message and exit
  --version             print the version number and exit

Global options:
  --mirror URL          the mirror to interact with [default:
                        http://api.pgxn.org/]
  --verbose             print more informations

COMMAND:
  {load,search,user,install,mirror,download,check}
                        The command to execute
    check               run a distribution's test
    download            download a distribution from the network
    install             install a distribution
    load                load the extensions in a distribution into a database
    mirror              return info about the mirrors available
    search              install an extension into a database
    user                return information about a PGXN user
Clone this wiki locally