Thread: DB_link connection

DB_link connection

From
Sachin Srivastava
Date:
Hi,

Any one can help me how we can install "dblink_connect" in PostgreSQL9.4 on linux platform. If Possible, please provide the steps.

Regards,
Sachin Srivastava
9811149139

Re: DB_link connection

From
John R Pierce
Date:
On 11/16/2015 2:31 AM, Sachin Srivastava wrote:

Any one can help me how we can install "dblink_connect" in PostgreSQL9.4 on linux platform. If Possible, please provide the steps.

that is part of the 'contributed extension'  dblink.    the way you install the contrib modules depends on your flavor of linux, AND how you installed postgresql in the first place, for instance, on a RHEL system where PG was installed from the yum.postgresql.org repository,

    #  yum install postgresql94-contrib

on a debian/ubuntu flavored postgres, it would be something involving apt-get

once the contrib modules exist on the system, as a postgres superuser, to intsall a specific contrib module, you need...

    $ psql yourdb
    ....
    yourdb=# create extension dblink;

and from now on, the dblink functions are available in that database.


-- 
john r pierce, recycling bits in santa cruz

Re: DB_link connection

From
John R Pierce
Date:
On 11/16/2015 2:55 AM, Sachin Srivastava wrote:
> But while installing the package " #  yum install
> postgresql94-contrib"getting below error.
>
> -bash-4.1# yum install postgresql-9.4-contrib

what output do you get from...

    #  rpm -qa |grep postgres

?

I didn't see the yum.postgresql.org repo listed in your yum output. How
was postgres installed originally ?


--
john r pierce, recycling bits in santa cruz



Re: DB_link connection

From
John R Pierce
Date:
On 11/16/2015 3:39 AM, Sachin Srivastava wrote:

please reply to the list so that others in similar situation can benefit
from the eventual solution.

>
> Please find the output of rpm -qa |grep postgres
>
> -bash-4.1# rpm -qa |grep postgres
> postgresql-8.4.9-1.el6_1.1.x86_64
> postgresql-libs-8.4.9-1.el6_1.1.x86_64
> postgresql-devel-8.4.9-1.el6_1.1.x86_64

that suggests postgres 8.4 runtime was installed with your CentOS....
if it was my system, I would remove that.

> We install postgress using the below run file
> ./postgresql-9.4.5-1-linux-x64.run

ah,   that must be the enterpriseDB installer package, I've never used
that on Linux, but I believe it installs the contrib modules, so you'd
just need to do the..

    psql yourdb
     create extension dblink;
     \q

part to enable dblink in your database...

--
john r pierce, recycling bits in santa cruz