Обсуждение: 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?
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.