Provide RPM packages for EL8 / EL9

[Vonng]

What
Provide pg_search & pg_analytics RPM packages for EL8, EL9

Why
EL8, EL9 is widely used, especially in enterprise scenarios

How
We already have building & packaing templates for pg_search and pg_analytics

Just add them to the project CI/CD pipeline and release rpm @ the release page

And it would be great to provide debian 11/12 packages too.

[philippemnoel]

What Provide pg_search & pg_analytics RPM packages for EL8, EL9

Why EL8, EL9 is widely used, especially in enterprise scenarios

How We already have building & packaing templates for pg_search and pg_analytics

Just add them to the project CI/CD pipeline and release rpm @ the release page

And it would be great to provide debian 11/12 packages too.

Does Pigsty build to RPM on the GitHub Actions runners?

[Vonng]

No, hand made. Bump extenions to the latest version when new version of Pigsty is about to release.

git clone --recursive https://github.com/paradedb/paradedb.git
cd ~/paradedb; git checkout v0.6.1;

export PATH=/usr/pgsql-16/bin:/root/.cargo/bin:/pg/bin:/usr/share/Modules/bin:/usr/lib64/ccache:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/home/vagrant/.cargo/bin;
cd ~/paradedb/pg_search; HTTPS_PROXY=http://192.168.0.104:8118 cargo pgrx package; 
cd ~/paradedb/pg_analytics; HTTPS_PROXY=http://192.168.0.104:8118 cargo pgrx package; 

export PATH=/usr/pgsql-15/bin:/root/.cargo/bin:/pg/bin:/usr/share/Modules/bin:/usr/lib64/ccache:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/home/vagrant/.cargo/bin;
cd ~/paradedb/pg_search; cargo pgrx package -vvv; 
cd ~/paradedb/pg_analytics; cargo pgrx package  -vvv;

rm -rf ~/rpmbuild/SOURCES/pg_search_16;      cp -r ~/paradedb/target/release/pg_search-pg16      ~/rpmbuild/SOURCES/pg_search_16;
rm -rf ~/rpmbuild/SOURCES/pg_analytics_16;   cp -r ~/paradedb/target/release/pg_analytics-pg16   ~/rpmbuild/SOURCES/pg_analytics_16;
rm -rf ~/rpmbuild/SOURCES/pg_search_15;      cp -r ~/paradedb/target/release/pg_search-pg15      ~/rpmbuild/SOURCES/pg_search_15;
rm -rf ~/rpmbuild/SOURCES/pg_analytics_15;   cp -r ~/paradedb/target/release/pg_analytics-pg15   ~/rpmbuild/SOURCES/pg_analytics_15;

cd ~/rpmbuild/SPECS;
make pg_search pg_analytics;

rpmbuild --without debuginfo --define "pgmajorversion 16" -ba ~/rpmbuild/SPECS/pg_search.spec
rpmbuild --without debuginfo --define "pgmajorversion 16" -ba ~/rpmbuild/SPECS/pg_analytics.spec
rpmbuild --without debuginfo --define "pgmajorversion 15" -ba ~/rpmbuild/SPECS/pg_search.spec
rpmbuild --without debuginfo --define "pgmajorversion 15" -ba ~/rpmbuild/SPECS/pg_analytics.spec

[philippemnoel]

No, hand made. Bump extenions to the latest version when new version of Pigsty is about to release.

git clone --recursive https://github.com/paradedb/paradedb.git
cd ~/paradedb; git checkout v0.6.1;

export PATH=/usr/pgsql-16/bin:/root/.cargo/bin:/pg/bin:/usr/share/Modules/bin:/usr/lib64/ccache:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/home/vagrant/.cargo/bin;
cd ~/paradedb/pg_search; HTTPS_PROXY=http://192.168.0.104:8118 cargo pgrx package; 
cd ~/paradedb/pg_analytics; HTTPS_PROXY=http://192.168.0.104:8118 cargo pgrx package; 

export PATH=/usr/pgsql-15/bin:/root/.cargo/bin:/pg/bin:/usr/share/Modules/bin:/usr/lib64/ccache:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/home/vagrant/.cargo/bin;
cd ~/paradedb/pg_search; cargo pgrx package -vvv; 
cd ~/paradedb/pg_analytics; cargo pgrx package  -vvv;

rm -rf ~/rpmbuild/SOURCES/pg_search_16;      cp -r ~/paradedb/target/release/pg_search-pg16      ~/rpmbuild/SOURCES/pg_search_16;
rm -rf ~/rpmbuild/SOURCES/pg_analytics_16;   cp -r ~/paradedb/target/release/pg_analytics-pg16   ~/rpmbuild/SOURCES/pg_analytics_16;
rm -rf ~/rpmbuild/SOURCES/pg_search_15;      cp -r ~/paradedb/target/release/pg_search-pg15      ~/rpmbuild/SOURCES/pg_search_15;
rm -rf ~/rpmbuild/SOURCES/pg_analytics_15;   cp -r ~/paradedb/target/release/pg_analytics-pg15   ~/rpmbuild/SOURCES/pg_analytics_15;

cd ~/rpmbuild/SPECS;
make pg_search pg_analytics;

rpmbuild --without debuginfo --define "pgmajorversion 16" -ba ~/rpmbuild/SPECS/pg_search.spec
rpmbuild --without debuginfo --define "pgmajorversion 16" -ba ~/rpmbuild/SPECS/pg_analytics.spec
rpmbuild --without debuginfo --define "pgmajorversion 15" -ba ~/rpmbuild/SPECS/pg_search.spec
rpmbuild --without debuginfo --define "pgmajorversion 15" -ba ~/rpmbuild/SPECS/pg_analytics.spec

Got it. Thanks for sharing. Assuming we can run rpmbuild on Ubuntu, I'm happy to pick this up and support these other platforms. I'll look into it next week

[philippemnoel]

I've started taking a look at this as part of a PR to fix another user issue, will keep you posted

[philippemnoel]

We've just added Debian 11 and 12 packages with release v0.7.3: https://github.com/paradedb/paradedb/releases/tag/v0.7.3

We'll do some more testing for RPM packages, and then we'll add support for those as well soon!

[philippemnoel]

We've just added Debian 11 and 12 packages with release v0.7.3: https://github.com/paradedb/paradedb/releases/tag/v0.7.3

We'll do some more testing for RPM packages, and then we'll add support for those as well soon!

I have a basic setup for RHEL on https://github.com/paradedb/paradedb/tree/phil/rhel. Will slowly move this along alongside other priorities.