[postgis-users] Ubuntu and Postgresql9.1.3-2

Thu May 31 10:46:21 PDT 2012

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 at 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 at gmail.com>
> *To:* Jeff Meyer <jeff at 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 at 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 at 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 at 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 at 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 at jeffme-vbox:~$
>
>
> Good luck - be careful out there!
> Jeff
>
>
>
>   ------------------------------
> *From:* Smaran Harihar <smaran.harihar at gmail.com>
> *To:* Jeff Meyer <jeff at 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 at 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 at 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 at 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 at gmail.com>
> *To:* Jeff Meyer <jeff at gwhat.org>; PostGIS Users Discussion <
> postgis-users at 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 at 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 at gmail.com>
>
> *To:* PostGIS Users Discussion <postgis-users at 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 at 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 at postgis.**refractions.net<postgis-users at postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> --
> Thanks & Regards
> Smaran Harihar
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120531/fdeae476/attachment.html>