search

ossc-db / pg_hint_plan

Extension adding support for optimizer hints in PostgreSQL
Other
715 stars 103 forks source link

Where are the files for the pg_hint_plan rhel7 release kept? #143

Closed jjune235 closed 1 year ago

jjune235 commented 1 year ago

In the past, files for rhel7 were available for download from the release menu, but I can't find them now. I can find some related files on osdn.net, but I don't know if the files uploaded to osdn are officially supported by this project, and I don't know why this project is managed the way it is.

michaelpq commented 1 year ago

@mikecaat Could it be possible to add the RHEL7 packages to the release page for the latest versions? Or perhaps you have no plans to do so? RHEL7 is still production-relevant.

mikecaat commented 1 year ago

OK, I'll do so.

mikecaat commented 1 year ago

@jjune235 I uploaded the rpm packages for RHEL7. Could you confirm them? https://github.com/ossc-db/pg_hint_plan/releases

Notes: The packages were made and the regression tests were passed in the following conditions.

[root@localhost]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)

# The commit hashes which the packages are made
[root@localhost create_rpms]# grep -r "(HEAD" log/rpmbuild/
log/rpmbuild/pg15.3_rhel7_pg_hint_plan_1.5_20230705_102406.log:69747ab (HEAD, tag: refs/tags/REL15_1_5_0) Revert back to 1.5 as release number
log/rpmbuild/pg14.8_rhel7_pg_hint_plan_1.4.1_20230705_102430.log:c26349d (HEAD, tag: refs/tags/REL14_1_4_1) Version 1.4.1
log/rpmbuild/pg13.11_rhel7_pg_hint_plan_1.3.8_20230705_102447.log:4f3643f (HEAD, tag: refs/tags/REL13_1_3_8) Version 1.3.8
log/rpmbuild/pg12.15_rhel7_pg_hint_plan_1.3.8_20230705_102505.log:2bd1a64 (HEAD, tag: refs/tags/REL12_1_3_8) Version 1.3.8
log/rpmbuild/pg11.20_rhel7_pg_hint_plan_1.3.8_20230705_102523.log:be6d363 (HEAD, tag: refs/tags/REL11_1_3_8) Version 1.3.8
log/rpmbuild/pg10.23_rhel7_pg_hint_plan_1.3.7_20230705_102539.log:f253134 (HEAD, tag: refs/tags/REL10_1_3_7, refs/remotes/origin/PG10) Version 1.3.7

[root@localhost create_rpms]# grep -r "(HEAD" log/regtest
log/regtest/pg15.3_rhel7_pg_hint_plan_1.5_20230705_102720.log:69747ab (HEAD, tag: refs/tags/REL15_1_5_0) Revert back to 1.5 as release number
log/regtest/pg14.8_rhel7_pg_hint_plan_1.4.1_20230705_102815.log:c26349d (HEAD, tag: refs/tags/REL14_1_4_1) Version 1.4.1
log/regtest/pg13.11_rhel7_pg_hint_plan_1.3.8_20230705_102918.log:4f3643f (HEAD, tag: refs/tags/REL13_1_3_8) Version 1.3.8
log/regtest/pg12.15_rhel7_pg_hint_plan_1.3.8_20230705_103023.log:2bd1a64 (HEAD, tag: refs/tags/REL12_1_3_8) Version 1.3.8
log/regtest/pg11.20_rhel7_pg_hint_plan_1.3.8_20230705_103127.log:be6d363 (HEAD, tag: refs/tags/REL11_1_3_8) Version 1.3.8
log/regtest/pg10.23_rhel7_pg_hint_plan_1.3.7_20230705_103229.log:f253134 (HEAD, tag: refs/tags/REL10_1_3_7, refs/remotes/origin/PG10) Version 1.3.7

[root@localhost create_rpms]# grep -r "tests passed" log/regtest/| grep "All"
log/regtest/pg15.3_rhel7_pg_hint_plan_1.5_20230705_102720.log: All 17 tests passed.
log/regtest/pg14.8_rhel7_pg_hint_plan_1.4.1_20230705_102815.log: All 17 tests passed.
log/regtest/pg13.11_rhel7_pg_hint_plan_1.3.8_20230705_102918.log: All 16 tests passed.
log/regtest/pg12.15_rhel7_pg_hint_plan_1.3.8_20230705_103023.log: All 16 tests passed.
log/regtest/pg11.20_rhel7_pg_hint_plan_1.3.8_20230705_103127.log: All 16 tests passed.
log/regtest/pg10.23_rhel7_pg_hint_plan_1.3.7_20230705_103229.log: All 15 tests passed.
michaelpq commented 1 year ago

Thanks! I can see them on the release page, so I am closing this issue.

jjune235 commented 1 year ago

I found it working perfectly too, thank you so much mikecaat, michaelpq!