postgrespro/pg_query_state

how to apply patches custom_signal.patch, executor_hooks.patch and runtime_explain？

msdnchina opened this issue · 4 comments

msdnchina commented

To install pg_query_state, please apply patches custom_signal.patch, executor_hooks.patch and runtime_explain.patch to the latest stable version of PostgreSQL and rebuild PostgreSQL. -----I want to know， how to apply patches custom_signal.patch, executor_hooks.patch and runtime_explain？？

Thank you very much！

maksm90 commented

Hello @msdnchina!

You have to:

  1. Checkout pg_query_state to the branch that corresponds to your postgres intallation.

    • PG9_5 - for PostgreSQL9.5
    • PGPRO9_6 - for PostgreSQL9.6
    • PGPRO10 - for PostgreSQL10

  2. Execute the one of the following commands in the postgres source code root directory:
    git apply path/to/*.patch
    or
    patch -p1 < path/to/*.patch

If you'll notice some conflicts, please report me. I'll immediately try to fix it.

msdnchina commented

I find that： in the “pg_query_state-PGPRO10.zip” file，there is no “executor_hooks.patch” ----Is this correct？

msdnchina commented

hi, when I apply patch, the following error happened:
[root@pgserver postgresql-10.2]# git apply /root/pg_query_state-PGPRO10/*.patch
error: patch failed: src/include/storage/procsignal.h:51
error: src/include/storage/procsignal.h: patch does not apply
[root@pgserver postgresql-10.2]# pwd
/root/postgresql-10.2
[root@pgserver postgresql-10.2]#

maksm90 commented

I find that： in the “pg_query_state-PGPRO10.zip” file，there is no “executor_hooks.patch” ----Is this correct？

Yes, executor_hooks.patch is intended only for testing extension on postgres 9.5. I have removed the notice about it from README.

when I apply patch, the following error happened

Thanks a lot for your report. I have put updated version of patches and extension itself into separate branch PG10. You can use it.