<div dir="ltr">Hi Nozomi, <div>I have found the cause which is the lower version pg_config came with Solaris. </div><div>Though I have modified the make file to use the V9.1 pg_config but during make stage it still used the older one. </div>
<div>Now the problem is solved. </div><div><br></div><div>Thanks a lot for your help. </div><div>Cheers, </div><div>E</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Dec 2, 2013 at 5:33 PM, Nozomi Anzai <span dir="ltr"><<a href="mailto:anzai@sraoss.co.jp" target="_blank">anzai@sraoss.co.jp</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<div class="im"><br>
> > I can not find the ld.so.conf under /etc nor ldconfig under /sbin<br>
> ><br>
> > I am using Solaris 10 by the way.<br>
> > Could you please advise?<br>
<br>
</div>Sorry, my answer was for CentOS/RHEL, not for Solaris. Could you try with<br>
"crle" command?<br>
<div class="im"><br>
> bash-3.2$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1<br>
> psql:./pgpool-regclass.sql:4: ERROR: incompatible library<br>
> "/usr/local/pgsql/lib/pgpool-regclass.so": missing magic block<br>
> HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.<br>
<br>
</div>I think this message also means pgpool cannot find PostgreSQL libraries<br>
and headers in /usr/local/pgsql or use ones in /postgres/9.1-pgdg/ (it is<br>
wrong now).<br>
Could you try to install pgpool again like this?<br>
<br>
$ ./configure --with-pgsql=/usr/local/pgsql<br>
$ make<br>
$ make install<br>
<br>
$ cd sql/pgpool-recovery/<br>
$ make install<br>
$ /usr/local/pgsql/bin/initdb -D {dirname}<br>
$ /usr/local/pgsql/bin/pg_ctl start -D {dirname}<br>
$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1<br>
<div class="HOEnZb"><div class="h5"><br>
> In the mean time, I have built the Postgres 9.1 with the gcc on the Solaris<br>
> box and when I tried again to insert the extensions(pgpool-regclass.sql and<br>
> pgpool-recovery.sql)<br>
> The error for pgpool-regclass.sql is differernt. see below:<br>
><br>
> bash-3.2$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1<br>
> psql:./pgpool-regclass.sql:4: ERROR: incompatible library<br>
> "/usr/local/pgsql/lib/pgpool-regclass.so": missing magic block<br>
> HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.<br>
> bash-3.2$<br>
><br>
> Thanks,<br>
> Ethan<br>
><br>
> On Fri, Nov 29, 2013 at 6:40 PM, Ethan Shin <<a href="mailto:easonkie2nd@gmail.com">easonkie2nd@gmail.com</a>> wrote:<br>
><br>
> > Hi Nozomi,<br>
> > Thanks a lot for picking this up.<br>
> > I can not find the ld.so.conf under /etc nor ldconfig under /sbin<br>
> ><br>
> > I am using Solaris 10 by the way.<br>
> > Could you please advise?<br>
> ><br>
> > Regards,<br>
> > Ethan<br>
> ><br>
> ><br>
> > On Fri, Nov 29, 2013 at 6:37 PM, Ethan Shin <<a href="mailto:easonkie2nd@gmail.com">easonkie2nd@gmail.com</a>> wrote:<br>
> ><br>
> >> Hi Nozomi,<br>
> >> Thanks a lot for picking this up.<br>
> >> I can not find the ld.so.conf under /etc nor ldconfig under /sbin<br>
> >><br>
> >> I am using Solaris 10 by the way.<br>
> >> Could you please advise?<br>
> >><br>
> >> Regards,<br>
> >> Ethan<br>
> >><br>
> >><br>
> >> On Fri, Nov 29, 2013 at 3:03 PM, Nozomi Anzai <<a href="mailto:anzai@sraoss.co.jp">anzai@sraoss.co.jp</a>> wrote:<br>
> >><br>
> >>> Hi,<br>
> >>><br>
> >>> Could you try after adding the library path to PostgresQL into<br>
> >>> ld.so.conf?<br>
> >>><br>
> >>> ex.)<br>
> >>> # vi /etc/ld.so.conf<br>
> >>> include ld.so.conf.d/*.conf<br>
> >>> /postgres/9.1-pgdg/lib<br>
> >>><br>
> >>> # /sbin/ldconfig<br>
> >>><br>
> >>> > Hi Gentlemen,<br>
> >>> > I am trying to execute the pgpool-recovery.sql but being prompted<br>
> >>> below could not load lib pgpool-recovery.so error.<br>
> >>> > Can you please help me to address this?<br>
> >>> ><br>
> >>> ><br>
> >>> ><br>
> >>> > bash-3.2$ psql -f ./pgpool-recovery.sql template1<br>
> >>> psql:./pgpool-recovery.sql:4: ERROR: could not load library<br>
> >>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres: fatal:<br>
> >>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so: symbol<br>
> >>> DirectFunctionCall1: referenced symbol not found<br>
> >>> > psql:./pgpool-recovery.sql:9: ERROR: could not load library<br>
> >>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres: fatal:<br>
> >>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so: symbol<br>
> >>> DirectFunctionCall1: referenced symbol not found<br>
> >>> > psql:./pgpool-recovery.sql:14: ERROR: could not load library<br>
> >>> "/postgres/9.1-pgdg/lib/pgpool-recovery.so": ld.so.1: postgres: fatal:<br>
> >>> relocation error: file /postgres/9.1-pgdg/lib/pgpool-recovery.so: symbol<br>
> >>> DirectFunctionCall1: referenced symbol not found<br>
> >>> ><br>
> >>> ><br>
> >>> > bash-3.2$ ldd -d pgpool-recovery.so<br>
> >>> > symbol not found: textout (./pgpool-recovery.so)<br>
> >>> > symbol not found: textin (./pgpool-recovery.so)<br>
> >>> > symbol not found: DataDir (./pgpool-recovery.so)<br>
> >>> > symbol not found: InterruptPending<br>
> >>> (./pgpool-recovery.so)<br>
> >>> ><br>
> >>> ><br>
> >>> > Thanks very much in advance!<br>
> >>> > Regards,<br>
> >>> > Ethan<br>
> >>> > _______________________________________________<br>
> >>> > pgpool-general mailing list<br>
> >>> > <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> >>> > <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
> >>><br>
> >>><br>
> >>> --<br>
> >>> Nozomi Anzai<br>
> >>> SRA OSS, Inc. Japan<br>
> >>> _______________________________________________<br>
> >>> pgpool-general mailing list<br>
> >>> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> >>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
> >>><br>
> >><br>
> >><br>
> ><br>
<br>
<br>
--<br>
Nozomi Anzai<br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div></div></blockquote></div><br></div>