Convert is a Postgres extension providing common conversion functions, such as meters to feet or miles to kilometers.
The convert extension is built using the Rust pgrx framework.
Currently no pre-packaged installers are available. The following steps walk through creating a package on a typical Ubuntu based system with Postgres 14. These steps assume cargo pgrx is already installed.
The fpm step requires the fpm Ruby gem.
sudo apt install ruby-rubygems
sudo gem i fpmTiming note:
cargo pgrx packagetakes ~ 2 minutes on my main dev machine.
cargo pgrx package --pg-config /usr/lib/postgresql/15/bin/pg_config
cd target/release/convert-pg15/
find ./ -name "*.so" -exec strip {} \;
OUTFILE=convert.deb
rm ${OUTFILE} || true
fpm \
  -s dir \
  -t deb -n convert \
  -v 0.0.4 \
  --deb-no-default-config-files \
  -p ${OUTFILE} \
  -a amd64 \
  .
sudo dpkg -i --force-overwrite ./convert.deb