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>