<div dir="ltr">Sorry, what I meant was are there differences in the regcode code in pgpool build for 9.2 and pgpool built for 9.0?<div><br></div><div>If not I could copy the .so file and run the SQL to activate the function in each of my databases, correct?</div>
<div><br></div><div>Unfortunately I don't know enough about RPM or APT to answer those questions either.</div><div><br></div><div>Cheers,</div></div><div class="gmail_extra"><br clear="all"><div><div style="color:#b8276a;font:bold 14px Arial,Helvetica,sans-serif">
<br>
<span style="color:#323b62">James Sewell,</span><br>
<span style="color:#a9a9a9"><span style="font:12px Arial,Helvetica,sans-serif">PostgreSQL Team Lead / Solutions Architect </span></span><br>
<span style="color:#a9a9a9">______________________________________</span><br>
</div>
<img alt="" src="http://www.lisasoft.com/sites/lisasoft/files/u1/logo1.jpg" style="margin:0px;width:153px;height:50px"><br>
<div style="font:normal 12px/20px Arial,Helvetica,sans-serif;color:#404040;margin:0">
<span style="color:#a9a9a9">Level 2, 50 Queen St, Melbourne VIC 3000</span><br>
<br>
<strong>P </strong><span style="color:#a9a9a9"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8000</span></span><span style="color:rgb(169,169,169)"> </span><strong> </strong><span style="color:rgb(50,59,98)"><span style="width:15px;display:inline-block"><strong>W</strong></span></span> <a style="color:rgb(64,64,64);margin:2px 0px;text-decoration:none"><span style="color:#a9a9a9">www.lisasoft.com</span></a> <span style="color:rgb(50,59,98)"><span style="width:15px;display:inline-block"><strong>F </strong></span></span><span style="color:#a9a9a9"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8099</span></span></div>
<div style="padding-top:8px">
</div></div>
<br><br><div class="gmail_quote">On Thu, Nov 7, 2013 at 2:53 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</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">> Thank you.<br>
><br>
> I assume I can't install 9.2 for a 9.0 database?<br>
<br>
</div>Right, unless you migrate 9.0 database to 9.2.<br>
<div class="im"><br>
> Can I copy the regclass files from 9.2 back to my 9.1 install?<br>
<br>
</div>No, you cann't. To make regclass work, you not only copy<br>
pgpool_regclass.so file, but you register the function to the<br>
PostgreSQL system catalog or create extention into the database.<br>
<br>
As I said the pgpool rpm targets PGDG 9.2 (i.e. it expects<br>
/usr/pgsql-9.2 does exist). However, it seems possible for the rpm to<br>
search for PostgreSQL installation by using pg_config. And if so, the<br>
rpm can work with various versions of PostgreSQL (even works with<br>
PostrgeSQL installed from source code). I'm not too familiar with RPM,<br>
so this is an unusual way or not. Anybody opinions?<br>
<br>
regards,<br>
<div class="im HOEnZb">--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
</div><div class="HOEnZb"><div class="h5">> Cheers,<br>
><br>
><br>
> James Sewell,<br>
> PostgreSQL Team Lead / Solutions Architect<br>
> ______________________________________<br>
><br>
><br>
> Level 2, 50 Queen St, Melbourne VIC 3000<br>
><br>
> *P *<a href="tel:%28%2B61%29%203%208370%208000" value="+61383708000">(+61) 3 8370 8000</a> *W* <a href="http://www.lisasoft.com" target="_blank">www.lisasoft.com</a> *F *<a href="tel:%28%2B61%29%203%208370%208099" value="+61383708099">(+61) 3 8370 8099</a><br>
><br>
><br>
><br>
> On Thu, Nov 7, 2013 at 2:37 PM, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> wrote:<br>
><br>
>> PGDG does not include pgpool-regclass.<br>
>><br>
>> pgpool-II RPM<br>
>> <a href="http://www.pgpool.net/mediawiki/index.php/Downloads" target="_blank">http://www.pgpool.net/mediawiki/index.php/Downloads</a><br>
>> does include that. However at this point it is tragetting PGDG 9.2.<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>> > Hey All,<br>
>> ><br>
>> > Pgpool-regclass does not seem to come with the PGDG 9.0 packages<br>
>> (although<br>
>> > it looks like it comes with the 9.1 packages).<br>
>> ><br>
>> > I'm running PostgreSQL 9.0. What is the safest method of adding<br>
>> > pgpool-regclass to my system?<br>
>> ><br>
>> > Cheers,<br>
>> ><br>
>> > James Sewell,<br>
>> > PostgreSQL Team Lead / Solutions Architect<br>
>> > ______________________________________<br>
>> ><br>
>> ><br>
>> > Level 2, 50 Queen St, Melbourne VIC 3000<br>
>> ><br>
>> > *P *<a href="tel:%28%2B61%29%203%208370%208000" value="+61383708000">(+61) 3 8370 8000</a> *W* <a href="http://www.lisasoft.com" target="_blank">www.lisasoft.com</a> *F *<a href="tel:%28%2B61%29%203%208370%208099" value="+61383708099">(+61) 3 8370 8099</a><br>
>> ><br>
>> > --<br>
>> ><br>
>> ><br>
>> > ------------------------------<br>
>> > The contents of this email are confidential and may be subject to legal<br>
>> or<br>
>> > professional privilege and copyright. No representation is made that this<br>
>> > email is free of viruses or other defects. If you have received this<br>
>> > communication in error, you may not copy or distribute any part of it or<br>
>> > otherwise disclose its contents to anyone. Please advise the sender of<br>
>> your<br>
>> > incorrect receipt of this correspondence.<br>
>><br>
><br>
> --<br>
><br>
><br>
> ------------------------------<br>
> The contents of this email are confidential and may be subject to legal or<br>
> professional privilege and copyright. No representation is made that this<br>
> email is free of viruses or other defects. If you have received this<br>
> communication in error, you may not copy or distribute any part of it or<br>
> otherwise disclose its contents to anyone. Please advise the sender of your<br>
> incorrect receipt of this correspondence.<br>
</div></div></blockquote></div><br></div>
<br>
<p><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:14.545454025268555px;background-color:rgb(255,255,255)"><hr><font size="1" color="Gray" face="Arial">The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.</font></div></p>