[pgpool-general: 2259] Re: pgpool-regclass

[Tatsuo Ishii]

> Sorry, what I meant was are there differences in the regcode code in pgpool
> build for 9.2 and pgpool built for 9.0?

I don't know what you mean "code". If it's the source code, the latest
pgpool-regclass.c is compatible with PostgreSQL 9.0 and 9.2.

> If not I could copy the .so file and run the SQL to activate the function
> in each of my databases, correct?

You need to re-create .so.

> Unfortunately I don't know enough about RPM or APT to answer those
> questions either.

No problem. Thanks for attention.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Cheers,
> 
> 
> James Sewell,
> PostgreSQL Team Lead / Solutions Architect
> ______________________________________
> 
> 
>  Level 2, 50 Queen St, Melbourne VIC 3000
> 
> *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
> 
> 
> 
> On Thu, Nov 7, 2013 at 2:53 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> > Thank you.
>> >
>> > I assume I can't install 9.2 for a 9.0 database?
>>
>> Right, unless you migrate 9.0 database to 9.2.
>>
>> > Can I copy the regclass files from 9.2 back to my 9.1 install?
>>
>> No, you cann't. To make regclass work, you not only copy
>> pgpool_regclass.so file, but you register the function to the
>> PostgreSQL system catalog or create extention into the database.
>>
>> As I said the pgpool rpm targets PGDG 9.2 (i.e. it expects
>> /usr/pgsql-9.2 does exist). However, it seems possible for the rpm to
>> search for PostgreSQL installation by using pg_config. And if so, the
>> rpm can work with various versions of PostgreSQL (even works with
>> PostrgeSQL installed from source code). I'm not too familiar with RPM,
>> so this is an unusual way or not. Anybody opinions?
>>
>> regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > Cheers,
>> >
>> >
>> > James Sewell,
>> > PostgreSQL Team Lead / Solutions Architect
>> > ______________________________________
>> >
>> >
>> >  Level 2, 50 Queen St, Melbourne VIC 3000
>> >
>> > *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
>> >
>> >
>> >
>> > On Thu, Nov 7, 2013 at 2:37 PM, Tatsuo Ishii <ishii at postgresql.org>
>> wrote:
>> >
>> >> PGDG does not include pgpool-regclass.
>> >>
>> >> pgpool-II RPM
>> >> http://www.pgpool.net/mediawiki/index.php/Downloads
>> >> does include that. However at this point it is tragetting PGDG 9.2.
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese: http://www.sraoss.co.jp
>> >>
>> >> > Hey All,
>> >> >
>> >> > Pgpool-regclass does not seem to come with the PGDG 9.0 packages
>> >> (although
>> >> > it looks like it comes with the 9.1 packages).
>> >> >
>> >> > I'm running PostgreSQL 9.0. What is the safest method of adding
>> >> > pgpool-regclass to my system?
>> >> >
>> >> > Cheers,
>> >> >
>> >> > James Sewell,
>> >> > PostgreSQL Team Lead / Solutions Architect
>> >> > ______________________________________
>> >> >
>> >> >
>> >> >  Level 2, 50 Queen St, Melbourne VIC 3000
>> >> >
>> >> > *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
>> >> >
>> >> > --
>> >> >
>> >> >
>> >> > ------------------------------
>> >> > 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.
>> >>
>> >
>> > --
>> >
>> >
>> > ------------------------------
>> > 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.
>>
> 
> -- 
> 
> 
> ------------------------------
> 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.