cargo-pgrx

cargo-pgrx is a Cargo subcommand for managing pgrx-based Postgres extensions.

You'll want to use cargo pgrx during your extension development process. It automates the process of creating new Rust crate projects, auto-generating the SQL schema for your extension, installing your extension locally for testing with Postgres, and running your test suite against one or more versions of Postgres.

A video walkthrough of its abilities can be found here: https://www.twitch.tv/videos/684087991

Installing

Install via crates.io:

$ cargo install --locked cargo-pgrx

As new versions of pgrx are released, you'll want to make sure you run this command again to update it. You should also reinstall cargo-pgrx whenever you update rustc so that the same compiler is used to build cargo-pgrx and your Postgres extensions. You can force cargo to reinstall an existing crate by passing --force.

Usage

$ cargo pgrx --help
Cargo subcommand for 'pgrx' to make Postgres extension development easy

Usage: cargo pgrx [OPTIONS] <COMMAND>

Commands:
  init     Initialize pgrx development environment for the first time
  info     Provides information about pgrx-managed development environment
  start    Start a pgrx-managed Postgres instance
  stop     Stop a pgrx-managed Postgres instance
  status   Is a pgrx-managed Postgres instance running?
  new      Create a new extension crate
  install  Install the extension from the current crate to the Postgres specified by whatever `pg_config` is currently on your $PATH
  package  Create an installation package directory
  schema   Generate extension schema files
  run      Compile/install extension to a pgrx-managed Postgres instance and start psql
  connect  Connect, via psql, to a Postgres instance
  test     Run the test suite for this crate
  get      Get a property from the extension control file
  cross    Cargo subcommand for 'pgrx' to make Postgres extension development easy
  help     Print this message or the help of the given subcommand(s)

Options:
  -v, --verbose...  Enable info logs, -vv for debug, -vvv for trace
  -h, --help        Print help
  -V, --version     Print version

Environment Variables

• PGRX_HOME - If set, overrides pgrx's default directory of ~/.pgrx/
• PGRX_BUILD_FLAGS - If set during cargo pgrx run/test/install, these additional flags are passed to cargo build while building the extension
• PGRX_BUILD_VERBOSE - Set to true to enable verbose "build.rs" output -- useful for debugging build issues
• HTTPS_PROXY - If set during cargo pgrx init, it will download the Postgres sources using these proxy settings. For more details refer to the env_proxy crate documentation.
• PGRX_IGNORE_RUST_VERSIONS - Set to true to disable the rustc version check we have when performing schema generation (schema generation requires the same version of rustc be used to build cargo-pgrx as the crate in question).

First Time Initialization

$ cargo pgrx init
  Discovered Postgres v15.0, v14.5, v13.8, v12.12, v11.17
  Downloading Postgres v15.0 from https://ftp.postgresql.org/pub/source/v15.0/postgresql-15.0.tar.bz2
  Downloading Postgres v11.17 from https://ftp.postgresql.org/pub/source/v11.17/postgresql-11.17.tar.bz2
  Downloading Postgres v12.12 from https://ftp.postgresql.org/pub/source/v12.12/postgresql-12.12.tar.bz2
  Downloading Postgres v13.8 from https://ftp.postgresql.org/pub/source/v13.8/postgresql-13.8.tar.bz2
  Downloading Postgres v14.5 from https://ftp.postgresql.org/pub/source/v14.5/postgresql-14.5.tar.bz2
     Removing /home/yourself/.pgrx/11.17
    Untarring Postgres v11.17 to /home/yourself/.pgrx/11.17
     Removing /home/yourself/.pgrx/14.5
     Removing /home/yourself/.pgrx/12.12
    Untarring Postgres v14.5 to /home/yourself/.pgrx/14.5
    Untarring Postgres v12.12 to /home/yourself/.pgrx/12.12
     Removing /home/yourself/.pgrx/15.0
     Removing /home/yourself/.pgrx/13.8
    Untarring Postgres v15.0 to /home/yourself/.pgrx/15.0
    Untarring Postgres v13.8 to /home/yourself/.pgrx/13.8
  Configuring Postgres v11.17
  Configuring Postgres v12.12
  Configuring Postgres v14.5
  Configuring Postgres v13.8
  Configuring Postgres v15.0
    Compiling Postgres v11.17
    Compiling Postgres v12.12
    Compiling Postgres v13.8
    Compiling Postgres v14.5
    Compiling Postgres v15.0
   Installing Postgres v11.17 to /home/yourself/.pgrx/11.17/pgrx-install
   Installing Postgres v12.12 to /home/yourself/.pgrx/12.12/pgrx-install
   Installing Postgres v13.8 to /home/yourself/.pgrx/13.8/pgrx-install
   Installing Postgres v14.5 to /home/yourself/.pgrx/14.5/pgrx-install
   Installing Postgres v15.0 to /home/yourself/.pgrx/15.0/pgrx-install
   Validating /home/yourself/.pgrx/11.17/pgrx-install/bin/pg_config
   Validating /home/yourself/.pgrx/12.12/pgrx-install/bin/pg_config
   Validating /home/yourself/.pgrx/13.8/pgrx-install/bin/pg_config
   Validating /home/yourself/.pgrx/14.5/pgrx-install/bin/pg_config
   Validating /home/yourself/.pgrx/15.0/pgrx-install/bin/pg_config

cargo pgrx init is required to be run once to properly configure the pgrx development environment.

As shown by the screenshot above, it downloads the latest versions of Postgres v11, v12, v13, v14, v15, configures them, compiles them, and installs them to ~/.pgrx/, including all contrib extensions and tools included with Postgres. Other pgrx commands such as run and test will fully manage and otherwise use these Postgres installations for you.

pgrx is designed to support multiple Postgres versions in such a way that during development, you'll know if you're trying to use a Postgres API that isn't common across all versions. It's also designed to make testing your extension against these versions easy. This is why it requires you to have all fully compiled and installed versions of Postgres during development.

In cases when default ports pgrx uses to run PostgreSQL within are not available, one can specify custom values for these during initialization using --base-port and --base-testing-port options. One of the use cases for this is using multiple installations of pgrx (using $PGRX_HOME variable) when developing multiple extensions at the same time. These values can be later changed in $PGRX_HOME/config.toml.

If you want to use your operating system's package manager to install Postgres, cargo pgrx init has optional arguments that allow you to specify where they're installed (see below).

What you're telling cargo pgrx init is the full path to pg_config for each version.

For any version you specify, cargo pgrx init will forego downloading/compiling/installing it. pgrx will then use that locally-installed version just as it uses any version it downloads/compiles/installs itself.

However, if the "path to pg_config" is the literal string download, then pgrx will download and compile that version of Postgres for you.

When the various --pgXX options are specified, these are the only versions of Postgres that pgrx will manage for you.

You'll also want to make sure you have the "postgresql-server-dev" package installed for each version you want to manage yourself. If you need to customize the configuration of the Postgres build, you can use --configure-flag to pass optins to the configure script. For example, you could use --configure-flag=--with-ssl=openssl to enable SSL support or --configure-flag=--with-libraries=/path/to/libs to use a non-standard location for dependency libraries. This flag can be used multiple times to pass multiple configuration options.

Once complete, cargo pgrx init also creates a configuration file (~/.pgrx/config.toml) that describes where to find each version's pg_config tool.

If a new minor Postgres version is released in the future you can simply run cargo pgrx init [args] again, and your local version will be updated, preserving all existing databases and configuration.

cargo-pgrx-init 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Initialize pgrx development environment for the first time

USAGE:
    cargo pgrx init [OPTIONS]

OPTIONS:
        --base-port <BASE_PORT>
            Base port number

        --base-testing-port <BASE_TESTING_PORT>
            Base testing port number

    -h, --help           Print help information
        --pg11 <PG11>    If installed locally, the path to PG11's `pgconfig` tool, or `download` to
                         have pgrx download/compile/install it [env: PG11_PG_CONFIG=]
        --pg12 <PG12>    If installed locally, the path to PG12's `pgconfig` tool, or `download` to
                         have pgrx download/compile/install it [env: PG12_PG_CONFIG=]
        --pg13 <PG13>    If installed locally, the path to PG13's `pgconfig` tool, or `download` to
                         have pgrx download/compile/install it [env: PG13_PG_CONFIG=]
        --pg14 <PG14>    If installed locally, the path to PG14's `pgconfig` tool, or `download` to
                         have pgrx download/compile/install it [env: PG14_PG_CONFIG=]
        --pg15 <PG15>    If installed locally, the path to PG15's `pgconfig` tool, or `download` to
                         have pgrx download/compile/install it [env: PG15_PG_CONFIG=]
    -v, --verbose        Enable info logs, -vv for debug, -vvv for trace
    -V, --version        Print version information

Creating a new Extension

$ cargo pgrx new example
$ ls example/
Cargo.toml  example.control  sql  src

cargo pgrx new <extname> is an easy way to get started creating a new extension. It's similar to cargo new <name>, but does the additional things necessary to support building a Rust Postgres extension.

If you'd like to create a "background worker" instead, specify the --bgworker argument.

cargo pgrx new does not initialize the directory as a git repo, but it does create a .gitignore file in case you decide to do so.

Workspace users: cargo pgrx new $NAME will create a $NAME/.cargo/config, you should move this into your workspace root as .cargo./config.

If you don't, you may experience unnecessary rebuilds using tools like Rust-Analyzer, as it will use the wrong rustflags option.

$ cargo pgrx new --help
cargo-pgrx-new 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Create a new extension crate

USAGE:
    cargo pgrx new [OPTIONS] <NAME>

ARGS:
    <NAME>    The name of the extension

OPTIONS:
    -b, --bgworker    Create a background worker template
    -h, --help        Print help information
    -v, --verbose     Enable info logs, -vv for debug, -vvv for trace
    -V, --version     Print version information

Managing Your Postgres Installations

$ cargo pgrx status all
Postgres v11 is stopped
Postgres v12 is stopped
Postgres v13 is stopped
Postgres v14 is stopped
Postgres v15 is stopped

$ cargo pgrx start all
    Starting Postgres v11 on port 28811
    Starting Postgres v12 on port 28812
    Starting Postgres v13 on port 28813
    Starting Postgres v14 on port 28814
    Starting Postgres v15 on port 28815

$ cargo pgrx status all
Postgres v11 is running
Postgres v12 is running
Postgres v13 is running
Postgres v14 is running
Postgres v15 is running

$ cargo pgrx stop all
    Stopping Postgres v11
    Stopping Postgres v12
    Stopping Postgres v13
    Stopping Postgres v14
    Stopping Postgres v15

cargo pgrx has three commands for managing each Postgres installation: start, stop, and status. Additionally, cargo pgrx run (see below) will automatically start its target Postgres instance if not already running.

When starting a Postgres instance, pgrx starts it on port 28800 + PG_MAJOR_VERSION, so Postgres 11 runs on 28811, 12 on 28812, etc. Additionally, the first time any of these are started, it'll automatically initialize a PGDATA directory in ~/.pgrx/data-[11 | 12 | 13 | 14 | 15]. Doing so allows pgrx to manage either Postgres versions it installed or ones already on your computer, and to make sure that in the latter case, pgrx managed versions don't interfere with what might already be running. The locale of the instance is C.UTF-8 (or equivalently, a locale of C with a ctype of UTF8 on macOS), or C if the C.UTF-8 locale is unavailable.

pgrx doesn't tear down these instances. While they're stored in a hidden directory in your home directory, pgrx considers these important and permanent database installations.

Once started, you can connect to them using psql (if you have it on your $PATH) like so: psql -p 28812. However, you probably just want the cargo pgrx run command.

Compiling and Running Your Extension

$ cargo pgrx run pg13
building extension with features ``
"cargo" "build" "--message-format=json-render-diagnostics"
    Finished dev [unoptimized + debuginfo] target(s) in 0.06s

installing extension
     Copying control file to /home/ana/.pgrx/13.5/pgrx-install/share/postgresql/extension/strings.control
     Copying shared library to /home/ana/.pgrx/13.5/pgrx-install/lib/postgresql/strings.so
    Building for SQL generation with features ``
    Finished dev [unoptimized + debuginfo] target(s) in 0.07s
 Discovering SQL entities
  Discovered 6 SQL entities: 0 schemas (0 unique), 6 functions, 0 types, 0 enums, 0 sqls, 0 ords, 0 hashes, 0 aggregates
     Writing SQL entities to /home/ana/.pgrx/13.5/pgrx-install/share/postgresql/extension/strings--0.1.0.sql
    Finished installing strings
    Starting Postgres v13 on port 28813
    Re-using existing database strings
psql (13.5)
Type "help" for help.

strings=# DROP EXTENSION strings;
ERROR:  extension "strings" does not exist
strings=# CREATE EXTENSION strings;
CREATE EXTENSION
strings=# \df strings.*
                                      List of functions
 Schema  |     Name      | Result data type |           Argument data types            | Type
---------+---------------+------------------+------------------------------------------+------
 strings | append        | text             | input text, extra text                   | func
 strings | return_static | text             |                                          | func
 strings | split         | text[]           | input text, pattern text                 | func
 strings | split_set     | SETOF text       | input text, pattern text                 | func
 strings | substring     | text             | input text, start integer, "end" integer | func
 strings | to_lowercase  | text             | input text                               | func
(6 rows)

strings=# select strings.to_lowercase('PGRX');
 to_lowercase
--------------
 pgrx
(1 row)

cargo pgrx run <pg11 | pg12 | pg13 | pg14 | pg15> is the primary interface into compiling and interactively testing/using your extension during development.

The very first time you execute cargo pgrx run pgXX, it needs to compile not only your extension, but pgrx itself, along with all its dependencies. Depending on your computer, this could take a bit of time (pgrx is nearly 200k lines of Rust when counting the generated bindings for Postgres). Afterwards, however (as seen in the above screenshot), it's fairly fast.

cargo pgrx run compiles your extension, installs it to the specified Postgres installation as described by its pg_config tool, starts that Postgres instance using the same process as cargo pgrx start pgXX, and drops you into a psql shell connected to a database, by default, named after your extension. From there, it's up to you to create your extension and use it.

This is also the stage where pgrx automatically generates the SQL schema for your extension via the sql-generator binary.

When you exit psql, the Postgres instance continues to run in the background.

For Postgres installations which are already on your computer, cargo pgrx run will need write permissions to the directories described by pg_config --pkglibdir and pg_config --sharedir. It's up to you to decide how to make that happen. While a single Postgres installation can be started multiple times on different ports and different data directories, it does not support multiple "extension library directories".

$ cargo pgrx run --help
cargo-pgrx-run 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Compile/install extension to a pgrx-managed Postgres instance and start psql

USAGE:
    cargo pgrx run [OPTIONS] [ARGS]

ARGS:
    <PG_VERSION>    Do you want to run against Postgres `pg11`, `pg12`, `pg13`, `pg14`,
                    `pg15`? [env: PG_VERSION=]
    <DBNAME>        The database to connect to (and create if the first time).  Defaults to a
                    database with the same name as the current extension name

OPTIONS:
        --all-features
            Activate all available features

        --features <FEATURES>
            Space-separated list of features to activate

    -h, --help
            Print help information

        --manifest-path <MANIFEST_PATH>
            Path to Cargo.toml

        --no-default-features
            Do not activate the `default` feature

    -p, --package <PACKAGE>
            Package to build (see `cargo help pkgid`)

        --pgcli
            Use an existing `pgcli` on the $PATH [env: PGRX_PGCLI=]

        --profile <PROFILE>
            Specific profile to use (conflicts with `--release`)

    -r, --release
            Compile for release mode (default is debug)

    -v, --verbose
            Enable info logs, -vv for debug, -vvv for trace

    -V, --version
            Print version information

Connect to a Database

$ cargo pgrx connect
    Re-using existing database strings
psql (13.5)
Type "help" for help.

strings=# select strings.to_lowercase('PGRX');
 to_lowercase
--------------
 pgrx
(1 row)

strings=#

If you'd simply like to connect to a managed version of Postgres without re-compiling and installing your extension, use cargo pgrx connect <pg11 | pg12 | pg13 | pg14 | pg15>.

This command will use the default database named for your extension, or you can specify another database name as the final argument.

If the specified database doesn't exist, cargo pgrx connect will create it. Similarly, if the specified version of Postgres isn't running, it'll be automatically started.

cargo-pgrx-connect 0.5.
ZomboDB, LLC <zombodb@gmail.com>
Connect, via psql, to a Postgres instance

USAGE:
    cargo pgrx connect [OPTIONS] [ARGS]

ARGS:
    <PG_VERSION>    Do you want to run against Postgres `pg11`, `pg12`, `pg13`, `pg14`,
                    `pg15`? [env: PG_VERSION=]
    <DBNAME>        The database to connect to (and create if the first time).  Defaults to a
                    database with the same name as the current extension name [env: DBNAME=]

OPTIONS:
    -h, --help
            Print help information

        --manifest-path <MANIFEST_PATH>
            Path to Cargo.toml

    -p, --package <PACKAGE>
            Package to determine default `pg_version` with (see `cargo help pkgid`)

        --pgcli
            Use an existing `pgcli` on the $PATH [env: PGRX_PGCLI=]

    -v, --verbose
            Enable info logs, -vv for debug, -vvv for trace

    -V, --version
            Print version information

Installing Your Extension Locally

$ cargo pgrx install
building extension with features ``
"cargo" "build" "--message-format=json-render-diagnostics"
    Finished dev [unoptimized + debuginfo] target(s) in 0.06s

installing extension
     Copying control file to /usr/share/postgresql/13/extension/strings.control
     Copying shared library to /usr/lib/postgresql/13/lib/strings.so
    Building for SQL generation with features ``
    Finished dev [unoptimized + debuginfo] target(s) in 0.06s
 Discovering SQL entities
  Discovered 6 SQL entities: 0 schemas (0 unique), 6 functions, 0 types, 0 enums, 0 sqls, 0 ords, 0 hashes, 0 aggregates
     Writing SQL entities to /usr/share/postgresql/13/extension/strings--0.1.0.sql
    Finished installing strings

If for some reason cargo pgrx run <PG_VERSION> isn't your style, you can use cargo pgrx install to install your extension to the Postgres installation described by the pg_config tool currently on your $PATH.

You'll need write permissions to the directories described by pg_config --pkglibdir and pg_config --sharedir.

By default, cargo pgrx install builds your extension in debug mode. Specifying --release changes that.

$ cargo pgrx install --help
cargo-pgrx-install 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Install the extension from the current crate to the Postgres specified by whatever `pg_config` is
currently on your $PATH

USAGE:
    cargo pgrx install [OPTIONS]

OPTIONS:
        --all-features
            Activate all available features

    -c, --pg-config <PG_CONFIG>
            The `pg_config` path (default is first in $PATH)

        --features <FEATURES>
            Space-separated list of features to activate

    -h, --help
            Print help information

        --manifest-path <MANIFEST_PATH>
            Path to Cargo.toml

        --no-default-features
            Do not activate the `default` feature

    -p, --package <PACKAGE>
            Package to build (see `cargo help pkgid`)

        --profile <PROFILE>
            Specific profile to use (conflicts with `--release`)

    -r, --release
            Compile for release mode (default is debug)

        --test
            Build in test mode (for `cargo pgrx test`)

    -v, --verbose
            Enable info logs, -vv for debug, -vvv for trace

    -V, --version
            Print version information

Testing Your Extension

$ cargo pgrx test
"cargo" "test" "--features" " pg_test"
    Finished test [unoptimized + debuginfo] target(s) in 0.07s
     Running unittests (target/debug/deps/spi-312296af509607bc)

running 2 tests
building extension with features ` pg_test`
"cargo" "build" "--features" " pg_test" "--message-format=json-render-diagnostics"
    Finished dev [unoptimized + debuginfo] target(s) in 0.06s

installing extension
     Copying control file to /home/ana/.pgrx/13.5/pgrx-install/share/postgresql/extension/spi.control
     Copying shared library to /home/ana/.pgrx/13.5/pgrx-install/lib/postgresql/spi.so
    Building for SQL generation with features ` pg_test`
    Finished test [unoptimized + debuginfo] target(s) in 0.07s
 Discovering SQL entities
  Discovered 11 SQL entities: 1 schemas (1 unique), 8 functions, 0 types, 0 enums, 2 sqls, 0 ords, 0 hashes, 0 aggregates
     Writing SQL entities to /home/ana/.pgrx/13.5/pgrx-install/share/postgresql/extension/spi--0.0.0.sql
    Finished installing spi
test tests::pg_test_spi_query_by_id_direct ... ok
test tests::pg_test_spi_query_by_id_via_spi ... ok

test result: ok. 2 passed; 0 failed; 0 ignored; 0 measured; 0 filtered out; finished in 1.61s

Stopping Postgres

cargo pgrx test [pg11 | pg12 | pg13 | pg14 | pg15] runs your #[test] and #[pg_test] annotated functions using cargo's test system.

During the testing process, pgrx starts a temporary instance of Postgres with its PGDATA directory in ./target/pgrx-test-data-PGVER/. This Postgres instance is stopped as soon as the test framework has finished. The locale of the temporary instance is C.UTF-8 (or equivalently, a locale of C with a ctype of UTF8 on macOS), or C if the C.UTF-8 locale is unavailable.

The output is standard "cargo test" output along with some Postgres log output. In the case of test failures, the failure report will include any Postgres log messages generated by that particular test.

Rust #[test] functions behave normally, while #[pg_test] functions are run inside the Postgres instance and have full access to all of Postgres internals. All tests are run in parallel, regardless of their type.

Additionally, a #[pg_test] function runs in a transaction that is aborted when the test is finished. As such, any changes it might make to the database are not preserved.

cargo-pgrx-test 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Run the test suite for this crate

USAGE:
    cargo pgrx test [OPTIONS] [ARGS]

ARGS:
    <PG_VERSION>    Do you want to run against Postgres `pg11`, `pg12`, `pg13`, `pg14`,
                    `pg15`, or `all`? [env: PG_VERSION=]
    <TESTNAME>      If specified, only run tests containing this string in their names

OPTIONS:
        --all-features
            Activate all available features

        --features <FEATURES>
            Space-separated list of features to activate

    -h, --help
            Print help information

        --manifest-path <MANIFEST_PATH>
            Path to Cargo.toml

    -n, --no-schema
            Don't regenerate the schema

        --no-default-features
            Do not activate the `default` feature

    -p, --package <PACKAGE>
            Package to build (see `cargo help pkgid`)

        --profile <PROFILE>
            Specific profile to use (conflicts with `--release`)

    -r, --release
            compile for release mode (default is debug)

    -v, --verbose
            Enable info logs, -vv for debug, -vvv for trace

    -V, --version
            Print version information

Building an Installation Package

$ cargo pgrx package
building extension with features ``
"cargo" "build" "--release" "--message-format=json-render-diagnostics"
    Finished release [optimized] target(s) in 0.07s

installing extension
     Copying control file to target/release/spi-pg13/usr/share/postgresql/13/extension/spi.control
     Copying shared library to target/release/spi-pg13/usr/lib/postgresql/13/lib/spi.so
    Building for SQL generation with features ``
    Finished release [optimized] target(s) in 0.07s
 Discovering SQL entities
  Discovered 8 SQL entities: 0 schemas (0 unique), 6 functions, 0 types, 0 enums, 2 sqls, 0 ords, 0 hashes, 0 aggregates
     Writing SQL entities to target/release/spi-pg13/usr/share/postgresql/13/extension/spi--0.0.0.sql
    Finished installing spi

cargo pgrx package [--debug] builds your extension, in --release mode, to a directory structure in ./target/[debug | release]/extension_name-PGVER using the Postgres installation path information from the pg_config tool on your $PATH.

The intent is that you'd then change into that directory and build a tarball or a .deb or .rpm package.

The directory structure cargo pgrx package creates starts at the root of the filesystem, as a package-manager installed version of Postgres is likely to split pg_config --pkglibdir and pg_config --sharedir into different base paths.

(In the example screenshot above, cargo pgrx package was used to build a directory structure using my manually installed version of Postgres 12.)

This command could be useful from Dockerfiles, for example, to automate building installation packages for various Linux distobutions or MacOS Postgres installations.

$ cargo pgrx package --help
cargo-pgrx-package 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Create an installation package directory

USAGE:
    cargo pgrx package [OPTIONS]

OPTIONS:
        --all-features
            Activate all available features

    -c, --pg-config <PG_CONFIG>
            The `pg_config` path (default is first in $PATH)

    -d, --debug
            Compile for debug mode (default is release)

        --features <FEATURES>
            Space-separated list of features to activate

    -h, --help
            Print help information

        --manifest-path <MANIFEST_PATH>
            Path to Cargo.toml

        --no-default-features
            Do not activate the `default` feature

        --out-dir <OUT_DIR>
            The directory to output the package (default is
            `./target/[debug|release]/extname-pgXX/`)

    -p, --package <PACKAGE>
            Package to build (see `cargo help pkgid`)

        --profile <PROFILE>
            Specific profile to use (conflicts with `--debug`)

        --test
            Build in test mode (for `cargo pgrx test`)

    -v, --verbose
            Enable info logs, -vv for debug, -vvv for trace

    -V, --version
            Print version information

Inspect your Extension Schema

If you just want to look at the full extension schema that pgrx will generate, use cargo pgrx schema.

$ cargo pgrx schema --help
cargo-pgrx-schema 0.5.0
ZomboDB, LLC <zombodb@gmail.com>
Generate extension schema files

USAGE:
    cargo pgrx schema [OPTIONS] [PG_VERSION]

ARGS:
    <PG_VERSION>    Do you want to run against Postgres `pg11`, `pg12`, `pg13`, `pg14`,
                    `pg15`?

OPTIONS:
        --all-features
            Activate all available features

    -c, --pg-config <PG_CONFIG>
            The `pg_config` path (default is first in $PATH)

    -d, --dot <DOT>
            A path to output a produced GraphViz DOT file

        --features <FEATURES>
            Space-separated list of features to activate

    -h, --help
            Print help information

        --manifest-path <MANIFEST_PATH>
            Path to Cargo.toml

        --no-default-features
            Do not activate the `default` feature

    -o, --out <OUT>
            A path to output a produced SQL file (default is `stdout`)

    -p, --package <PACKAGE>
            Package to build (see `cargo help pkgid`)

        --profile <PROFILE>
            Specific profile to use (conflicts with `--release`)

    -r, --release
            Compile for release mode (default is debug)

        --skip-build
            Skip building a fresh extension shared object

        --test
            Build in test mode (for `cargo pgrx test`)

    -v, --verbose
            Enable info logs, -vv for debug, -vvv for trace

    -V, --version
            Print version information

Information about pgx-managed development environment

$ cargo pgx info --help
Provides information about pgx-managed development environment

Usage: cargo pgx info [OPTIONS] <COMMAND>

Commands:
  path       Print path to a base version of Postgres build
  pg-config  Print path to pg_config for a base version of Postgres
  version    Print specific version for a base Postgres version
  help       Print this message or the help of the given subcommand(s)

Options:
  -v, --verbose...  Enable info logs, -vv for debug, -vvv for trace
  -h, --help        Print help
  -V, --version     Print version

cargo pgx info helps retrieving information about pgx-managed development environment (such as managed Postgres installations)

EXPERIMENTAL: Versioned shared-object support

pgrx experimentally supports the option to produce a versioned shared library. This allows multiple versions of the extension to be installed side-by-side, and can enable the deprecation (and removal) of functions between extension versions. There are some caveats which must be observed when using this functionality. For this reason it is currently experimental.

Activation

Versioned shared-object support is enabled by removing the module_pathname configuration value in the extension's .control file.

Concepts

Postgres has the implicit requirement that C extensions maintain ABI compatibility between versions. The idea behind this feature is to allow interoperability between two versions of an extension when the new version is not ABI compatible with the old version.

The mechanism of operation is to version the name of the shared library file, and to hard-code function definitions to point to the versioned shared library file. Without versioned shared-object support, the SQL definition of a C function would look as follows:

CREATE OR REPLACE FUNCTION "hello_extension"() RETURNS text /* &str */
STRICT
LANGUAGE c /* Rust */
AS 'MODULE_PATHNAME', 'hello_extension_wrapper';

MODULE_PATHNAME is replaced by Postgres with the configured value in the .control file. For pgrx-based extensions, this is usually set to $libdir/<extension-name>.

When using versioned shared-object support, the same SQL would look as follows:

CREATE OR REPLACE FUNCTION "hello_extension"() RETURNS text /* &str */
STRICT
LANGUAGE c /* Rust */
AS '$libdir/extension-0.0.0', 'hello_extension_wrapper';

Note that the versioned shared library is hard-coded in the function definition. This corresponds to the extension-0.0.0.so file which pgrx generates.

It is important to note that the emitted SQL is version-dependent. This means that all previously-defined C functions must be redefined to point to the current versioned-so in the version upgrade script. As an example, when updating the extension version to 0.1.0, the shared object will be named <extension-name>-0.1.0.so, and cargo pgrx schema will produce the following SQL for the above function:

CREATE OR REPLACE FUNCTION "hello_extension"() RETURNS text /* &str */
STRICT
LANGUAGE c /* Rust */
AS '$libdir/extension-0.1.0', 'hello_extension_wrapper';

This SQL must be used in the upgrade script from 0.0.0 to 0.1.0 in order to point the hello_extension function to the new shared object. pgrx does not do any magic to determine in which version a function was introduced or modified and only place it in the corresponding versioned so file. By extension, you can always expect that the shared library will contain all functions which are still defined in the extension's source code.

This feature is not designed to assist in the backwards compatibility of data types.

@MODULE_PATHNAME@ Templating

In case you are already providing custom SQL definitions for Rust functions, you can use the @MODULE_PATHNAME@ template in your custom SQL. This value will be replaced with the path to the actual shared object.

The following example illustrates how this works:

#[pg_extern(sql = r#"
    CREATE OR REPLACE FUNCTION tests."overridden_sql_with_fn_name"() RETURNS void
    STRICT
    LANGUAGE c /* Rust */
    AS '@MODULE_PATHNAME@', '@FUNCTION_NAME@';
"#)]
fn overridden_sql_with_fn_name() -> bool {
    true
}

Caveats

There are some scenarios which are entirely incompatible with this feature, because they rely on some global state in Postgres, so loading two versions of the shared library will cause trouble.

These scenarios are:

• when using shared memory
• when using query planner hooks

Compiler Version Dependence

The version of the Rust compiler and toolchain used to build cargo-pgrx must be the same as the version used to build your extension.

Several subcommands (including cargo pgrx schema, cargo pgrx test, cargo pgrx install, ...) will produce an error message if these do not match.

Although this may be relaxed in the future, currently schema generation involves dlopening the extension and calling extern "Rust" functions on #[repr(Rust)] types. Generally, the appropriate way to fix this is reinstall cargo-pgrx, using a command like the following

$ cargo install --force --locked cargo-pgrx

Possibly with a explicit --version, if needed.

If you are certain that in this case, it is fine, you may set PGRX_IGNORE_RUST_VERSIONS in the environment (to any value other than "0"), and the check will be bypassed. However, note that while the check is not fool-proof, it tries to be fairly liberal in what it allows.

See https://github.com/tcdi/pgrx/issues/774 and https://github.com/tcdi/pgrx/pull/873 for further information.