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
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
