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

[Willem Buitendyk]

Ok I'm having trouble finding the data directory.  I know the data is
somewhere because I can access non-postgis data still in the database.  I
can even get a count back on the postgis data tables. I have a
/var/lib/postgresql/9.3/main/base directory but no data directory.


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

> If you installed postgres using apt-get, the data files should be in
> /var/lib/postgres/9.3/data postgres is usually quite good at not messing
> up data during upgrades, but just in case, I would make a quick backup. if
> you do a sudo du -s /var/lib/postgres/9.3/data/base/* you should see at
> least three directories - one of them contains your entire database, if it
> is less than three there or none of them has a reasonable size, you may be
> in trouble... (unless you have set up postgres to store data somewhere
> else) If you have installed postgres through make /make install, the
> databases may be stored somewhere else.
>
> Morten
>
>
>
> Willem Buitendyk skrev:
> > 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
> >>
> >
>
>
> _______________________________________________
> 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/7aca9293/attachment.html>