[postgis-users] Urgent help needed, messed up my postgis 2.1 server by installing latest QGIS pacake

[Stephen Woodbridge]

I'm certainly not an expert in this, but here is what I would do:

1. shutdown postgresql
2. rsync or tar a copy of the postgresql data so you have a backup
3. it should be safe to apt-get remove all the packages that are in question
4. mv the data directory data-old
5. reinstall the packages that you had installed before, this may 
reinitialize the database (hence moving it away above)
6. stop the database again
7. mv data-old to data
8. restart the database

With any luck, you will be back running again as before. If one of the 
packages you installed in your oops, installed the database and it 
reinitialized it then it is likely that all the data was wiped. 
Hopefully, all you tables are there and you just have a mix of 
incompatible libraries that you need to clean up.

-Steve

On 3/18/2014 3:38 PM, Willem Buitendyk wrote:
> Hi all,
>
> I'm currently sitting on a plane having made a huge mistake yesterday.
>   I have a server that runs constantly, supplying data to clients on a
> daily basis.  The server is Ubuntu 12.04 and I had successfully
> installed and have been running PostGIS 2.1 and Postgresql 9.3 for the
> last 3 months.  Prior to leaving for my vacation I thought it would be
> great to install QGIS so I could remotely view my database.  The problem
> is the QGIS install altered my postgis and libgdal1 dependencies.
>
> Here are the commands I issued that got me into this mess:
>
> sudo apt-get update
>
> sudo apt-get install qgis pythin-qgis
>
> sudo apt-get install qgis python-qgis
>
> sudo apt-get install qgis
>
> sudo apt-get install python-qgis
>
> gpg --keyserver keyserver.ubuntu.com <http://keyserver.ubuntu.com>
> --recv 47765B75
>
> gpg --export --armor 47765B75 | sudo apt-key add -
>
> sudo apt-get install qgis python-qgis
>
> sudo apt-get update
>
> sudo apt-get install qgis python-qgis
>
> sudo apt-get install python-software-properties
>
> sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
>
> sudo apt-get update
>
> sudo apt-get install qgis python-qgis qgis-plugin-grass
>
> sudo apt-get install libssl0.9.8
>
>
> I am uncertain how to proceeed because I remember something similar
> happening years ago (irony of ironies) and it ended up corrupting my
> Ubuntu server when I tried to repair.
>
>
> I'm looking for some sage advise to correct this a painless as possible.
>   Is it safe to perform an apt-get autoremove?
>
> Please help an overstressed dad enjoy his vacation trip to Disney with
> his wife and kids.  I promise I won't go installing packages all willy
> nilly in the future.
>
>
> Thanks
>
>
> Willem
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>