Re: [GENERAL] dblink.sql and Linux
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.hachadooria...@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.jsp > > Mike > > On Mon, May 14, 2012 at 6:10 PM, Devrim GÜNDÜZ > 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
Re: [GENERAL] dblink.sql and Linux
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.jsp Mike On Mon, May 14, 2012 at 6:10 PM, Devrim GÜNDÜZ 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 Research http://freecity.commons.gc.cuny.edu
Re: [GENERAL] dblink.sql and Linux
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 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] dblink.sql and Linux
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 signature.asc Description: This is a digitally signed message part
[GENERAL] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general