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
Show quoted text
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
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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 Ubuntu 12.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,
you won't find it unless you click a not-very-obvious "Show [x]
technical items" link at the bottom of the window. I would recommend
using apt (command line) or Synaptic (graphical) instead of Software
Center.<br>
<blockquote>sudo apt-get install 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>
</body>
</html>
It only shows up when you search for it in lowercase. e.g "postgresql", not
"PostgreSQL".
You could also just use sudo-apt get install postgresql-9.1
postgresql-contrib-9.1 ("postgresql" is a meta-package)
hth,
WBL
On Tue, May 15, 2012 at 8:41 AM, Lee Hachadoorian <
Lee.Hachadoorian+L@gmail.com> wrote:
On 05/14/2012 09:19 PM, Mike Christensen wrote:
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.jspMike
On Mon, May 14, 2012 at 6:10 PM, Devrim GÜNDÜZ <devrim@gunduz.org> <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.
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, you won't find it
unless you click a not-very-obvious "Show [x] technical items" link at the
bottom of the window. I would recommend using apt (command line) or
Synaptic (graphical) instead of Software Center.sudo apt-get install postgresql postgresql-contrib
should get you started.
--Lee
--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Researchhttp://freecity.commons.gc.cuny.edu
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth