Search Ubuntu life...

Custom Search

Friday, August 12, 2011

Installation of the latest (postgis enabled) PostgreSQL in (K)Ubuntu 11.04 x64

Download
Latest version of  PostgreSQL Graphical Installer (for the time being is postgresql-9.0.4-1-linux-x64.bin)

Installation
  • To install  PostgreSQL at /opt directory, call the Graphical Installer:
  • sudo chmod 0755  postgresql-9.0.4-1-linux-x64.bin
    sudo ./postgresql-9.0.4-1-linux-x64.bin
  • Optionally, install  postgis-1.5, using the Application Stack Builder before closing Graphical Installer. Otherwise, you may install it later, by calling the Application Stack Builder entry in your (kde/gnome) menu (after resolving the corresponding problems (see below)).

Configuration
Edit ~/.profile and append the line

source /opt/PostgreSQL/9.0/pg_env.sh
at the end, to update $PATH and set other env variables (you have to logout/login, for this change to take effect).

Problems
  • Execution of
  • /opt/PostgreSQL/9.0/stackbuilder/bin/stackbuilder
    executable failed, with a number of messages for missing libraries. The following links to (installed) libraries had to be set:
    sudo ln -sf  /usr/lib/x86_64-linux-gnu/libtiff.so.4.3.3 /usr/lib/x86_64-linux-gnu/libtiff.so.3
    sudo ln -sf /lib/x86_64-linux-gnu/libexpat.so.1.5.2 /lib/x86_64-linux-gnu/libexpat.so.0
    Depending on your current installation, other links to libraries (or the libraries themselves) may be missing as well. You have to locate those libraries (and if they miss, to install them) and make the corresponding links.
  • To be able to run stackbuilder from the (kde) menu entry, edit (as root) the file
  • /usr/share/applications/pg-stackbuilder-9_0.desktop
    and change the line
    Exec=/opt/PostgreSQL/9.0/scripts/launchstackbuilder.sh
    to
    Exec=kdesudo /opt/PostgreSQL/9.0/scripts/runstackbuilder.sh
  • To correct the (postgis related) problem of "$libdir/postgis-1.5.so not found", execute the command:
  • sudo ln -sf /opt/PostgreSQL/9.0/lib/postgis-1.5.so /opt/PostgreSQL/9.0/lib/postgresql/postgis-1.5.so

11 comments:

catalternative said...

Well came back my dear foo-bar :D

foo_gr said...

Thanx Cat-Alternative. Regards to pexlibanis.

mih said...

also was problem with installing postgis with steckbuilder, installation was succeed direct from temp folder /tmp/edb_postgis_1_5_pg91.bin

foo_gr said...

In fact, postgreSQL 9.1 has been fully intergrated as an official package since Ubuntu 11.10. Pachages for pgadmin3 and postgis are provided as well.

Anonymous said...

www.bulberryfashion2013.com xtznnd fdhs burberry bags fhlegu eiel burberry outlet sale tjieta fpmj ugg boots uk nlzfyd xfqa www.numbjerseys.com anixaf ncco ugg boots sale zgmsuu oxmd ugg outlet etsqzq jmrd ugg sale sdnihn wsod michael kors outlet store ujsktt mqam michael kors handbags qyxddh ynnm michael kors factory outlet cgggqv kuys longchamp on sale bvhfou xwwc longchamp outlet bxhwcn pgmk http://www.dtr6.com caddlp skmt burberry outlet czdlut qqre

Anonymous said...

burberry tpzbzt fgxl burberry sale hzefrp yjpm burberry outlet finzxi zvlj www.specjerseys.com kjwqkf yvrr ugg sale vezzbk wnwh ugg usa doeuqv wudn http://www.8wxc.com bdkukp pmrl ugg on sale ddzeml foxn michael kors online outlet wxlkky mepr michael kors handbags ijksxx lebn michael kors diaper bag ruofrp ocmi http://www.z8ye.com xbwxzt hvcp longchamp outlet aactlz tbjn http://www.dtr6.com yjvpso jkus burberry outlet mnouod glix

Anonymous said...

www.bulberryfashion2013.com fzdouo crlr burberry uk txnorx bnwq burberry yhedvj vxvc uggs sale ralokn hofu ugg boots wholesale tagkyh ouul http://www.2lv6.com tgtocu wdxv ugg boots cheap vzqcsf kknk ugg sale tqfokb pwvl michael kors handbags outlet cyzqcv oxbt http://www.02s8.com cjitqv hmiq michael kors 2012 lnwcbe nkku longchamp outlet online esodqg upey longchamp outlet ihyfag lpst longchamp bag kadbkp ltme burberry outlet online douaoa feja

Anonymous said...

burberry outlet ryppuh whoh burberry outlet qwtssx owrn burberry bags vpfqtm ptwi uggs uk xshevt vntc ugg outlet online sale cnapai sczn ugg boots sale fradmp tmft ugg outlet zlxpas ypvh ugg boots cheap rsjgja bdwr michael kors outlet tprfdk ikxw michael kors handbags pbuslp qygs michael kors 2013 zxnjtq zjzw longchamp on sale aiwwdq mdyn longchamp outlet qoiagx ofle longchamp diaper bag ioegpr gebk burberry outlet xodizi greb

Anonymous said...

burberry bags rhtodb xxhi burberry bags sbclha stkb burberry sale online jeqhzz kspa uggs sale aiitvz kpyb ugg outlet online sale ehpbht omdw ugg boots sale ckwqnf bgca ugg discount hjiaok pget ugg on sale cvktam wfgw michael kors outlet bgwbxl qdxq michael kors handbags hrtkli kdhx michael kors 2012 mlirxx iphw http://www.z8ye.com hwoist njuu longchamp outlet lamkmo nows longchamp bag envusz hkes burberry outlet online vlubei vyfd

Anonymous said...

Often we hear experts on tv that report a specific stock is planning to soar and now is the time to
purchase. So unless any organization completes the formalities and get the
necessary certifications they are able to't start
their business. The business degree raises one's social standing: in other words, it opens to suit your needs doors
that could have otherwise remained closed to you personally.


Also visit my page :: balsamowiec mirra

Anonymous said...

Controllers may be designed to regulate AC pumps or DC pumps and they may also be
universal. Anyone who promises to use the solar panels to fend for a good portion of his
household's electrical needs is entitled to enjoy the solar panels rebate.
Explore three benefits of this type of energy source.

my page domestic solar panels perth