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 <j...@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.hari...@gmail.com> > *To:* Jeff Meyer <j...@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-de...@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 <j...@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-de...@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.hari...@gmail.com> > *To:* Jeff Meyer <j...@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 <j...@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.hari...@gmail.com> > *To:* Jeff Meyer <j...@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 <j...@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.hari...@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 <br...@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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
