Обсуждение: pglogical install errors openSUSE Leap 42.1
In the process of trying to use pglogical to upgrade from 9.4 to 11.7. Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from 2nsQuadrant site. I am getting the following error during make clean all command:
o pglogical_worker.c
In file included from pglogical_worker.c:17:0:
/usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: gssapi/gssapi.h: No such file or directory
#include <gssapi/gssapi.h>
^
compilation terminated.
<builtin>: recipe for target 'pglogical_worker.o' failed
It appears that gssapi is Kerberos related. Just not exactly sure what package I am missing and should install on the OS to get this to compile. Currently I have only one gssapi related package installed on this system
S | Name | Summary | Type
--+---------------------------+--------------------------------------+--------
i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | package
Thanks,
Brian
On 2/18/20 11:39 AM, Bellrose, Brian wrote: > In the process of trying to use pglogical to upgrade from 9.4 to 11.7. > Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. > 2nsQuadrant site. I am getting the following error during make clean all > command: Did you follow the source install instructions here?: https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/ > > o pglogical_worker.c > > In file included from pglogical_worker.c:17:0: > > /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: > gssapi/gssapi.h: No such file or directory > > #include <gssapi/gssapi.h> > > ^ > > compilation terminated. > > <builtin>: recipe for target 'pglogical_worker.o' failed > > It appears that gssapi is Kerberos related. Just not exactly sure what > package I am missing and should install on the OS to get this to > compile. Currently I have only one gssapi related package installed on > this system > > S | Name | Summary | Type > > --+---------------------------+--------------------------------------+-------- > > i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | > package > > Thanks, > > Brian > > /This email and any attachments are only for use by the intended > recipient(s) and may contain legally privileged, confidential, > proprietary or otherwise private information. Any unauthorized use, > reproduction, dissemination, distribution or other disclosure of the > contents of this e-mail or its attachments is strictly prohibited. If > you have received this email in error, please notify the sender > immediately and delete the original. Neither this information block, the > typed name of the sender, nor anything else in this message is intended > to constitute an electronic signature unless a specific statement to the > contrary is included in this message. / -- Adrian Klaver adrian.klaver@aklaver.com
Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It has aboutthree sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. Brian -----Original Message----- From: Adrian Klaver <adrian.klaver@aklaver.com> Sent: Tuesday, February 18, 2020 3:49 PM To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 On 2/18/20 11:39 AM, Bellrose, Brian wrote: > In the process of trying to use pglogical to upgrade from 9.4 to 11.7. > Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. > 2nsQuadrant site. I am getting the following error during make clean > all > command: Did you follow the source install instructions here?: https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant.com_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d=DwID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8RTuGPAQPB44lQi_IV9goSuWDjl0pnqI&e= > > o pglogical_worker.c > > In file included from pglogical_worker.c:17:0: > > /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: > gssapi/gssapi.h: No such file or directory > > #include <gssapi/gssapi.h> > > ^ > > compilation terminated. > > <builtin>: recipe for target 'pglogical_worker.o' failed > > It appears that gssapi is Kerberos related. Just not exactly sure what > package I am missing and should install on the OS to get this to > compile. Currently I have only one gssapi related package installed on > this system > > S | Name | Summary | > Type > > --+---------------------------+--------------------------------------+-------- > > i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | > package > > Thanks, > > Brian > > /This email and any attachments are only for use by the intended > recipient(s) and may contain legally privileged, confidential, > proprietary or otherwise private information. Any unauthorized use, > reproduction, dissemination, distribution or other disclosure of the > contents of this e-mail or its attachments is strictly prohibited. If > you have received this email in error, please notify the sender > immediately and delete the original. Neither this information block, > the typed name of the sender, nor anything else in this message is > intended to constitute an electronic signature unless a specific > statement to the contrary is included in this message. / -- Adrian Klaver adrian.klaver@aklaver.com This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message.
On 2/18/20 12:54 PM, Bellrose, Brian wrote: > Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. > > Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. Well on my Leap 15.1 krb5-devel does provide gssapi.h. How was Postgres installed on the machine? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 3:49 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org > Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 > > On 2/18/20 11:39 AM, Bellrose, Brian wrote: >> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from > > FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. > >> 2nsQuadrant site. I am getting the following error during make clean >> all >> command: > > Did you follow the source install instructions here?: > > https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant.com_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d=DwID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8RTuGPAQPB44lQi_IV9goSuWDjl0pnqI&e= > >> >> o pglogical_worker.c >> >> In file included from pglogical_worker.c:17:0: >> >> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >> gssapi/gssapi.h: No such file or directory >> >> #include <gssapi/gssapi.h> >> >> ^ >> >> compilation terminated. >> >> <builtin>: recipe for target 'pglogical_worker.o' failed >> >> It appears that gssapi is Kerberos related. Just not exactly sure what >> package I am missing and should install on the OS to get this to >> compile. Currently I have only one gssapi related package installed on >> this system >> >> S | Name | Summary | >> Type >> >> --+---------------------------+--------------------------------------+-------- >> >> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >> package >> >> Thanks, >> >> Brian >> >> /This email and any attachments are only for use by the intended >> recipient(s) and may contain legally privileged, confidential, >> proprietary or otherwise private information. Any unauthorized use, >> reproduction, dissemination, distribution or other disclosure of the >> contents of this e-mail or its attachments is strictly prohibited. If >> you have received this email in error, please notify the sender >> immediately and delete the original. Neither this information block, >> the typed name of the sender, nor anything else in this message is >> intended to constitute an electronic signature unless a specific >> statement to the contrary is included in this message. / > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com
I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel... Ok,good to know. Seems like that may be the missing link. At least I hope it is the only one. Brian -----Original Message----- From: Adrian Klaver <adrian.klaver@aklaver.com> Sent: Tuesday, February 18, 2020 4:19 PM To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 On 2/18/20 12:54 PM, Bellrose, Brian wrote: > Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. > > Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. Well on my Leap 15.1 krb5-devel does provide gssapi.h. How was Postgres installed on the machine? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 3:49 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > pgsql-general@lists.postgresql.org > Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 > > On 2/18/20 11:39 AM, Bellrose, Brian wrote: >> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from > > FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. > >> 2nsQuadrant site. I am getting the following error during make clean >> all >> command: > > Did you follow the source install instructions here?: > > https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant.c > om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d=D > wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8hu > ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8RTu > GPAQPB44lQi_IV9goSuWDjl0pnqI&e= > >> >> o pglogical_worker.c >> >> In file included from pglogical_worker.c:17:0: >> >> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >> gssapi/gssapi.h: No such file or directory >> >> #include <gssapi/gssapi.h> >> >> ^ >> >> compilation terminated. >> >> <builtin>: recipe for target 'pglogical_worker.o' failed >> >> It appears that gssapi is Kerberos related. Just not exactly sure >> what package I am missing and should install on the OS to get this to >> compile. Currently I have only one gssapi related package installed >> on this system >> >> S | Name | Summary | >> Type >> >> --+---------------------------+--------------------------------------+-------- >> >> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >> package >> >> Thanks, >> >> Brian >> >> /This email and any attachments are only for use by the intended >> recipient(s) and may contain legally privileged, confidential, >> proprietary or otherwise private information. Any unauthorized use, >> reproduction, dissemination, distribution or other disclosure of the >> contents of this e-mail or its attachments is strictly prohibited. If >> you have received this email in error, please notify the sender >> immediately and delete the original. Neither this information block, >> the typed name of the sender, nor anything else in this message is >> intended to constitute an electronic signature unless a specific >> statement to the contrary is included in this message. / > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message.
On 2/18/20 1:22 PM, Bellrose, Brian wrote: > I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel... Ok,good to know. Seems like that may be the missing link. At least I hope it is the only one. Was postgresql94-devel also installed? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 4:19 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 > > On 2/18/20 12:54 PM, Bellrose, Brian wrote: >> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. >> >> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. > > Well on my Leap 15.1 krb5-devel does provide gssapi.h. > > How was Postgres installed on the machine? > >> >> Brian >> >> -----Original Message----- >> From: Adrian Klaver <adrian.klaver@aklaver.com> >> Sent: Tuesday, February 18, 2020 3:49 PM >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >> pgsql-general@lists.postgresql.org >> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 >> >> On 2/18/20 11:39 AM, Bellrose, Brian wrote: >>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar from >> >> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. >> >>> 2nsQuadrant site. I am getting the following error during make clean >>> all >>> command: >> >> Did you follow the source install instructions here?: >> >> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant.c >> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d=D >> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8hu >> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8RTu >> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= >> >>> >>> o pglogical_worker.c >>> >>> In file included from pglogical_worker.c:17:0: >>> >>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >>> gssapi/gssapi.h: No such file or directory >>> >>> #include <gssapi/gssapi.h> >>> >>> ^ >>> >>> compilation terminated. >>> >>> <builtin>: recipe for target 'pglogical_worker.o' failed >>> >>> It appears that gssapi is Kerberos related. Just not exactly sure >>> what package I am missing and should install on the OS to get this to >>> compile. Currently I have only one gssapi related package installed >>> on this system >>> >>> S | Name | Summary | >>> Type >>> >>> --+---------------------------+--------------------------------------+-------- >>> >>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >>> package >>> >>> Thanks, >>> >>> Brian >>> >>> /This email and any attachments are only for use by the intended >>> recipient(s) and may contain legally privileged, confidential, >>> proprietary or otherwise private information. Any unauthorized use, >>> reproduction, dissemination, distribution or other disclosure of the >>> contents of this e-mail or its attachments is strictly prohibited. If >>> you have received this email in error, please notify the sender >>> immediately and delete the original. Neither this information block, >>> the typed name of the sender, nor anything else in this message is >>> intended to constitute an electronic signature unless a specific >>> statement to the contrary is included in this message. / >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com
Yes, S | Name | Summary | Type --+-----------------------+-------------------------------------------------------------------------+-------- i | postgresql94 | Basic Clients and Utilities for PostgreSQL | package i | postgresql94-contrib | Contributed Extensions and Additions to PostgreSQL | package i | postgresql94-devel | PostgreSQL development header files and libraries | package i | postgresql94-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | package i | postgresql94-plpython | The PL/Python Procedural Languages for PostgreSQL | package i | postgresql94-pltcl | PL/Tcl Procedural Language for PostgreSQL | package i | postgresql94-server | The Programs Needed to Create and Run a PostgreSQL Server | package i | postgresql94-test | The test suite for PostgreSQL | package Brian -----Original Message----- From: Adrian Klaver <adrian.klaver@aklaver.com> Sent: Tuesday, February 18, 2020 4:41 PM To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 On 2/18/20 1:22 PM, Bellrose, Brian wrote: > I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel... Ok,good to know. Seems like that may be the missing link. At least I hope it is the only one. Was postgresql94-devel also installed? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 4:19 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > 42.1 > > On 2/18/20 12:54 PM, Bellrose, Brian wrote: >> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. >> >> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. > > Well on my Leap 15.1 krb5-devel does provide gssapi.h. > > How was Postgres installed on the machine? > >> >> Brian >> >> -----Original Message----- >> From: Adrian Klaver <adrian.klaver@aklaver.com> >> Sent: Tuesday, February 18, 2020 3:49 PM >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >> pgsql-general@lists.postgresql.org >> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 >> >> On 2/18/20 11:39 AM, Bellrose, Brian wrote: >>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar >>> from >> >> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. >> >>> 2nsQuadrant site. I am getting the following error during make clean >>> all >>> command: >> >> Did you follow the source install instructions here?: >> >> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant. >> c >> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d= >> D >> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8h >> u >> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8RT >> u >> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= >> >>> >>> o pglogical_worker.c >>> >>> In file included from pglogical_worker.c:17:0: >>> >>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >>> gssapi/gssapi.h: No such file or directory >>> >>> #include <gssapi/gssapi.h> >>> >>> ^ >>> >>> compilation terminated. >>> >>> <builtin>: recipe for target 'pglogical_worker.o' failed >>> >>> It appears that gssapi is Kerberos related. Just not exactly sure >>> what package I am missing and should install on the OS to get this >>> to compile. Currently I have only one gssapi related package >>> installed on this system >>> >>> S | Name | Summary | >>> Type >>> >>> --+---------------------------+--------------------------------------+-------- >>> >>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >>> package >>> >>> Thanks, >>> >>> Brian >>> >>> /This email and any attachments are only for use by the intended >>> recipient(s) and may contain legally privileged, confidential, >>> proprietary or otherwise private information. Any unauthorized use, >>> reproduction, dissemination, distribution or other disclosure of the >>> contents of this e-mail or its attachments is strictly prohibited. >>> If you have received this email in error, please notify the sender >>> immediately and delete the original. Neither this information block, >>> the typed name of the sender, nor anything else in this message is >>> intended to constitute an electronic signature unless a specific >>> statement to the contrary is included in this message. / >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message.
On 2/18/20 1:56 PM, Bellrose, Brian wrote: > Yes, > > S | Name | Summary | Type > --+-----------------------+-------------------------------------------------------------------------+-------- > i | postgresql94 | Basic Clients and Utilities for PostgreSQL | package > i | postgresql94-contrib | Contributed Extensions and Additions to PostgreSQL | package > i | postgresql94-devel | PostgreSQL development header files and libraries | package > i | postgresql94-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | package > i | postgresql94-plpython | The PL/Python Procedural Languages for PostgreSQL | package > i | postgresql94-pltcl | PL/Tcl Procedural Language for PostgreSQL | package > i | postgresql94-server | The Programs Needed to Create and Run a PostgreSQL Server | package > i | postgresql94-test | The test suite for PostgreSQL | packagep Alright that looks good. You may still need to play Whack-a-Mole with devel libraries. I am curious how you got to 9.4.25 via an update, given that this Postgres version was released well past the OS EOL? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 4:41 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 > > On 2/18/20 1:22 PM, Bellrose, Brian wrote: >> I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel...Ok, good to know. Seems like that may be the missing link. At least I hope it is the only one. > > Was postgresql94-devel also installed? > >> >> Brian >> >> -----Original Message----- >> From: Adrian Klaver <adrian.klaver@aklaver.com> >> Sent: Tuesday, February 18, 2020 4:19 PM >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >> pgsql-general@lists.postgresql.org >> Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap >> 42.1 >> >> On 2/18/20 12:54 PM, Bellrose, Brian wrote: >>> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. >>> >>> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. >> >> Well on my Leap 15.1 krb5-devel does provide gssapi.h. >> >> How was Postgres installed on the machine? >> >>> >>> Brian >>> >>> -----Original Message----- >>> From: Adrian Klaver <adrian.klaver@aklaver.com> >>> Sent: Tuesday, February 18, 2020 3:49 PM >>> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >>> pgsql-general@lists.postgresql.org >>> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 >>> >>> On 2/18/20 11:39 AM, Bellrose, Brian wrote: >>>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >>>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar >>>> from >>> >>> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. >>> >>>> 2nsQuadrant site. I am getting the following error during make clean >>>> all >>>> command: >>> >>> Did you follow the source install instructions here?: >>> >>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant. >>> c >>> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d= >>> D >>> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8h >>> u >>> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8RT >>> u >>> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= >>> >>>> >>>> o pglogical_worker.c >>>> >>>> In file included from pglogical_worker.c:17:0: >>>> >>>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >>>> gssapi/gssapi.h: No such file or directory >>>> >>>> #include <gssapi/gssapi.h> >>>> >>>> ^ >>>> >>>> compilation terminated. >>>> >>>> <builtin>: recipe for target 'pglogical_worker.o' failed >>>> >>>> It appears that gssapi is Kerberos related. Just not exactly sure >>>> what package I am missing and should install on the OS to get this >>>> to compile. Currently I have only one gssapi related package >>>> installed on this system >>>> >>>> S | Name | Summary | >>>> Type >>>> >>>> --+---------------------------+--------------------------------------+-------- >>>> >>>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >>>> package >>>> >>>> Thanks, >>>> >>>> Brian >>>> >>>> /This email and any attachments are only for use by the intended >>>> recipient(s) and may contain legally privileged, confidential, >>>> proprietary or otherwise private information. Any unauthorized use, >>>> reproduction, dissemination, distribution or other disclosure of the >>>> contents of this e-mail or its attachments is strictly prohibited. >>>> If you have received this email in error, please notify the sender >>>> immediately and delete the original. Neither this information block, >>>> the typed name of the sender, nor anything else in this message is >>>> intended to constitute an electronic signature unless a specific >>>> statement to the contrary is included in this message. / >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@aklaver.com >>> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com
I found a repository that offered it and added the repo. https://download.opensuse.org/repositories/home:vjt:ifad/openSUSE_Leap_42.1/home:vjt:ifad.repo Only time will tell if that was a wise decision. I only need to it to get me through my upgrade. Moving all these to RHEL8.1 and Postgres 11.7. Going to use pglogical to try and reduce downtime. Brian -----Original Message----- From: Adrian Klaver <adrian.klaver@aklaver.com> Sent: Tuesday, February 18, 2020 5:00 PM To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 On 2/18/20 1:56 PM, Bellrose, Brian wrote: > Yes, > > S | Name | Summary | Type > --+-----------------------+-------------------------------------------------------------------------+-------- > i | postgresql94 | Basic Clients and Utilities for PostgreSQL | package > i | postgresql94-contrib | Contributed Extensions and Additions to PostgreSQL | package > i | postgresql94-devel | PostgreSQL development header files and libraries | package > i | postgresql94-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | package > i | postgresql94-plpython | The PL/Python Procedural Languages for PostgreSQL | package > i | postgresql94-pltcl | PL/Tcl Procedural Language for PostgreSQL | package > i | postgresql94-server | The Programs Needed to Create and Run a PostgreSQL Server | package > i | postgresql94-test | The test suite for PostgreSQL | packagep Alright that looks good. You may still need to play Whack-a-Mole with devel libraries. I am curious how you got to 9.4.25 via an update, given that this Postgres version was released well past the OS EOL? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 4:41 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > 42.1 > > On 2/18/20 1:22 PM, Bellrose, Brian wrote: >> I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel...Ok, good to know. Seems like that may be the missing link. At least I hope it is the only one. > > Was postgresql94-devel also installed? > >> >> Brian >> >> -----Original Message----- >> From: Adrian Klaver <adrian.klaver@aklaver.com> >> Sent: Tuesday, February 18, 2020 4:19 PM >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >> pgsql-general@lists.postgresql.org >> Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap >> 42.1 >> >> On 2/18/20 12:54 PM, Bellrose, Brian wrote: >>> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. >>> >>> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. >> >> Well on my Leap 15.1 krb5-devel does provide gssapi.h. >> >> How was Postgres installed on the machine? >> >>> >>> Brian >>> >>> -----Original Message----- >>> From: Adrian Klaver <adrian.klaver@aklaver.com> >>> Sent: Tuesday, February 18, 2020 3:49 PM >>> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >>> pgsql-general@lists.postgresql.org >>> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 >>> >>> On 2/18/20 11:39 AM, Bellrose, Brian wrote: >>>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >>>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar >>>> from >>> >>> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. >>> >>>> 2nsQuadrant site. I am getting the following error during make >>>> clean all >>>> command: >>> >>> Did you follow the source install instructions here?: >>> >>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant. >>> c >>> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d >>> = >>> D >>> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8 >>> h >>> u >>> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8R >>> T >>> u >>> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= >>> >>>> >>>> o pglogical_worker.c >>>> >>>> In file included from pglogical_worker.c:17:0: >>>> >>>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >>>> gssapi/gssapi.h: No such file or directory >>>> >>>> #include <gssapi/gssapi.h> >>>> >>>> ^ >>>> >>>> compilation terminated. >>>> >>>> <builtin>: recipe for target 'pglogical_worker.o' failed >>>> >>>> It appears that gssapi is Kerberos related. Just not exactly sure >>>> what package I am missing and should install on the OS to get this >>>> to compile. Currently I have only one gssapi related package >>>> installed on this system >>>> >>>> S | Name | Summary | >>>> Type >>>> >>>> --+---------------------------+--------------------------------------+-------- >>>> >>>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >>>> package >>>> >>>> Thanks, >>>> >>>> Brian >>>> >>>> /This email and any attachments are only for use by the intended >>>> recipient(s) and may contain legally privileged, confidential, >>>> proprietary or otherwise private information. Any unauthorized use, >>>> reproduction, dissemination, distribution or other disclosure of >>>> the contents of this e-mail or its attachments is strictly prohibited. >>>> If you have received this email in error, please notify the sender >>>> immediately and delete the original. Neither this information >>>> block, the typed name of the sender, nor anything else in this >>>> message is intended to constitute an electronic signature unless a >>>> specific statement to the contrary is included in this message. / >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@aklaver.com >>> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message.
On 2/18/20 2:07 PM, Bellrose, Brian wrote: > I found a repository that offered it and added the repo. > https://download.opensuse.org/repositories/home:vjt:ifad/openSUSE_Leap_42.1/home:vjt:ifad.repo > > Only time will tell if that was a wise decision. I only need to it to get me through my upgrade. Moving all these to RHEL8.1 and Postgres 11.7. Going to use pglogical to try and reduce downtime. Well that is interesting: https://build.opensuse.org/project/show/home:vjt:ifad a UN agency: https://www.ifad.org/en/about > > Brian > -- Adrian Klaver adrian.klaver@aklaver.com
Hi, I'm not an OpenSuse expert, but I know a bit about building pglogical... I've been able to compile pglogical on a leap 42.3 docker image In the beginning, I tried to compile pglogical using the very same postgresql packages you were using, but for some reasons, I was consistently receiving linking errors. After some debugging, and packages digging, I found some official SUSE packages for leap 42 So I decided to give them a try. Here is the URL to the repo: https://download.opensuse.org/repositories/openSUSE:/Leap:/42.3:/Update/ports/openSUSE:Leap:42.3:Update.repo Note: here https://download.opensuse.org/repositories/openSUSE:/Leap:/ you can find also repositories for older leap versions. including 42.1 An important suggestion I can give you is: please use a checkout from git instead of using a tar file containing the source code. This because pglogical uses a git submodule for the pglogical_dump component. Here is the link to the 2ndquadrant source repository: https://github.com/2ndQuadrant/pglogical Here is the sequence of action I performed: zypper addrepo https://download.opensuse.org/repositories/openSUSE:/Leap:/42.3:/Update/ports/openSUSE:Leap:42.3:Update.repo zypper install postgresql94-devel openssl-devel libxml2-devel libxslt-devel pam-devel readline-devel zlib-devel krb5-devel e2fsprogs-devel libselinux-devel git vim then I cloned the pglogical git: git clone https://github.com/2ndQuadrant/pglogical.git (note, I used the https link because in docker I was having some issues using the ssh protocol. if you face the same issue update the .gitmodule file inside the repository checkout to use the https link to pglogical_dump https://github.com/2ndQuadrant/pglogical_dump.git ) git checkout REL2_3_0 (this because I wanted to use the latest released code. feel free to use another tag if you wish) git submodule sync git submodule init git submodule update now the repository is up to date. PATH=/usr/lib/postgresql94/bin:$PATH make USE_PGXS=1 clean all PATH=/usr/lib/postgresql94/bin:$PATH make USE_PGXS=1 install (as you can notice the path is different from the documentation as suse uses different default paths from rhel and debian) This worked for me on OpenSUSE leap 42.3, PLEASE let me know if it works for you too. Ciao, Giulio On Tue, 18 Feb 2020 at 23:07, Bellrose, Brian <brian.bellrose@wabtec.com> wrote: > > I found a repository that offered it and added the repo. > https://download.opensuse.org/repositories/home:vjt:ifad/openSUSE_Leap_42.1/home:vjt:ifad.repo > > Only time will tell if that was a wise decision. I only need to it to get me through my upgrade. Moving all these to RHEL8.1 and Postgres 11.7. Going to use pglogical to try and reduce downtime. > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 5:00 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 > > On 2/18/20 1:56 PM, Bellrose, Brian wrote: > > Yes, > > > > S | Name | Summary | Type > > --+-----------------------+-------------------------------------------------------------------------+-------- > > i | postgresql94 | Basic Clients and Utilities for PostgreSQL | package > > i | postgresql94-contrib | Contributed Extensions and Additions to PostgreSQL | package > > i | postgresql94-devel | PostgreSQL development header files and libraries | package > > i | postgresql94-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | package > > i | postgresql94-plpython | The PL/Python Procedural Languages for PostgreSQL | package > > i | postgresql94-pltcl | PL/Tcl Procedural Language for PostgreSQL | package > > i | postgresql94-server | The Programs Needed to Create and Run a PostgreSQL Server | package > > i | postgresql94-test | The test suite for PostgreSQL | packagep > > Alright that looks good. You may still need to play Whack-a-Mole with devel libraries. > > I am curious how you got to 9.4.25 via an update, given that this Postgres version was released well past the OS EOL? > > > > > Brian > > > > -----Original Message----- > > From: Adrian Klaver <adrian.klaver@aklaver.com> > > Sent: Tuesday, February 18, 2020 4:41 PM > > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > > pgsql-general@lists.postgresql.org > > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > > 42.1 > > > > On 2/18/20 1:22 PM, Bellrose, Brian wrote: > >> I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel...Ok, good to know. Seems like that may be the missing link. At least I hope it is the only one. > > > > Was postgresql94-devel also installed? > > > >> > >> Brian > >> > >> -----Original Message----- > >> From: Adrian Klaver <adrian.klaver@aklaver.com> > >> Sent: Tuesday, February 18, 2020 4:19 PM > >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > >> pgsql-general@lists.postgresql.org > >> Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > >> 42.1 > >> > >> On 2/18/20 12:54 PM, Bellrose, Brian wrote: > >>> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to installpglogical is so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical isbest bet. At least I thought it was. > >>> > >>> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. Ithas about three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. > >> > >> Well on my Leap 15.1 krb5-devel does provide gssapi.h. > >> > >> How was Postgres installed on the machine? > >> > >>> > >>> Brian > >>> > >>> -----Original Message----- > >>> From: Adrian Klaver <adrian.klaver@aklaver.com> > >>> Sent: Tuesday, February 18, 2020 3:49 PM > >>> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > >>> pgsql-general@lists.postgresql.org > >>> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 > >>> > >>> On 2/18/20 11:39 AM, Bellrose, Brian wrote: > >>>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. > >>>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar > >>>> from > >>> > >>> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. > >>> > >>>> 2nsQuadrant site. I am getting the following error during make > >>>> clean all > >>>> command: > >>> > >>> Did you follow the source install instructions here?: > >>> > >>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant. > >>> c > >>> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d > >>> = > >>> D > >>> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8 > >>> h > >>> u > >>> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8R > >>> T > >>> u > >>> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= > >>> > >>>> > >>>> o pglogical_worker.c > >>>> > >>>> In file included from pglogical_worker.c:17:0: > >>>> > >>>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: > >>>> gssapi/gssapi.h: No such file or directory > >>>> > >>>> #include <gssapi/gssapi.h> > >>>> > >>>> ^ > >>>> > >>>> compilation terminated. > >>>> > >>>> <builtin>: recipe for target 'pglogical_worker.o' failed > >>>> > >>>> It appears that gssapi is Kerberos related. Just not exactly sure > >>>> what package I am missing and should install on the OS to get this > >>>> to compile. Currently I have only one gssapi related package > >>>> installed on this system > >>>> > >>>> S | Name | Summary | > >>>> Type > >>>> > >>>> --+---------------------------+--------------------------------------+-------- > >>>> > >>>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | > >>>> package > >>>> > >>>> Thanks, > >>>> > >>>> Brian > >>>> > >>>> /This email and any attachments are only for use by the intended > >>>> recipient(s) and may contain legally privileged, confidential, > >>>> proprietary or otherwise private information. Any unauthorized use, > >>>> reproduction, dissemination, distribution or other disclosure of > >>>> the contents of this e-mail or its attachments is strictly prohibited. > >>>> If you have received this email in error, please notify the sender > >>>> immediately and delete the original. Neither this information > >>>> block, the typed name of the sender, nor anything else in this > >>>> message is intended to constitute an electronic signature unless a > >>>> specific statement to the contrary is included in this message. / > >>> > >>> > >>> -- > >>> Adrian Klaver > >>> adrian.klaver@aklaver.com > >>> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > >>> > >> > >> > >> -- > >> Adrian Klaver > >> adrian.klaver@aklaver.com > >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > >> > > > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com > > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. -- Giulio Calacoci - 2ndQuadrant PostgreSQL Training, Services and Support giulio.calacoci@2ndQuadrant.it | www.2ndQuadrant.it
Thanks for the info. I will investigate these steps. Brian -----Original Message----- From: Giulio Calacoci <giulio.calacoci@2ndquadrant.it> Sent: Wednesday, February 19, 2020 9:07 AM To: Bellrose, Brian <brian.bellrose@Wabtec.com> Cc: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Hi, I'm not an OpenSuse expert, but I know a bit about building pglogical... I've been able to compile pglogical on a leap 42.3 docker image In the beginning, I tried to compile pglogical using the very same postgresql packages you were using, but for some reasons,I was consistently receiving linking errors. After some debugging, and packages digging, I found some official SUSE packages for leap 42 So I decided to give them a try. Here is the URL to the repo: https://urldefense.proofpoint.com/v2/url?u=https-3A__download.opensuse.org_repositories_openSUSE-3A_Leap-3A_42.3-3A_Update_ports_openSUSE-3ALeap-3A42.3-3AUpdate.repo&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=Y25bebtRT7XasHdr19dUMsGiUfJVFJ7cyK88MiaC1GE&e= Note: here https://urldefense.proofpoint.com/v2/url?u=https-3A__download.opensuse.org_repositories_openSUSE-3A_Leap-3A_&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=kKXgcuSUbzsujz8MMh0GcsLa5Yy7-Wsj8iI3wH2DD7E&e= you can find also repositories for older leap versions. including 42.1 An important suggestion I can give you is: please use a checkout from git instead of using a tar file containing the sourcecode. This because pglogical uses a git submodule for the pglogical_dump component. Here is the link to the 2ndquadrant source repository: https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_2ndQuadrant_pglogical&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=f6n6qhkn5ychzPwu3NM6-Y7gPkZ0XkHjhmWKg4_MxNI&e= Here is the sequence of action I performed: zypper addrepo https://urldefense.proofpoint.com/v2/url?u=https-3A__download.opensuse.org_repositories_openSUSE-3A_Leap-3A_42.3-3A_Update_ports_openSUSE-3ALeap-3A42.3-3AUpdate.repo&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=Y25bebtRT7XasHdr19dUMsGiUfJVFJ7cyK88MiaC1GE&e= zypper install postgresql94-devel openssl-devel libxml2-devel libxslt-devel pam-devel readline-devel zlib-devel krb5-devele2fsprogs-devel libselinux-devel git vim then I cloned the pglogical git: git clone https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_2ndQuadrant_pglogical.git&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=dGJuVm7AZqax8w_zo12SgV2Sidcm6TmsftvP151tv2I&e= (note, I used the https link because in docker I was having some issues using the ssh protocol. if you face the same issueupdate the .gitmodule file inside the repository checkout to use the https link to pglogical_dump https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_2ndQuadrant_pglogical-5Fdump.git&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=5d5i8InHaQ8ITofwHCD7qwHQ_wvqPvKl9kxLzap3PHA&e= ) git checkout REL2_3_0 (this because I wanted to use the latest released code. feel free to use another tag if you wish)git submodule sync git submodule init git submodule update now the repository is up to date. PATH=/usr/lib/postgresql94/bin:$PATH make USE_PGXS=1 clean all PATH=/usr/lib/postgresql94/bin:$PATH make USE_PGXS=1 install (as you can notice the path is different from the documentation as suse uses different default paths from rhel and debian) This worked for me on OpenSUSE leap 42.3, PLEASE let me know if it works for you too. Ciao, Giulio On Tue, 18 Feb 2020 at 23:07, Bellrose, Brian <brian.bellrose@wabtec.com> wrote: > > I found a repository that offered it and added the repo. > https://urldefense.proofpoint.com/v2/url?u=https-3A__download.opensuse > .org_repositories_home-3Avjt-3Aifad_openSUSE-5FLeap-5F42.1_home-3Avjt- > 3Aifad.repo&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBL > vYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s= > nvwV34wE61EoyLrFp7Y9w1OHj_UHjOVDahM6y3lveT4&e= > > Only time will tell if that was a wise decision. I only need to it to get me through my upgrade. Moving all these to RHEL8.1 and Postgres 11.7. Going to use pglogical to try and reduce downtime. > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 5:00 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > 42.1 > > On 2/18/20 1:56 PM, Bellrose, Brian wrote: > > Yes, > > > > S | Name | Summary | Type > > --+-----------------------+-------------------------------------------------------------------------+-------- > > i | postgresql94 | Basic Clients and Utilities for PostgreSQL | package > > i | postgresql94-contrib | Contributed Extensions and Additions to PostgreSQL | package > > i | postgresql94-devel | PostgreSQL development header files and libraries | package > > i | postgresql94-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | package > > i | postgresql94-plpython | The PL/Python Procedural Languages for PostgreSQL | package > > i | postgresql94-pltcl | PL/Tcl Procedural Language for PostgreSQL | package > > i | postgresql94-server | The Programs Needed to Create and Run a PostgreSQL Server | package > > i | postgresql94-test | The test suite for PostgreSQL | packagep > > Alright that looks good. You may still need to play Whack-a-Mole with devel libraries. > > I am curious how you got to 9.4.25 via an update, given that this Postgres version was released well past the OS EOL? > > > > > Brian > > > > -----Original Message----- > > From: Adrian Klaver <adrian.klaver@aklaver.com> > > Sent: Tuesday, February 18, 2020 4:41 PM > > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > > pgsql-general@lists.postgresql.org > > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > > 42.1 > > > > On 2/18/20 1:22 PM, Bellrose, Brian wrote: > >> I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel...Ok, good to know. Seems like that may be the missing link. At least I hope it is the only one. > > > > Was postgresql94-devel also installed? > > > >> > >> Brian > >> > >> -----Original Message----- > >> From: Adrian Klaver <adrian.klaver@aklaver.com> > >> Sent: Tuesday, February 18, 2020 4:19 PM > >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > >> pgsql-general@lists.postgresql.org > >> Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > >> 42.1 > >> > >> On 2/18/20 12:54 PM, Bellrose, Brian wrote: > >>> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to installpglogical is so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical isbest bet. At least I thought it was. > >>> > >>> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. Ithas about three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. > >> > >> Well on my Leap 15.1 krb5-devel does provide gssapi.h. > >> > >> How was Postgres installed on the machine? > >> > >>> > >>> Brian > >>> > >>> -----Original Message----- > >>> From: Adrian Klaver <adrian.klaver@aklaver.com> > >>> Sent: Tuesday, February 18, 2020 3:49 PM > >>> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > >>> pgsql-general@lists.postgresql.org > >>> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > >>> 42.1 > >>> > >>> On 2/18/20 11:39 AM, Bellrose, Brian wrote: > >>>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. > >>>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar > >>>> from > >>> > >>> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. > >>> > >>>> 2nsQuadrant site. I am getting the following error during make > >>>> clean all > >>>> command: > >>> > >>> Did you follow the source install instructions here?: > >>> > >>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant. > >>> c > >>> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_ > >>> &d > >>> = > >>> D > >>> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7 > >>> C8 > >>> h > >>> u > >>> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp > >>> 8R > >>> T > >>> u > >>> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= > >>> > >>>> > >>>> o pglogical_worker.c > >>>> > >>>> In file included from pglogical_worker.c:17:0: > >>>> > >>>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: > >>>> gssapi/gssapi.h: No such file or directory > >>>> > >>>> #include <gssapi/gssapi.h> > >>>> > >>>> ^ > >>>> > >>>> compilation terminated. > >>>> > >>>> <builtin>: recipe for target 'pglogical_worker.o' failed > >>>> > >>>> It appears that gssapi is Kerberos related. Just not exactly sure > >>>> what package I am missing and should install on the OS to get > >>>> this to compile. Currently I have only one gssapi related package > >>>> installed on this system > >>>> > >>>> S | Name | Summary | > >>>> Type > >>>> > >>>> --+---------------------------+--------------------------------------+-------- > >>>> > >>>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | > >>>> package > >>>> > >>>> Thanks, > >>>> > >>>> Brian > >>>> > >>>> /This email and any attachments are only for use by the intended > >>>> recipient(s) and may contain legally privileged, confidential, > >>>> proprietary or otherwise private information. Any unauthorized > >>>> use, reproduction, dissemination, distribution or other > >>>> disclosure of the contents of this e-mail or its attachments is strictly prohibited. > >>>> If you have received this email in error, please notify the > >>>> sender immediately and delete the original. Neither this > >>>> information block, the typed name of the sender, nor anything > >>>> else in this message is intended to constitute an electronic > >>>> signature unless a specific statement to the contrary is included > >>>> in this message. / > >>> > >>> > >>> -- > >>> Adrian Klaver > >>> adrian.klaver@aklaver.com > >>> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > >>> > >> > >> > >> -- > >> Adrian Klaver > >> adrian.klaver@aklaver.com > >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > >> > > > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com > > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. -- Giulio Calacoci - 2ndQuadrant PostgreSQL Training, Services and Support giulio.calacoci@2ndQuadrant.it | https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.it&d=DwIFaQ&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8huZnWyCI&m=YCSK4nrYEqdAY-8Bp8EfSfbaQsdFk6R8BWkTYwfFz0s&s=bahqvQSYcdOuPYiiDLrkC8skTOmjHE2PvhN-FkIglzE&e= This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message.
FYI, I was able to get it to work with the following steps: # zypper update curl openssl # zypper install gcc openssl-devel krb5-devel # zypper install postgresql94-9.4.25-61.1.x86_64 Then needed to download the 2.2.0 tarball from 2ndQuadrant as the newer versions would not compile: # bzip2 -d pglogical-2.2.0.tar.bz2 # tar -xvf pglogical-2.2.0.tar # cd pglogical-2.2.0/ # export PATH=/usr/lib/postgresql94/bin:$PATH # make USE_PGXS=1 clean all # make USE_PGXS=1 install And I was good after that. Added the pglogical to shared_preload_libraries and started the cluster. Thanks for the help. Brian -----Original Message----- From: Bellrose, Brian Sent: Tuesday, February 18, 2020 5:07 PM To: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org Subject: RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 I found a repository that offered it and added the repo. https://download.opensuse.org/repositories/home:vjt:ifad/openSUSE_Leap_42.1/home:vjt:ifad.repo Only time will tell if that was a wise decision. I only need to it to get me through my upgrade. Moving all these to RHEL8.1 and Postgres 11.7. Going to use pglogical to try and reduce downtime. Brian -----Original Message----- From: Adrian Klaver <adrian.klaver@aklaver.com> Sent: Tuesday, February 18, 2020 5:00 PM To: Bellrose, Brian <brian.bellrose@Wabtec.com>; pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 On 2/18/20 1:56 PM, Bellrose, Brian wrote: > Yes, > > S | Name | Summary | Type > --+-----------------------+-------------------------------------------------------------------------+-------- > i | postgresql94 | Basic Clients and Utilities for PostgreSQL | package > i | postgresql94-contrib | Contributed Extensions and Additions to PostgreSQL | package > i | postgresql94-devel | PostgreSQL development header files and libraries | package > i | postgresql94-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | package > i | postgresql94-plpython | The PL/Python Procedural Languages for PostgreSQL | package > i | postgresql94-pltcl | PL/Tcl Procedural Language for PostgreSQL | package > i | postgresql94-server | The Programs Needed to Create and Run a PostgreSQL Server | package > i | postgresql94-test | The test suite for PostgreSQL | packagep Alright that looks good. You may still need to play Whack-a-Mole with devel libraries. I am curious how you got to 9.4.25 via an update, given that this Postgres version was released well past the OS EOL? > > Brian > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@aklaver.com> > Sent: Tuesday, February 18, 2020 4:41 PM > To: Bellrose, Brian <brian.bellrose@Wabtec.com>; > pgsql-general@lists.postgresql.org > Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap > 42.1 > > On 2/18/20 1:22 PM, Bellrose, Brian wrote: >> I used zypper to install postgres. Postgres is fine... Running 9.4.25 that I updated today. So you have krb5-devel...Ok, good to know. Seems like that may be the missing link. At least I hope it is the only one. > > Was postgresql94-devel also installed? > >> >> Brian >> >> -----Original Message----- >> From: Adrian Klaver <adrian.klaver@aklaver.com> >> Sent: Tuesday, February 18, 2020 4:19 PM >> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >> pgsql-general@lists.postgresql.org >> Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap >> 42.1 >> >> On 2/18/20 12:54 PM, Bellrose, Brian wrote: >>> Yes, I understand that this OS is very old. I can't help that. I was handed this. The reason I am trying to install pglogicalis so that I can upgrade and get off this OS. Our requirements are for limited downtime so pglocical is best bet.At least I thought it was. >>> >>> Yes, I followed the source install doc. Can't be really called an install doc when all it states is run a make. It hasabout three sentences that encompass their complete install instructions from source. No documentation on package dependenciesor anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten fartherwith 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clearthough. >> >> Well on my Leap 15.1 krb5-devel does provide gssapi.h. >> >> How was Postgres installed on the machine? >> >>> >>> Brian >>> >>> -----Original Message----- >>> From: Adrian Klaver <adrian.klaver@aklaver.com> >>> Sent: Tuesday, February 18, 2020 3:49 PM >>> To: Bellrose, Brian <brian.bellrose@Wabtec.com>; >>> pgsql-general@lists.postgresql.org >>> Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 >>> >>> On 2/18/20 11:39 AM, Bellrose, Brian wrote: >>>> In the process of trying to use pglogical to upgrade from 9.4 to 11.7. >>>> Current OS is openSUSE Leap 42.1. Downloaded pglogical-2.2.0.tar >>>> from >>> >>> FYI 42.1 is coming up on 3 years past EOL so you might have general issues with out of date libraries. >>> >>>> 2nsQuadrant site. I am getting the following error during make >>>> clean all >>>> command: >>> >>> Did you follow the source install instructions here?: >>> >>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant. >>> c >>> om_en_resources_pglogical_pglogical-2Dinstallation-2Dinstructions_&d >>> = >>> D >>> wID-g&c=pG3N8eJDEvizGbIy8hw-0w&r=Avd8jJaAOeUVJ3AmVEriBLvYqiK8qqaP7C8 >>> h >>> u >>> ZnWyCI&m=1vh2nbBIrcqphzYV4i690_hEEZuRS71Da5SClwjBbOw&s=1O6j3zKQdkp8R >>> T >>> u >>> GPAQPB44lQi_IV9goSuWDjl0pnqI&e= >>> >>>> >>>> o pglogical_worker.c >>>> >>>> In file included from pglogical_worker.c:17:0: >>>> >>>> /usr/include/pgsql/server/libpq/libpq-be.h:36:27: fatal error: >>>> gssapi/gssapi.h: No such file or directory >>>> >>>> #include <gssapi/gssapi.h> >>>> >>>> ^ >>>> >>>> compilation terminated. >>>> >>>> <builtin>: recipe for target 'pglogical_worker.o' failed >>>> >>>> It appears that gssapi is Kerberos related. Just not exactly sure >>>> what package I am missing and should install on the OS to get this >>>> to compile. Currently I have only one gssapi related package >>>> installed on this system >>>> >>>> S | Name | Summary | >>>> Type >>>> >>>> --+---------------------------+--------------------------------------+-------- >>>> >>>> i | cyrus-sasl-gssapi | Plugin for the GSSAPI SASL mechanism | >>>> package >>>> >>>> Thanks, >>>> >>>> Brian >>>> >>>> /This email and any attachments are only for use by the intended >>>> recipient(s) and may contain legally privileged, confidential, >>>> proprietary or otherwise private information. Any unauthorized use, >>>> reproduction, dissemination, distribution or other disclosure of >>>> the contents of this e-mail or its attachments is strictly prohibited. >>>> If you have received this email in error, please notify the sender >>>> immediately and delete the original. Neither this information >>>> block, the typed name of the sender, nor anything else in this >>>> message is intended to constitute an electronic signature unless a >>>> specific statement to the contrary is included in this message. / >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@aklaver.com >>> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com >> This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message. > -- Adrian Klaver adrian.klaver@aklaver.com This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential,proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distributionor other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have receivedthis email in error, please notify the sender immediately and delete the original. Neither this information block,the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature unlessa specific statement to the contrary is included in this message.