[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
From: Smaran Harihar <smaran.harihar () gmail ! com>
Date: 2012-05-31 17:46:21
Message-ID: CAHRZm1skV2hqKMx4desqobF8-1Df-2Bfz0-5ty_BKG-OS7h+Tg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Jeff,
I removed all the packages you asked me to and then reinstalled the
postgis-2.0 from
here<http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204#a44BuildPostGIS>.
the reason I started there is because, postgres-9.1 was already present.
After re-installing the postgis, I tried using the `psql` command but I am
getting the following error,
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
And when I opened pgadmin3, it said that it could not connect to a server.
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused Is the server running on
host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
It seems that the geoserver got uninstalled when I executed,
apt-get auto remove
So now, I re-installed it, I am still not able to use psql or pgadmin3. I
also tried restarting the postgres, using
service postgres restart
and I received the following error,
* Error: You must run this program as the cluster owner (postgres)
On Wed, May 30, 2012 at 11:32 AM, Jeff Meyer <jeff@gwhat.org> wrote:
> Hi Smaran -
>
> You actually do have geonode installed if you installed opengeo-suite.
> The link I pointed you to below shows all of the packages installed with
> opengeo-suite & geonode is the second item listed:
> http://apt.opengeo.org/ubuntu/dists/lucid/main/binary-amd64/Packages
>
> Geonode is really the heart of the entire opengeo suite.
>
> Here's what I did:
> ** removed the opengeo repository link in /etc/apt/sources.list
> then
> sudo apt-get remove opengeo-suite
> sudo apt-get remove postgresql-8.4
> sudo apt-get remove opengeo-postgis
>
> Then, I went in and reinstalled postgis 2.0 using the instructions on the
> wiki (the instructions you used before).
>
> Then, I installed the alpha version of Geonode, using the link provided
> below. (http://geonode.org/)
>
> Hack away at that a little bit & I bet you can get going again.
>
> Good luck!
> Jeff
>
>
>
>
> ------------------------------
> *From:* Smaran Harihar <smaran.harihar@gmail.com>
> *To:* Jeff Meyer <jeff@gwhat.org>
> *Sent:* Wednesday, May 30, 2012 9:47 AM
>
> *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
>
> Hi Jeff,
>
> Hi Smaran -
> Can you double-check your version of gdal?
> What happens when you type:
> # gdal-config
> ?
>
> gdal version - 1.9.0
>
> At present I am not using Geonode.
>
> Also you were right I think opengeo has overwritten my postgis. Here is
> the output.
>
>
> dpkg -s postgis
> Package: postgis
> Status: install ok installed
> Priority: optional
> Section: misc
> Installed-Size: 2092
> Maintainer: Debian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
> Architecture: amd64
> Version: 1.5.4-1+opengeo
> Depends: libatk1.0-0 (>= 1.29.3), libc6 (>= 2.4), libcairo2 (>= 1.2.4),
> libfontconfig1 (>= 2.8.0), libfreetype6 (>= 2.2.1), libglib2.0-0 (>=
> 2.16.0), libgtk2.0-0 (>= 2.8.0), libpango1.0-0 (>= 1.14.0), libpq5 (>=
> 8.4~0cvs20090328)
> Suggests: postgresql-8.4-postgis
> Description: geographic objects support for PostgreSQL -- common files
> PostGIS adds support for geographic objects to the PostgreSQL
> object-relational
> database. In effect, PostGIS "spatially enables" the PostgreSQL server,
> allowing it to be used as a backend spatial database for geographic
> information
> systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
> follows the OpenGIS "Simple Features Specification for SQL".
> .
> This package contains the PostGIS userland binaries, common files and
> documentation.
> Homepage: http://postgis.refractions.net/
>
> So what should i do now?
>
> Thanks & Regards,
> Smaran Harihar
>
>
> On Wed, May 30, 2012 at 8:30 AM, Jeff Meyer <jeff@gwhat.org> wrote:
>
> Hi Smaran -
> Can you double-check your version of gdal?
> What happens when you type:
> # gdal-config
> ?
>
> Keep in mind, the latest version of PostGIS wants you to be using GDAL 1.9.
>
> Also, on the Geonode web page, it says that past versions of Geonode -
> that is, the one that comes with opengeo suite - is not compatible with
> Ubuntu 12.04. See: http://geonode.org/
>
> "GeoNode 1.2 will be the first release compatible with Ubuntu 11.10 and
> 12.04 (while maintaining compatibility with Ubuntu releases after 10.04).
> Please note that this alpha in particular has only been tested in 12.04, we
> appreciate your feedback in identifying potential issues in other
> distributions. Issue reports may be filed on the GeoNode Github \
> project<http://github.com/geonode/geonode>or reported on the GeoNode users forum \
> <https://groups.google.com/forum/#%21forum/geonode-users>."
> Also - double-check which version of postgis is running - opengeo-suite
> may have overwritten PostGIS 2.0... it did for me. : )
>
> jeffme@jeffme-vbox:~$ dpkg -s postgis
> Package: postgis
> Status: install ok installed
> Priority: optional
> Section: misc
> Installed-Size: 2092
> Maintainer: Debian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
> Architecture: amd64
> Version: 1.5.4-1+opengeo
> Depends: libatk1.0-0 (>= 1.29.3), libc6 (>= 2.4), libcairo2 (>= 1.2.4),
> libfontconfig1 (>= 2.8.0), libfreetype6 (>= 2.2.1), libglib2.0-0 (>=
> 2.16.0), libgtk2.0-0 (>= 2.8.0), libpango1.0-0 (>= 1.14.0), libpq5 (>=
> 8.4~0cvs20090328)
> Suggests: postgresql-8.4-postgis
> Description: geographic objects support for PostgreSQL -- common files
> PostGIS adds support for geographic objects to the PostgreSQL
> object-relational
> database. In effect, PostGIS "spatially enables" the PostgreSQL server,
> allowing it to be used as a backend spatial database for geographic
> information
> systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
> follows the OpenGIS "Simple Features Specification for SQL".
> .
> This package contains the PostGIS userland binaries, common files and
> documentation.
> Homepage: http://postgis.refractions.net/
> jeffme@jeffme-vbox:~$
>
>
> Good luck - be careful out there!
> Jeff
>
>
>
> ------------------------------
> *From:* Smaran Harihar <smaran.harihar@gmail.com>
> *To:* Jeff Meyer <jeff@gwhat.org>
> *Sent:* Tuesday, May 29, 2012 8:25 PM
>
> *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
>
> Hi Jeff,
>
> I was able to solve it. Had to make the .deb overwrittable.
>
> Heres the solution,
>
>
> http://askubuntu.com/questions/143889/unable-to-unpack-libgdal/143913#143913
>
> On Tue, May 29, 2012 at 5:20 PM, Jeff Meyer <jeff@gwhat.org> wrote:
>
> Hi Smaran -
> I'm not as familiar with the OpenGeo Suite (but am working on it).
> You've hit a lightweight version of what is known as "dependency hell."
>
> There are a few options here:
> 1) Wait for the OpenGeo Suite package to be updated for 12.04. I'm not
> sure what plans are for that.
> 2) If you're valiant, you might want to go through and hand-install all of
> the packages and figure out which packages are causing the problems and see
> if you can find newer versions of these packages. The specific package list
> (I believe) is found at:
> http://apt.opengeo.org/ubuntu/dists/lucid/main/binary-amd64/Packages, and
> the very first package listed (gdal-mrsid) has this nasty line: "Depends:
> libgdal (= 1.8.1-1)" when other, more flexible, packages have things like
> this: "Depends: libgdal (>= 1.8.1-1)"
> * It's quite possible that you don't need this gdal-mrsid package to do
> what you want to do. There don't appear to be any dependencies on
> gdal-mrsid in the rest of the OpenGeo Suite packages, but you might run
> into other problems. A quick search of launchpad didn't turn up a newer ppa
> for gdal-mrsid. You can see that the version at OpenGeo still has this
> problem:
>
> jeffme@jeffme-vbox:~$ sudo apt-get install gdal-mrsid
> [sudo] password for jeffme:
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> You might want to run 'apt-get -f install' to correct these:
> The following packages have unmet dependencies:
> gdal-mrsid : Depends: libgdal (= 1.8.1-1) but it is not going to be
> installed
> opengeo-geoserver : Depends: libgdal but it is not going to be installed
> E: Unmet dependencies. Try 'apt-get -f install' with no packages (or
> specify a solution).
> jeffme@jeffme-vbox:~$
>
> That all said, and apologies for the punt, but you'll probably get better
> answers on an opengeo listserv than here on postgis-users.
>
> Good luck!
> Thanks, Jeff
>
> ------------------------------
> *From:* Smaran Harihar <smaran.harihar@gmail.com>
> *To:* Jeff Meyer <jeff@gwhat.org>; PostGIS Users Discussion <
> postgis-users@postgis.refractions.net>
> *Sent:* Tuesday, May 29, 2012 3:11 PM
>
> *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
>
> Hi Jeff,
>
> I tried successfully installed PostGIS extension to Postgres database but
> now when I try to install opengeo-suite, I am getting the following error.
>
>
> E: /var/cache/apt/archives/libgdal_1.8.1-1_amd64.deb: trying to overwrite
> '/usr/lib/libgdal.so.1', which is also in package libgdal1 1.9.0-1~exp5p1
>
> Stuck here and not sure where to go?
>
> Thanks & Regards,
> Smaran Harihar
>
> On Wed, May 23, 2012 at 12:42 PM, Jeff Meyer <jeff@gwhat.org> wrote:
>
> Hi Smaran -
> I can't speak to what went wrong during your install, but have you
> double-checked your ability to add extensions through pgAdmin III?
> You should be able to open your db, navigate to extensions, right click on
> the extensions label, and then click "New Extension." If PostGIS isn't
> listed as a possible extension, then something went wrong in the PostGIS
> install.
> You may want to then do an 'apt-get remove postgis' and then follow the
> instructions at:
> http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204.
> Thanks, Jeff
>
> ------------------------------
> *From:* Smaran Harihar <smaran.harihar@gmail.com>
>
> *To:* PostGIS Users Discussion <postgis-users@postgis.refractions.net>
> *Sent:* Wednesday, May 23, 2012 10:09 AM
>
> *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
>
> Hi,
>
> I have already installed PostGIS 2.0 and Postgres 9.3.1 using synaptic
> package manager.
>
> Now when I run your commands in psql console,
>
>
> shpRepo=# CREATE EXTENSION postgis;
>
> I am receiving an error,
>
> ERROR: could not open extension control file
> "/usr/share/postgres/9.1/extension/postgis.control": No such file or
> directory
>
> Where did I go wrong?
>
>
>
> On Wed, May 23, 2012 at 9:58 AM, Brian H Wilson <brian@wildsong.biz>wrote:
>
> On 5/23/2012 8:08 AM, José María Amuedo wrote:
>
> Someone know how can linstall postgresql-9.1.3-2-linux.run in Ubuntu 12.04?
>
> I installed it but I can not to launch stackbuilder to configure new
> tools like postgis.
>
>
> As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've
> only used stackbuilder once. You don't really need it.
>
> I like to experiment with the latest so currently I do install PostGIS
> from sources. The version in the official Ubuntu repository is still at
> 1.5.3
>
> There are instructions here for PostGIS 2 packages that look pretty
> promising:
>
> http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204
>
> My own grueling details are here: http://wildsong.biz/index.php/PostGIS
> Feedback welcome.
>
> Hope this helps,
>
> Brian
>
> ______________________________**_________________
> postgis-users mailing list
> postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> --
> Thanks & Regards
> Smaran Harihar
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> --
> Thanks & Regards
> Smaran Harihar
>
>
>
>
>
>
> --
> Thanks & Regards
> Smaran Harihar
>
>
>
>
>
>
> --
> Thanks & Regards
> Smaran Harihar
>
>
>
>
--
Thanks & Regards
Smaran Harihar
[Attachment #5 (text/html)]
Hi Jeff,<div><br></div><div>I removed all the packages you asked me to and then \
reinstalled the postgis-2.0 from <a \
href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204#a44BuildPostGIS">here</a>. \
the reason I started there is because, postgres-9.1 was already present. After \
re-installing the postgis, I tried using the `psql` command but I am getting the \
following error,</div>
<div><br></div><div><div>psql: could not connect to server: No such file or \
directory</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Is \
the server running locally and accepting</div><div><span class="Apple-tab-span" \
style="white-space:pre"> </span>connections on Unix domain socket \
"/var/run/postgresql/.s.PGSQL.5432"?</div>
<div><br></div><div>And when I opened pgadmin3, it said that it could not connect to \
a server.</div><div><br></div><div><div>Server doesn't listen</div><div>The \
server doesn't accept connections: the connection library reports </div>
<div>could not connect to server: Connection refused Is the server running on host \
"localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? \
</div></div><div><br></div><div> It seems that the geoserver got uninstalled when I \
executed,</div>
<div><br></div><div>apt-get auto remove</div><div><br></div><div>So now, I \
re-installed it, I am still not able to use psql or pgadmin3. I also tried restarting \
the postgres, using</div><div><br></div><div>service postgres restart</div>
<div><br></div><div>and I received the following error,</div><div><br></div><div>* \
Error: You must run this program as the cluster owner (postgres)</div><br><div \
class="gmail_quote">On Wed, May 30, 2012 at 11:32 AM, Jeff Meyer <span \
dir="ltr"><<a href="mailto:jeff@gwhat.org" \
target="_blank">jeff@gwhat.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div><div \
style="font-size:10pt;font-family:arial,helvetica,sans-serif"><div><span>Hi Smaran - \
<br></span></div><div><br>
<span></span></div><div><span>You actually do have geonode installed if you installed \
opengeo-suite.</span></div><div><span>The link I pointed you to below shows all of \
the packages installed with opengeo-suite & geonode is the second item \
listed:</span></div>
<div><span><a href="http://apt.opengeo.org/ubuntu/dists/lucid/main/binary-amd64/Packages" \
target="_blank">http://apt.opengeo.org/ubuntu/dists/lucid/main/binary-amd64/Packages</a></span></div><div><br><span></span></div><div>
<span>Geonode is really the heart of the entire opengeo \
suite.</span></div><div><br><span></span></div><div><span>Here's what I \
did:</span></div><div><span>** removed the opengeo repository link in \
/etc/apt/sources.list<br>
</span></div><div><span>then<br></span></div><div><span></span><span>sudo apt-get \
remove opengeo-suite</span></div><div><span>sudo apt-get remove \
postgresql-8.4</span></div><div><span>sudo apt-get remove \
opengeo-postgis</span></div><div><br><span></span></div><div><span>Then, I went in \
and reinstalled postgis 2.0 using the instructions on the wiki (the instructions you \
used before).</span></div><div><br><span></span></div>
<div><span>Then, I installed the alpha version of Geonode, using the link provided \
below. (</span><a rel="nofollow" href="http://geonode.org/" \
target="_blank">http://geonode.org/</a><span>)<br></span></div><div><br><span></span></div>
<div><span>Hack away at that a little bit & I bet you can get going \
again.</span></div><br>Good \
luck!<br><div><span>Jeff</span></div><div><span><br></span></div><div><span><br></span></div><div><br><span></span></div>
<div><span></span></div><div><br><blockquote style="border-left:2px solid \
rgb(16,16,255);margin-left:5px;margin-top:5px;padding-left:5px"> <div \
style="font-family:arial,helvetica,sans-serif;font-size:10pt"> <div \
style="font-family:times new roman,new york,times,serif;font-size:12pt">
<div dir="ltr"> <font face="Arial"><div class="im"> <hr size="1"> <b><span \
style="font-weight:bold">From:</span></b> Smaran Harihar <<a \
href="mailto:smaran.harihar@gmail.com" \
target="_blank">smaran.harihar@gmail.com</a>><br>
<b><span style="font-weight:bold">To:</span></b> Jeff Meyer <<a \
href="mailto:jeff@gwhat.org" target="_blank">jeff@gwhat.org</a>> <br> \
</div><b><span style="font-weight:bold">Sent:</span></b> Wednesday, May 30, 2012 9:47 \
AM<div>
<div class="h5"><br> <b><span style="font-weight:bold">Subject:</span></b> Re: \
[postgis-users] Ubuntu and Postgresql9.1.3-2<br> </div></div></font> </div><div><div \
class="h5"> <br><div><div>Hi Jeff,</div><div><br></div><div>
<div style="font-family:arial,helvetica,sans-serif;font-size:13px">Hi Smaran - \
<br></div><div style="font-family:arial,helvetica,sans-serif;font-size:13px">Can you \
double-check your version of gdal?</div>
<div style="font-family:arial,helvetica,sans-serif;font-size:13px">What happens when \
you type:</div><div style="font-family:arial,helvetica,sans-serif;font-size:13px"># \
gdal-config</div><div style="font-family:arial,helvetica,sans-serif;font-size:13px">
?</div></div><div style="font-family:arial,helvetica,sans-serif;font-size:13px"><br></div><div \
style="font-family:arial,helvetica,sans-serif;font-size:13px">gdal version - \
1.9.0</div><div style="font-family:arial,helvetica,sans-serif;font-size:13px">
<br></div><div style="font-family:arial,helvetica,sans-serif;font-size:13px">At \
present I am not using Geonode.</div><div \
style="font-family:arial,helvetica,sans-serif;font-size:13px"><br></div><div \
style="font-family:arial,helvetica,sans-serif;font-size:13px">
Also you were right I think opengeo has overwritten my postgis. Here is the \
output.</div><div style="font-family:arial,helvetica,sans-serif;font-size:13px"><br></div><div \
style="font-family:arial,helvetica,sans-serif;font-size:13px">
<br></div><div><div> dpkg -s postgis </div><div>Package: postgis</div><div>Status: \
install ok installed</div><div>Priority: optional</div><div>Section: \
misc</div><div>Installed-Size: 2092</div><div>Maintainer: Debian GIS Project <<a \
rel="nofollow" href="mailto:pkg-grass-devel@lists.alioth.debian.org" \
target="_blank">pkg-grass-devel@lists.alioth.debian.org</a>></div>
<div>Architecture: amd64</div><div>Version: 1.5.4-1+opengeo</div><div>Depends: \
libatk1.0-0 (>= 1.29.3), libc6 (>= 2.4), libcairo2 (>= 1.2.4), \
libfontconfig1 (>= 2.8.0), libfreetype6 (>= 2.2.1), libglib2.0-0 (>= \
2.16.0), libgtk2.0-0 (>= 2.8.0), libpango1.0-0 (>= 1.14.0), libpq5 (>= \
8.4~0cvs20090328)</div>
<div>Suggests: postgresql-8.4-postgis</div><div>Description: geographic objects \
support for PostgreSQL -- common files</div><div> PostGIS adds support for geographic \
objects to the PostgreSQL object-relational</div><div>
database. In effect, PostGIS "spatially enables" the PostgreSQL \
server,</div> <div> allowing it to be used as a backend spatial database for \
geographic information</div><div> systems (GIS), much like ESRI's SDE or \
Oracle's Spatial extension. PostGIS</div><div> follows the OpenGIS "Simple \
Features Specification for SQL".</div>
<div> .</div><div> This package contains the PostGIS userland binaries, common files \
and</div><div> documentation.</div><div>Homepage: <a rel="nofollow" \
href="http://postgis.refractions.net/" \
target="_blank">http://postgis.refractions.net/</a></div>
</div>
<div><br></div><div>So what should i do now?</div><div><br></div><div>Thanks & \
Regards,</div><div>Smaran Harihar</div><br><br><div>On Wed, May 30, 2012 at 8:30 AM, \
Jeff Meyer <span dir="ltr"><<a rel="nofollow" href="mailto:jeff@gwhat.org" \
target="_blank">jeff@gwhat.org</a>></span> wrote:<br>
<blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div><div \
style="font-size:10pt;font-family:arial,helvetica,sans-serif"><div><span>Hi Smaran - \
<br></span></div><div><span>Can you double-check your version of gdal?</span></div>
<div><span>What happens when you type:</span></div><div><span># \
gdal-config</span></div><div><span>?</span></div><div><br><span></span></div><div><span>Keep \
in mind, the latest version of PostGIS wants you to be using GDAL 1.9.</span></div>
<div><br><span></span></div><div><span>Also, on the Geonode web page, it says that \
past versions of Geonode - that is, the one that comes with opengeo suite - is not \
compatible with Ubuntu 12.04. See: </span><a rel="nofollow" \
href="http://geonode.org/" target="_blank">http://geonode.org/</a><br>
</div><div><br></div><div>"GeoNode 1.2 will be the first release compatible with \
Ubuntu 11.10 and 12.04 (while maintaining compatibility with Ubuntu releases after
10.04). Please note that this alpha in particular has only been tested
in 12.04, we appreciate your feedback in identifying potential issues in
other distributions. Issue reports may be filed on the GeoNode <a rel="nofollow" \
href="http://github.com/geonode/geonode" target="_blank">Github project</a> or \
reported on the GeoNode <a rel="nofollow" \
href="https://groups.google.com/forum/#%21forum/geonode-users" target="_blank">users \
forum</a>."</div>
<div><br></div><div>Also - double-check which version of postgis is running - \
opengeo-suite may have overwritten PostGIS 2.0... it did for me. : \
)</div><div><br></div><div>jeffme@jeffme-vbox:~$ dpkg -s postgis<br>Package: \
postgis<br>
Status: install ok installed<br>Priority: optional<br>Section: \
misc<br>Installed-Size: 2092<br>Maintainer: Debian GIS Project <<a rel="nofollow" \
href="mailto:pkg-grass-devel@lists.alioth.debian.org" \
target="_blank">pkg-grass-devel@lists.alioth.debian.org</a>><br>
Architecture: amd64<br>Version: 1.5.4-1+opengeo<br>Depends: libatk1.0-0 (>= \
1.29.3), libc6 (>= 2.4), libcairo2 (>= 1.2.4), libfontconfig1 (>= 2.8.0), \
libfreetype6 (>= 2.2.1), libglib2.0-0 (>= 2.16.0), libgtk2.0-0 (>= 2.8.0), \
libpango1.0-0 (>= 1.14.0), libpq5 (>= 8.4~0cvs20090328)<br>Suggests: \
postgresql-8.4-postgis<br>Description: geographic objects support for PostgreSQL -- \
common files<br> PostGIS adds support for geographic objects to the PostgreSQL \
object-relational<br> database. In effect, PostGIS "spatially enables" the \
PostgreSQL server,<br>
allowing it to be used as a backend spatial database for geographic information<br> \
systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. \
PostGIS<br> follows the OpenGIS "Simple Features Specification for \
SQL".<br>
.<br> This package contains the PostGIS userland binaries, common files and<br> \
documentation.<br>Homepage: <a rel="nofollow" href="http://postgis.refractions.net/" \
target="_blank">http://postgis.refractions.net/</a><br>
jeffme@jeffme-vbox:~$ <br>
</div><div><br></div><div><br></div><div>Good luck - be careful out \
there!</div><div>Jeff</div><div><br></div><div><br></div><div><br><blockquote \
style="border-left:2px solid \
rgb(16,16,255);margin-left:5px;margin-top:5px;padding-left:5px">
<div style="font-family:arial,helvetica,sans-serif;font-size:10pt"> <div \
style="font-family:times new roman,new york,times,serif;font-size:12pt"> <div \
dir="ltr"> <font face="Arial"><div> <hr size="1"> <b><span \
style="font-weight:bold">From:</span></b> Smaran Harihar <<a rel="nofollow" \
href="mailto:smaran.harihar@gmail.com" \
target="_blank">smaran.harihar@gmail.com</a>><br>
<b><span style="font-weight:bold">To:</span></b> Jeff Meyer <<a rel="nofollow" \
href="mailto:jeff@gwhat.org" target="_blank">jeff@gwhat.org</a>> <br> \
</div><b><span style="font-weight:bold">Sent:</span></b> Tuesday, May 29, 2012 8:25 \
PM<div>
<div><br> <b><span style="font-weight:bold">Subject:</span></b> Re: [postgis-users] \
Ubuntu and Postgresql9.1.3-2<br> </div></div></font> </div><div><div> <br> <div>Hi \
Jeff,<div><br></div><div>I was able to solve it. Had to make the .deb \
overwrittable.</div><div><br></div><div>Heres the \
solution,</div><div><br></div><div><a rel="nofollow" \
href="http://askubuntu.com/questions/143889/unable-to-unpack-libgdal/143913#143913" \
target="_blank">http://askubuntu.com/questions/143889/unable-to-unpack-libgdal/143913#143913</a><br>
<br><div>On Tue, May 29, 2012 at 5:20 PM, Jeff Meyer <span dir="ltr"><<a \
rel="nofollow" href="mailto:jeff@gwhat.org" \
target="_blank">jeff@gwhat.org</a>></span> wrote:<br><blockquote style="margin:0 0 \
0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:10pt;font-family:arial,helvetica,sans-serif"><div><span>Hi \
Smaran - <br></span></div><div><span>I'm not as familiar with the OpenGeo Suite \
(but am working on it). </span></div><div><span>You've hit a lightweight version \
of what is known as "dependency hell."</span></div>
<div><span><br></span></div><div><span>There are a few options \
here:</span></div><div><span>1) Wait for the OpenGeo Suite package to be updated for \
12.04. I'm not sure what plans are for that. <br></span></div><div><span>2) If \
you're valiant, you might want to go through and hand-install all of the packages \
and figure out which packages are causing the problems and see if you can find newer \
versions of these packages. The specific package list (I believe) is found at: <a \
rel="nofollow" href="http://apt.opengeo.org/ubuntu/dists/lucid/main/binary-amd64/Packages" \
target="_blank">http://apt.opengeo.org/ubuntu/dists/lucid/main/binary-amd64/Packages</a>, \
and the very first package listed (gdal-mrsid) has this nasty line: \
"</span>Depends: libgdal (= 1.8.1-1)<span>" when other, more flexible, \
packages have things like this: "</span>Depends: libgdal (>= \
1.8.1-1)<span>"</span></div><div><span>* It's quite possible that you \
don't need this gdal-mrsid package to do what you want to do. There don't \
appear to be any dependencies on gdal-mrsid in the rest of the OpenGeo Suite \
packages, but you might run into other problems. A quick search of launchpad \
didn't turn up a newer ppa for gdal-mrsid. You can see that the version at \
OpenGeo still has this problem:</span></div>
<div><span><br></span></div><div><span>jeffme@jeffme-vbox:~$ sudo apt-get install \
gdal-mrsid<br>[sudo] password for jeffme: <br>Reading package lists... \
Done<br>Building dependency tree <br>Reading state information... Done<br>
You might want to run 'apt-get -f install' to correct these:<br>The following \
packages have unmet dependencies:<br> gdal-mrsid : Depends: libgdal (= 1.8.1-1) but \
it is not going to be installed<br> opengeo-geoserver : Depends: libgdal but it is \
not going to be installed<br>E: Unmet dependencies. Try 'apt-get -f install' \
with no packages (or specify a solution).<br>
jeffme@jeffme-vbox:~$ <br><br></span></div><div><span>That all said, and apologies \
for the punt, but you'll probably get better answers on an opengeo listserv than \
here on postgis-users.</span></div><div><br><span></span></div>
<div><span>Good luck!</span></div><div><span>Thanks, \
Jeff</span></div><div><br><blockquote style="border-left:2px solid \
rgb(16,16,255);margin-left:5px;margin-top:5px;padding-left:5px"> <div \
style="font-family:arial,helvetica,sans-serif;font-size:10pt">
<div style="font-family:times new roman,new york,times,serif;font-size:12pt"> <div \
dir="ltr"> <font face="Arial"><div> <hr size="1"> <b><span \
style="font-weight:bold">From:</span></b> Smaran Harihar <<a rel="nofollow" \
href="mailto:smaran.harihar@gmail.com" \
target="_blank">smaran.harihar@gmail.com</a>><br> </div><b><span \
style="font-weight:bold">To:</span></b> Jeff Meyer <<a rel="nofollow" \
href="mailto:jeff@gwhat.org" target="_blank">jeff@gwhat.org</a>>; PostGIS Users \
Discussion <<a rel="nofollow" href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a>> <br>
<b><span style="font-weight:bold">Sent:</span></b> Tuesday, May 29, 2012 3:11 \
PM<div><div><br> <b><span style="font-weight:bold">Subject:</span></b> Re: \
[postgis-users] Ubuntu and Postgresql9.1.3-2<br> </div> </div>
</font> </div><div><div> <br>
<div>Hi Jeff,<div><br></div><div>I tried successfully installed PostGIS extension to \
Postgres database but now when I try to install opengeo-suite, I am getting the \
following error.</div><div><br></div><div><br>E: \
/var/cache/apt/archives/libgdal_1.8.1-1_amd64.deb: trying to overwrite \
'/usr/lib/libgdal.so.1', which is also in package libgdal1 \
1.9.0-1~exp5p1</div>
<div><br></div><div>Stuck here and not sure where to \
go?</div><div><br></div><div>Thanks & Regards,</div><div>Smaran \
Harihar</div><div><br><div>On Wed, May 23, 2012 at 12:42 PM, Jeff Meyer <span \
dir="ltr"><<a rel="nofollow" href="mailto:jeff@gwhat.org" \
target="_blank">jeff@gwhat.org</a>></span> wrote:<br>
<blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div><div \
style="font-size:10pt;font-family:arial,helvetica,sans-serif"><div><span>Hi Smaran - \
<br></span></div><div><span>I can't speak to what went wrong during your install, \
but have you double-checked your ability to add extensions through pgAdmin \
III?</span></div>
<div><span>You should be able to open your db, navigate to extensions, right click on \
the extensions label, and then click "New Extension." If PostGIS isn't \
listed as a possible extension, then something went wrong in the PostGIS install. \
<br>
</span></div><div><span>You may want to then do an 'apt-get remove postgis' \
and then follow the instructions at: </span><a rel="nofollow" \
href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204" \
target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204</a>.</div>
<div>Thanks, Jeff<br></div><div><br><blockquote style="border-left:2px solid \
rgb(16,16,255);margin-left:5px;margin-top:5px;padding-left:5px"> <div \
style="font-family:arial,helvetica,sans-serif;font-size:10pt"> <div \
style="font-family:times new roman,new york,times,serif;font-size:12pt">
<div dir="ltr"> <font face="Arial"> <hr size="1"> <b><span \
style="font-weight:bold">From:</span></b> Smaran Harihar <<a rel="nofollow" \
href="mailto:smaran.harihar@gmail.com" \
target="_blank">smaran.harihar@gmail.com</a>><div>
<br> <b><span style="font-weight:bold">To:</span></b> PostGIS Users Discussion <<a \
rel="nofollow" href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a>> <br> </div>
<b><span style="font-weight:bold">Sent:</span></b> Wednesday, May 23, 2012 10:09 \
AM<div>
<br> <b><span style="font-weight:bold">Subject:</span></b> Re: [postgis-users] Ubuntu \
and Postgresql9.1.3-2<br> </div></font> </div> <br><div><div> \
<div>Hi,<div><br></div><div>I have already installed PostGIS 2.0 and Postgres 9.3.1 \
using synaptic package manager.</div><div><br></div><div>Now when I run your commands \
in psql console,</div><div><br></div><div><pre \
style="background-color:rgb(247,247,247);border:1px solid \
rgb(215,215,215);margin-right:1.75em;margin-left:1.75em;padding:0.25em;overflow:auto;font-size:13px">
shpRepo=# CREATE EXTENSION postgis;</pre><div>I am receiving an \
error,</div><div><br></div><div><font color="#ff0000">ERROR: could not open extension \
control file "/usr/share/postgres/9.1/extension/postgis.control": No such \
file or directory</font></div>
<div><font color="#ff0000"><br></font></div><div>Where did I go \
wrong?</div><div><br></div><div><br></div><br><div>On Wed, May 23, 2012 at 9:58 AM, \
Brian H Wilson <span dir="ltr"><<a rel="nofollow" href="mailto:brian@wildsong.biz" \
target="_blank">brian@wildsong.biz</a>></span> wrote:<br>
<blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div>On 5/23/2012 8:08 AM, José María Amuedo wrote:<br> \
<blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> \
Someone know how can linstall postgresql-9.1.3-2-linux.run in Ubuntu 12.04?<br> <br>
I installed it but I can not to launch stackbuilder to configure new<br>
tools like postgis.<br>
</blockquote>
<br></div>
As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've only \
used stackbuilder once. You don't really need it.<br> <br>
I like to experiment with the latest so currently I do install PostGIS from sources. \
The version in the official Ubuntu repository is still at 1.5.3<br> <br>
There are instructions here for PostGIS 2 packages that look pretty promising:<br>
<br>
<a rel="nofollow" href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204" \
target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204</a><br>
<br>
My own grueling details are here: <a rel="nofollow" \
href="http://wildsong.biz/index.php/PostGIS" \
target="_blank">http://wildsong.biz/index.php/PostGIS</a><br> Feedback welcome.<br>
<br>
Hope this helps,<br>
<br>
Brian<div><div><br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a rel="nofollow" href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.<u></u>refractions.net</a><br> <a \
rel="nofollow" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & \
Regards<div>Smaran Harihar</div><br> </div>
</div><br>_______________________________________________<br>postgis-users mailing \
list<br><a rel="nofollow" href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a><br>
<a rel="nofollow" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br><br> </div></div></div> </div> </blockquote></div> \
</div></div><br>_______________________________________________<br> postgis-users \
mailing list<br> <a rel="nofollow" \
href="mailto:postgis-users@postgis.refractions.net" \
target="_blank">postgis-users@postgis.refractions.net</a><br> <a rel="nofollow" \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & \
Regards<div>Smaran Harihar</div><br> </div>
</div><br><br> </div></div></div> </div> </blockquote></div> \
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & \
Regards<div>Smaran Harihar</div><br> </div>
</div><br><br> </div></div></div> </div> </blockquote></div> \
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & \
Regards<div>Smaran Harihar</div><br> </div><br><br> </div></div></div> </div> \
</blockquote></div> </div></div></blockquote></div><br><br \
clear="all"><div><br></div>-- <br>Thanks & Regards<div>Smaran Harihar</div><br> \
</div>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic