RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1

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(dot)klaver(at)aklaver(dot)com>
Sent: Tuesday, February 18, 2020 4:19 PM
To: Bellrose, Brian <brian(dot)bellrose(at)Wabtec(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)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 pglogical is 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 about three sentences that encompass their complete install instructions from source. No documentation on package dependencies or anything else or even what package do download. I tried 2.2.1 first and it did not work. I have gotten farther with 2.2.0, but I am getting what appears to be dependency errors. Might need to install krb5-devel. Not 100% clear though.

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(dot)klaver(at)aklaver(dot)com>
> Sent: Tuesday, February 18, 2020 3:49 PM
> To: Bellrose, Brian <brian(dot)bellrose(at)Wabtec(dot)com>;
> pgsql-general(at)lists(dot)postgresql(dot)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(dot)klaver(at)aklaver(dot)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, 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(dot)klaver(at)aklaver(dot)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, 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.