Installing Steampipe Postgres FDW

Each Steampipe plugin is distributed as a distinct Steampipe Postgres FDW. They are available for download in the Releases for the corresponding plugin repo, however it is simplest to install them with the Steampipe Postgres FDW install script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/postgres.sh)"

The installer will prompt you for the plugin name and version, determine the OS, system architecture, and Postgres version, and download the appropriate package. It will use pg_config determine where to install the files, prompt for confirmation, and then copy them:

$ /bin/sh -c "$(curl -fsSL https://steampipe.io/install/postgres.sh)"
Enter the plugin name: aws
Enter the version (latest): 

Discovered:
- PostgreSQL version:   15
- PostgreSQL location:  /Applications/Postgres.app/Contents/Versions/15
- Operating system:     Darwin
- System architecture:  arm64

Based on the above, steampipe_postgres_aws.pg15.darwin_arm64.tar.gz will be downloaded, extracted and installed at: /Applications/Postgres.app/Contents/Versions/15

Proceed with installing Steampipe PostgreSQL FDW for version 15 at /Applications/Postgres.app/Contents/Versions/15?
- Press 'y' to continue with the current version.
- Press 'n' to customize your PostgreSQL installation directory and select a different version. (Y/n): 

Downloading https://api.github.com/repos/turbot/steampipe-plugin-aws/releases/latest/releases/assets/139269139...
###################################################################################################################################################################### 100.0%
x steampipe_postgres_aws.pg15.darwin_arm64/
x steampipe_postgres_aws.pg15.darwin_arm64/steampipe_postgres_aws.so
x steampipe_postgres_aws.pg15.darwin_arm64/create_extension_aws.sql
x steampipe_postgres_aws.pg15.darwin_arm64/install.sh
x steampipe_postgres_aws.pg15.darwin_arm64/steampipe_postgres_aws--1.0.sql
x steampipe_postgres_aws.pg15.darwin_arm64/steampipe_postgres_aws.control

Download and extraction completed.

Installing steampipe_postgres_aws in /Applications/Postgres.app/Contents/Versions/15...

Successfully installed steampipe_postgres_aws extension!

Files have been copied to:
- Library directory: /Applications/Postgres.app/Contents/Versions/15/lib/postgresql
- Extension directory: /Applications/Postgres.app/Contents/Versions/15/share/postgresql/extension/

If you don't want to use the installer, you can download, extract, and install the files yourself. There are downloadable tar.gz packages for all platforms available in the Releases for the corresponding plugin's Github repo (e.g. https://github.com/turbot/steampipe-plugin-aws/releases).

The tar.gz includes an install.sh script that you can run to install files, or you can copy them manually:

export LIBDIR=$(pg_config --pkglibdir)
export EXTDIR=$(pg_config --sharedir)/extension/

sudo cp steampipe*.so $LIBDIR
sudo cp steampipe*.sql $EXTDIR
sudo cp steampipe*.control $EXTDIR