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

[Morten Sickel]

Did you accidentally upgrade postgis or postgres to a new minor version?
An apt-get autoremove (after having done a apt-get remove qgis) will only
remove dependencies that qgis have pulled in, I do not think it will
rollback anything to an older version - so I don't think that will help,
although it should not do any harm either.

As long as the database files still do exist, it should be possible to get
back to a working system using a few apt-gets and/or dpkg commands. So
just in case, shut down the postgres server and do a backup of
/var/lib/postgresql/9.3/data (or if you have put the database files
somewhere else you shoud know where they are) (use tar or some other
utility that gets the file ownerships and permissions right)

Do you have access to any other virtual or real machine? then you can
install postgres / postgis on that, stop postgres and just copy over the
database files.

Morten

Willem Buitendyk skrev:
> 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 --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