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

[Willem Buitendyk]

The wifi on the plane is a lot erratic.  How could I check if I still have
the data?  I'll certainly perform a backup as you suggest.  I don't have a
separate virtual machine unfortunately.  I have far too many other systems
associated to the current server, ip address, etc


On Tue, Mar 18, 2014 at 1:03 PM, Morten Sickel <morten at sickel.net> wrote:

> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140318/b96d4e6f/attachment.html>