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

[Jeff Meyer]

Hi Samran - 

I'm relatively new to these parts, but I think the answer depends on how much data you're trying to migrate from prior versions of Postgres. If you're just getting started with PostGIS, I'd remove all of those packages and follow the instructions linked below. After that, go ahead and reinstall GeoServer. It should see that you've already install Postgres and PostGIS and be just fine. (I think...) If you need to migrate data, SQL scripts, etc., I'd suggest you read up on migration or get some other advice. I'd like to help, but don't have any experience in those areas.
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: Wednesday, May 23, 2012 2:13 PM
>Subject: Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
> 
>
>Thanks for the reply Jeff.
>
>
>The extensions in my database is only plpgsql. Nothing else. Also I did not separately install PostGIS. I installed it along with GeoServer using the Synaptic. The complete list of installed packages are as follows,
>1. postgresql 9.1 + postgis 1.5.3
>2. postgis 1.5.3
>3. postgresql 8.4 + postgis 1.5.3
>4. opengeo-postgis 2.4.4
>
>
>I did not install any from the source as in the wiki link you gave. So If I remove, which ones should I remove?? Also since I need it to be connected to Geoserver will removing the package affect the opengeo suite?
>
>
>Thanks & Regards,
>Smaran Harihar
>
>
>On Wed, May 23, 2012 at 12:45 PM, Jeff Meyer <jeff at gwhat.org> wrote:
>
>Mean to add this before - it's an image of the Extensions folder in pgAdmin III: http://s1064.photobucket.com/albums/u361/jeffmegwhat/?action=view&current=postgisextensions.png
>>
>>
>>
>>
>>>________________________________
>>> From: Jeff Meyer <jeff at gwhat.org>
>>>
>>>To: PostGIS Users Discussion <postgis-users at postgis.refractions.net> 
>>>Sent: Wednesday, May 23, 2012 12:42 PM
>>>
>>>Subject: Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
>>> 
>>>
>>>
>>>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
>>>>>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
>>>
>>>
>>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
>
>-- 
>Thanks & Regards
>Smaran Harihar
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120523/fb4f368d/attachment.html>