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