Thread: dblink.sql and Linux

I've become a big fan of DBLink lately, but I'm curious where it lives
on Linux installations.

On my Windows 9.0.0 installation, there's a contrib\dblink.sql file
that I just run and everything is setup for me.

I have a few Linux installations as well (I think they're all 9.1
though) and there's no dblink.sql file anywhere to be found, nor does
the dblink() function exist in any schema out of the box.  Is there
somewhere to download the installation script, or is there another
method to install this support?  Thanks!

Mike

Hi,

On Mon, 2012-05-14 at 18:05 -0700, Mike Christensen wrote:
> I've become a big fan of DBLink lately, but I'm curious where it lives
> on Linux installations.

Which Linux? Which package/installer?

It mostly ships with the -contrib package.

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

I just installed Ubuntu 12.04 today.  Postgres was not listed in the
Ubuntu Software Center, so I downloaded the apt installer from:

http://www.openscg.com/se/oscg_home_download.jsp

Mike

On Mon, May 14, 2012 at 6:10 PM, Devrim GÜNDÜZ <devrim@gunduz.org> wrote:
> Hi,
>
> On Mon, 2012-05-14 at 18:05 -0700, Mike Christensen wrote:
>> I've become a big fan of DBLink lately, but I'm curious where it lives
>> on Linux installations.
>
> Which Linux? Which package/installer?
>
> It mostly ships with the -contrib package.
>
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

<br /> On 05/14/2012 09:19 PM, Mike Christensen wrote: <blockquote
cite="mid:CABs1bs3cJDSXkUguEB5OhtF5NeukjKU6BLqXZ8RbhAoHgLFnNQ@mail.gmail.com"type="cite"><pre wrap="">I just installed
Ubuntu12.04 today.  Postgres was not listed in the
 
Ubuntu Software Center, so I downloaded the apt installer from:

<a class="moz-txt-link-freetext"
href="http://www.openscg.com/se/oscg_home_download.jsp">http://www.openscg.com/se/oscg_home_download.jsp</a>

Mike

On Mon, May 14, 2012 at 6:10 PM, Devrim GÜNDÜZ <a class="moz-txt-link-rfc2396E"
href="mailto:devrim@gunduz.org"><devrim@gunduz.org></a>wrote:
 
</pre><blockquote type="cite"><pre wrap="">Hi,

On Mon, 2012-05-14 at 18:05 -0700, Mike Christensen wrote:
</pre><blockquote type="cite"><pre wrap="">I've become a big fan of DBLink lately, but I'm curious where it lives
on Linux installations.
</pre></blockquote><pre wrap="">
Which Linux? Which package/installer?

It mostly ships with the -contrib package.

</pre></blockquote></blockquote> Full list of Ubuntu packages is available at packages.ubuntu.com. Postgres 9.1
(default)and 8.4 are in the repository. The Ubuntu Software Center hides stuff from you. If you search for postgres,
youwon't find it unless you click a not-very-obvious "Show [x] technical items" link at the bottom of the window. I
wouldrecommend using apt (command line) or Synaptic (graphical) instead of Software Center.<br /><blockquote>sudo
apt-getinstall postgresql postgresql-contrib<br /></blockquote> should get you started.<br /><br /> --Lee<br /><pre
class="moz-signature"cols="72">-- 
 
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
<a class="moz-txt-link-freetext" href="http://freecity.commons.gc.cuny.edu">http://freecity.commons.gc.cuny.edu</a>
</pre>