pg_strict v1.0.4

pg_strict v1.0.4

Installation

Quick Install (Linux x86_64)

Download and install the pre-built binary for your PostgreSQL version:

PostgreSQL 13

wget https://github.com/spa5k/pg_strict/releases/download/v1.0.4/pg_strict-pg13-linux-x86_64.tar.gz
tar -xzf pg_strict-pg13-linux-x86_64.tar.gz
sudo cp pg_strict.so $(pg_config --libdir)/
sudo cp pg_strict.control pg_strict--*.sql $(pg_config --sharedir)/extension/

PostgreSQL 14

wget https://github.com/spa5k/pg_strict/releases/download/v1.0.4/pg_strict-pg14-linux-x86_64.tar.gz
tar -xzf pg_strict-pg14-linux-x86_64.tar.gz
sudo cp pg_strict.so $(pg_config --libdir)/
sudo cp pg_strict.control pg_strict--*.sql $(pg_config --sharedir)/extension/

PostgreSQL 15

wget https://github.com/spa5k/pg_strict/releases/download/v1.0.4/pg_strict-pg15-linux-x86_64.tar.gz
tar -xzf pg_strict-pg15-linux-x86_64.tar.gz
sudo cp pg_strict.so $(pg_config --libdir)/
sudo cp pg_strict.control pg_strict--*.sql $(pg_config --sharedir)/extension/

PostgreSQL 16

wget https://github.com/spa5k/pg_strict/releases/download/v1.0.4/pg_strict-pg16-linux-x86_64.tar.gz
tar -xzf pg_strict-pg16-linux-x86_64.tar.gz
sudo cp pg_strict.so $(pg_config --libdir)/
sudo cp pg_strict.control pg_strict--*.sql $(pg_config --sharedir)/extension/

PostgreSQL 17

wget https://github.com/spa5k/pg_strict/releases/download/v1.0.4/pg_strict-pg17-linux-x86_64.tar.gz
tar -xzf pg_strict-pg17-linux-x86_64.tar.gz
sudo cp pg_strict.so $(pg_config --libdir)/
sudo cp pg_strict.control pg_strict--*.sql $(pg_config --sharedir)/extension/

PostgreSQL 18

wget https://github.com/spa5k/pg_strict/releases/download/v1.0.4/pg_strict-pg18-linux-x86_64.tar.gz
tar -xzf pg_strict-pg18-linux-x86_64.tar.gz
sudo cp pg_strict.so $(pg_config --libdir)/
sudo cp pg_strict.control pg_strict--*.sql $(pg_config --sharedir)/extension/

Then enable the extension in PostgreSQL:

CREATE EXTENSION pg_strict;

Build from Source

See the README for detailed instructions on building from source.

Verify Installation

SELECT pg_strict_version();
SELECT * FROM pg_strict_config();

What's Supported

• PostgreSQL versions: 13, 14, 15, 16, 17, 18
• Platform: Linux
• Architectures: x86_64, aarch64

Documentation

Full documentation available at: https://github.com/spa5k/pg_strict