<div dir="ltr">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)<div>The error for pgpool-regclass.sql is differernt. see below:</div>
<div><br></div><div><div><div>bash-3.2$ /usr/local/pgsql/bin/psql -f ./pgpool-regclass.sql template1</div>
<div>psql:./pgpool-regclass.sql:4: ERROR: incompatible library "/usr/local/pgsql/lib/pgpool-regclass.so": missing magic block</div><div>HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.</div>
<div>bash-3.2$</div></div><div><br></div></div><div class="gmail_extra">Thanks, </div><div class="gmail_extra">Ethan<br><br><div class="gmail_quote">On Fri, Nov 29, 2013 at 6:40 PM, Ethan Shin <span dir="ltr"><<a href="mailto:easonkie2nd@gmail.com" target="_blank">easonkie2nd@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im HOEnZb"><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">Hi Nozomi, </span><div style="font-family:arial,sans-serif;font-size:13px">
Thanks a lot for picking this up. </div><div style="font-family:arial,sans-serif;font-size:13px">
I can not find the ld.so.conf under /etc nor ldconfig under /sbin</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">I am using Solaris 10 by the way. </div>
<div style="font-family:arial,sans-serif;font-size:13px">Could you please advise?</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Regards, </div>
<div style="font-family:arial,sans-serif;font-size:13px">Ethan</div></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Nov 29, 2013 at 6:37 PM, Ethan Shin <span dir="ltr"><<a href="mailto:easonkie2nd@gmail.com" target="_blank">easonkie2nd@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Nozomi, <div>Thanks a lot for picking this up. </div><div>I can not find the ld.so.conf under /etc nor ldconfig under /sbin</div>
<div><br></div><div>I am using Solaris 10 by the way. </div><div>Could you please advise?</div>
<div><br></div><div>Regards, </div><span><font color="#888888"><div>Ethan</div></font></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Nov 29, 2013 at 3:03 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>
<br>
Could you try after adding the library path to PostgresQL into 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>
<div><div><br>
> Hi Gentlemen,<br>
> I am trying to execute the pgpool-recovery.sql but being prompted 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 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<br>
> 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<br>
> 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<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 (./pgpool-recovery.so)<br>
><br>
><br>
> Thanks very much in advance!<br>
> Regards,<br>
> Ethan<br>
</div></div>> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net" target="_blank">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>
<span><font color="#888888"><br>
<br>
--<br>
Nozomi Anzai<br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">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>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div></div>