Обсуждение: Now using "yum.postgresql.org - RE: EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer?

Поиск
Список
Период
Сортировка
I decided to try your suggestion:
        "Further I suggest you instead use yum.postgresql.org to get proper packages."
 
I confirmed they are installed via "yum list" and located the core postgres files but not the extensions
I can't find out where the plpython/plperl objects are.
How do I locate them on the filesystem?
Also, How do I determine which version of python, perl, (tcl) are supported with these language extensions?
 
More details below
 
Thanks,
STeve
 
I'm new to yum and rpm, so this has been a leap for me.
However I found my distribution type, and  the instructions at http://www.postgresql.org/download/linux/redhat/
I installed the "repository rpm" (I believe) and then successfully executed:
        yum install postgresql94-server postgresql94-contrib
 
I can see in a "yum list" the postgres files: 
How do I know where they were installed to?
I found the core postgres because we have 9.3 and I know where those files are
We have /usr/pgsql-9.4
ls -l
drwxr-xr-x 2 root root 4096 Jun 17 14:49 bin
drwxr-xr-x 2 root root 4096 Jun 17 14:49 lib
drwxr-xr-x 7 root root 4096 Jun 17 14:49 share
 
The yum list shows that pl- perl, python, tcl  were installed, but I can't find them:
postgresql94.x86_64                     9.4.4-1PGDG.rhel6                @pgdg94
postgresql94-contrib.x86_64             9.4.4-1PGDG.rhel6                @pgdg94
postgresql94-libs.x86_64                9.4.4-1PGDG.rhel6                @pgdg94
postgresql94-server.x86_64              9.4.4-1PGDG.rhel6                @pgdg94
postgresql94-debuginfo.x86_64           9.4.4-1PGDG.rhel6                pgdg94
postgresql94-devel.x86_64               9.4.4-1PGDG.rhel6                pgdg94
postgresql94-docs.x86_64                9.4.4-1PGDG.rhel6                pgdg94
postgresql94-jdbc.x86_64                9.3.1101-1PGDG.rhel6             pgdg94
postgresql94-jdbc-debuginfo.x86_64      9.3.1101-1PGDG.rhel6             pgdg94
postgresql94-odbc.x86_64                09.03.0400-1PGDG.rhel6           pgdg94
postgresql94-odbc-debuginfo.x86_64      09.03.0400-1PGDG.rhel6           pgdg94
postgresql94-plperl.x86_64              9.4.4-1PGDG.rhel6                pgdg94
postgresql94-plpython.x86_64            9.4.4-1PGDG.rhel6                pgdg94
postgresql94-pltcl.x86_64               9.4.4-1PGDG.rhel6                pgdg94
postgresql94-python.x86_64              4.1.1-1PGDG.rhel6                pgdg94
postgresql94-python-debuginfo.x86_64    4.1.1-1PGDG.rhel6                pgdg94
postgresql94-test.x86_64                9.4.4-1PGDG.rhel6                pgdg94
 
 
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Stephen Tahmosh
Sent: Wednesday, June 17, 2015 2:00 PM
To: Joshua D. Drake; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer?
 
Thank you,
I'll consider this closed and talk with the EnterpriseDB folks.
 
STeve
 
STeve
 
-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Wednesday, June 17, 2015 1:48 PM
To: Stephen Tahmosh; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer?
 
 
On 06/17/2015 08:37 AM, Stephen Tahmosh wrote:
> Hi,
>
> I am trying to locate the EnterpriseDB Language Pack (pl/pythonu,
> pl/perlu)
>
> I found the PostgreSql Installer (postgresql-9.4.4-1-linux-x64.run) at
> enterprisedb.com, and was successful in running it
>
> However, I thought the Language Pack was part of the installer, and it
> seems it is not
>
> I found the README for the language pack
>
> but cannot find the Installer.
>
 
 
You should be asking Enterprisedb about their version of PostgreSQL, not PostgreSQL.Org. Further I suggest you instead use yum.postgresql.org to get proper packages.
 
JD
 
--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564 PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you.
THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message without making any copies and notify the sender so that we may correct our records. Thank you.
 
 
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
 
THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message without making any copies and notify the sender so that we may correct our records. Thank you.
Hi,

On Wed, 2015-06-17 at 19:26 +0000, Stephen Tahmosh wrote:
> I confirmed they are installed via "yum list" and located the core
> postgres files but not the extensions
> I can't find out where the plpython/plperl objects are.

yum search postgresql94

would give you names of all packages for PostgreSQL 9.4.

so

yum install postgresql94-plpython postgresql94-plperl

would do the trick.

> Also, How do I determine which version of python, perl, (tcl) are
> supported with these language extensions?

The versions supplied by the OS -- that is why using RPMs is a bit
better choice.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




Thanks, this is very helpful.
I have one more error:
Two questions
1.  Do I need postgresql94-python.x86_64?
2.  If so, how do I get "mx" installed first?

Thanks again!
Steve


I tried to install  the "python" associated with postgresql and got a "dependency on "mx""
I couldn't determine what "mx" was
The error
--> Processing Dependency: mx for package: postgresql94-python-4.1.1-1PGDG.rhel6.x86_64
--> Finished Dependency Resolution
Error: Package: postgresql94-python-4.1.1-1PGDG.rhel6.x86_64 (pgdg94)
           Requires: mx
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest


I found plpython, tcl, and perl, and installed successfully in /usr/pgsql-9.4/share/extension

As you suggested,  yum search postgresql94 got me the list of available packages

STeve

-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org]
Sent: Wednesday, June 17, 2015 3:30 PM
To: Stephen Tahmosh
Cc: Joshua D. Drake; pgsql-admin@postgresql.org
Subject: Re: Now using "yum.postgresql.org - RE: [ADMIN] EnterpriseDB: PostgreSql 9.4 Where is the Language Pack
Installer?


Hi,

On Wed, 2015-06-17 at 19:26 +0000, Stephen Tahmosh wrote:
> I confirmed they are installed via "yum list" and located the core
> postgres files but not the extensions I can't find out where the
> plpython/plperl objects are.

yum search postgresql94

would give you names of all packages for PostgreSQL 9.4.

so

yum install postgresql94-plpython postgresql94-plperl

would do the trick.

> Also, How do I determine which version of python, perl, (tcl) are
> supported with these language extensions?

The versions supplied by the OS -- that is why using RPMs is a bit better choice.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat
CertifiedEngineer
 
Twitter: @DevrimGunduz , @DevrimGunduzTR


THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY
CONTAININFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the
intendedrecipient, your use of this message for any purpose is strictly prohibited. If you have received this
communicationin error, please delete the message without making any copies and notify the sender so that we may correct
ourrecords. Thank you.
 

Hi,

On Wed, 2015-06-17 at 19:48 +0000, Stephen Tahmosh wrote:
> 1.  Do I need postgresql94-python.x86_64?

No.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




mx is software released by these guys.
http://www.egenix.com
They all sorts of useful things for dealing with dates, proxies, etc
You probably need mx Base.

-------------------------------------------------
Mark Matthews
General Manager
Object Craft Pty Ltd
Phone: +61 3 9654 9099
http://www.object-craft.com.au



> On 18 Jun 2015, at 5:48 am, Stephen Tahmosh <stahmosh@shieldsrx.com> wrote:
>
> Thanks, this is very helpful.
> I have one more error:
> Two questions
> 1.  Do I need postgresql94-python.x86_64?
> 2.  If so, how do I get "mx" installed first?
>
> Thanks again!
> Steve
>
>
> I tried to install  the "python" associated with postgresql and got a "dependency on "mx""
> I couldn't determine what "mx" was
> The error
> --> Processing Dependency: mx for package: postgresql94-python-4.1.1-1PGDG.rhel6.x86_64
> --> Finished Dependency Resolution
> Error: Package: postgresql94-python-4.1.1-1PGDG.rhel6.x86_64 (pgdg94)
>           Requires: mx
> You could try using --skip-broken to work around the problem
> You could try running: rpm -Va --nofiles --nodigest
>
>
> I found plpython, tcl, and perl, and installed successfully in /usr/pgsql-9.4/share/extension
>
> As you suggested,  yum search postgresql94 got me the list of available packages
>
> STeve
>
> -----Original Message-----
> From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org]
> Sent: Wednesday, June 17, 2015 3:30 PM
> To: Stephen Tahmosh
> Cc: Joshua D. Drake; pgsql-admin@postgresql.org
> Subject: Re: Now using "yum.postgresql.org - RE: [ADMIN] EnterpriseDB: PostgreSql 9.4 Where is the Language Pack
Installer?
>
>
> Hi,
>
> On Wed, 2015-06-17 at 19:26 +0000, Stephen Tahmosh wrote:
>> I confirmed they are installed via "yum list" and located the core
>> postgres files but not the extensions I can't find out where the
>> plpython/plperl objects are.
>
> yum search postgresql94
>
> would give you names of all packages for PostgreSQL 9.4.
>
> so
>
> yum install postgresql94-plpython postgresql94-plperl
>
> would do the trick.
>
>> Also, How do I determine which version of python, perl, (tcl) are
>> supported with these language extensions?
>
> The versions supplied by the OS -- that is why using RPMs is a bit better choice.
>
> Regards,
>
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat
CertifiedEngineer 
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>
>
> THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY
CONTAININFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the
intendedrecipient, your use of this message for any purpose is strictly prohibited. If you have received this
communicationin error, please delete the message without making any copies and notify the sender so that we may correct
ourrecords. Thank you. 
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin



Thank you, Mark, for this information.

STeve

-----Original Message-----
From: Mark Matthews [mailto:mem@object-craft.com.au]
Sent: Wednesday, June 17, 2015 6:50 PM
To: Stephen Tahmosh
Cc: Devrim GÜNDÜZ; Joshua D. Drake; pgsql-admin@postgresql.org
Subject: Re: Now using "yum.postgresql.org - RE: [ADMIN] EnterpriseDB: PostgreSql 9.4 Where is the Language Pack
Installer?

mx is software released by these guys.
http://www.egenix.com
They all sorts of useful things for dealing with dates, proxies, etc You probably need mx Base.

-------------------------------------------------
Mark Matthews
General Manager
Object Craft Pty Ltd
Phone: +61 3 9654 9099
http://www.object-craft.com.au



> On 18 Jun 2015, at 5:48 am, Stephen Tahmosh <stahmosh@shieldsrx.com> wrote:
>
> Thanks, this is very helpful.
> I have one more error:
> Two questions
> 1.  Do I need postgresql94-python.x86_64?
> 2.  If so, how do I get "mx" installed first?
>
> Thanks again!
> Steve
>
>
> I tried to install  the "python" associated with postgresql and got a "dependency on "mx""
> I couldn't determine what "mx" was
> The error
> --> Processing Dependency: mx for package:
> --> postgresql94-python-4.1.1-1PGDG.rhel6.x86_64
> --> Finished Dependency Resolution
> Error: Package: postgresql94-python-4.1.1-1PGDG.rhel6.x86_64 (pgdg94)
>           Requires: mx
> You could try using --skip-broken to work around the problem You could
> try running: rpm -Va --nofiles --nodigest
>
>
> I found plpython, tcl, and perl, and installed successfully in
> /usr/pgsql-9.4/share/extension
>
> As you suggested,  yum search postgresql94 got me the list of
> available packages
>
> STeve
>
> -----Original Message-----
> From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org]
> Sent: Wednesday, June 17, 2015 3:30 PM
> To: Stephen Tahmosh
> Cc: Joshua D. Drake; pgsql-admin@postgresql.org
> Subject: Re: Now using "yum.postgresql.org - RE: [ADMIN] EnterpriseDB: PostgreSql 9.4 Where is the Language Pack
Installer?
>
>
> Hi,
>
> On Wed, 2015-06-17 at 19:26 +0000, Stephen Tahmosh wrote:
>> I confirmed they are installed via "yum list" and located the core
>> postgres files but not the extensions I can't find out where the
>> plpython/plperl objects are.
>
> yum search postgresql94
>
> would give you names of all packages for PostgreSQL 9.4.
>
> so
>
> yum install postgresql94-plpython postgresql94-plperl
>
> would do the trick.
>
>> Also, How do I determine which version of python, perl, (tcl) are
>> supported with these language extensions?
>
> The versions supplied by the OS -- that is why using RPMs is a bit better choice.
>
> Regards,
>
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>
>
> THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY
CONTAININFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the
intendedrecipient, your use of this message for any purpose is strictly prohibited. If you have received this
communicationin error, please delete the message without making any copies and notify the sender so that we may correct
ourrecords. Thank you.
 
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY
CONTAININFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the
intendedrecipient, your use of this message for any purpose is strictly prohibited. If you have received this
communicationin error, please delete the message without making any copies and notify the sender so that we may correct
ourrecords. Thank you.