[pgpool-general: 2315] Re: pgpool-recovery.so ; relocation error; referenced symbol not found

[Ethan Shin]

In the mean time, I have built the Postgres 9.1 with the gcc on the Solaris
box and when I tried again to insert the extensions(pgpool-regclass.sql and
pgpool-recovery.sql)
The error for pgpool-regclass.sql is differernt.  see below:

bash-3.2$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1
psql:./pgpool-regclass.sql:4: ERROR:  incompatible library
"/usr/local/pgsql/lib/pgpool-regclass.so": missing magic block
HINT:  Extension libraries are required to use the PG_MODULE_MAGIC macro.
bash-3.2$

Thanks,
Ethan

On Fri, Nov 29, 2013 at 6:40 PM, Ethan Shin <easonkie2nd at gmail.com> wrote:

> Hi Nozomi,
> Thanks a lot for picking this up.
> I can not find the ld.so.conf under /etc nor ldconfig under /sbin
>
> I am using Solaris 10 by the way.
> Could you please advise?
>
> Regards,
> Ethan
>
>
> On Fri, Nov 29, 2013 at 6:37 PM, Ethan Shin <easonkie2nd at gmail.com> wrote:
>
>> Hi Nozomi,
>> Thanks a lot for picking this up.
>> I can not find the ld.so.conf under /etc nor ldconfig under /sbin
>>
>> I am using Solaris 10 by the way.
>> Could you please advise?
>>
>> Regards,
>> Ethan
>>
>>
>> On Fri, Nov 29, 2013 at 3:03 PM, Nozomi Anzai <anzai at sraoss.co.jp> wrote:
>>
>>> Hi,
>>>
>>> Could you try after adding the library path to PostgresQL into
>>> ld.so.conf?
>>>
>>> ex.)
>>> # vi /etc/ld.so.conf
>>> include ld.so.conf.d/*.conf
>>> /postgres/9.1-pgdg/lib
>>>
>>> # /sbin/ldconfig
>>>
>>> > Hi Gentlemen,
>>> > I am trying to execute the pgpool-recovery.sql but being prompted
>>> below could not load lib pgpool-recovery.so error.
>>> > Can you please help me to address this?
>>> >
>>> >
>>> >
>>> > bash-3.2$ psql -f ./pgpool-recovery.sql template1
>>> psql:./pgpool-recovery.sql:4: ERROR:  could not load library
>>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres: fatal:
>>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so: symbol
>>> DirectFunctionCall1: referenced symbol not found
>>> > psql:./pgpool-recovery.sql:9: ERROR:  could not load library
>>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres: fatal:
>>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so: symbol
>>> DirectFunctionCall1: referenced symbol not found
>>> > psql:./pgpool-recovery.sql:14: ERROR:  could not load library
>>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres: fatal:
>>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so: symbol
>>> DirectFunctionCall1: referenced symbol not found
>>> >
>>> >
>>> > bash-3.2$ ldd -d pgpool-recovery.so
>>> >        symbol not found: textout               (./pgpool-recovery.so)
>>> >        symbol not found: textin                (./pgpool-recovery.so)
>>> >        symbol not found: DataDir               (./pgpool-recovery.so)
>>> >        symbol not found: InterruptPending
>>>  (./pgpool-recovery.so)
>>> >
>>> >
>>> > Thanks very much in advance!
>>> > Regards,
>>> > Ethan
>>> > _______________________________________________
>>> > pgpool-general mailing list
>>> > pgpool-general at pgpool.net
>>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>
>>>
>>> --
>>> Nozomi Anzai
>>> SRA OSS, Inc. Japan
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131129/ce326e7a/attachment.html>