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

[James Sewell]

Hello,

So on my system (Ubuntu PostgreSQL 9.0) there is no problem installing the
PGPG92 PGPool package rather than the PGDG90 PGPool package?

This will resolve my problem as regclass is included.

Cheers,
James.





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 Fri, Nov 8, 2013 at 10:47 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

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

-- 


------------------------------
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131108/e2f40227/attachment.html>