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.hari...@gmail.com>
>To: Jeff Meyer <j...@gwhat.org>; PostGIS Users Discussion
><postgis-users@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 <j...@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¤t=postgisextensions.png
>>
>>
>>
>>
>>>________________________________
>>> From: Jeff Meyer <j...@gwhat.org>
>>>
>>>To: PostGIS Users Discussion <postgis-users@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.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
>>>>>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
>>>
>>>
>>>
>>_______________________________________________
>>postgis-users mailing list
>>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