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

[Nozomi Anzai]

Hi,

> > 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?

Sorry, my answer was for CentOS/RHEL, not for Solaris. Could you try with
"crle" command?

> 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.

I think this message also means pgpool cannot find PostgreSQL libraries
and headers in /usr/local/pgsql or use ones in /postgres/9.1-pgdg/ (it is
wrong now).
Could you try to install pgpool again like this?

$ ./configure --with-pgsql=/usr/local/pgsql
$ make
$ make install

$ cd sql/pgpool-recovery/
$ make install
$ /usr/local/pgsql/bin/initdb -D {dirname}
$ /usr/local/pgsql/bin/pg_ctl start -D {dirname}
$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1

> 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 ¡÷ 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 ¡÷ 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 ¡÷ 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 ¡÷ pgpool.net
> >>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> >>>
> >>>
> >>> --
> >>> Nozomi Anzai
> >>> SRA OSS, Inc. Japan
> >>> _______________________________________________
> >>> pgpool-general mailing list
> >>> pgpool-general ¡÷ pgpool.net
> >>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> >>>
> >>
> >>
> >


-- 
Nozomi Anzai
SRA OSS, Inc. Japan