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 <[email protected]> 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 <[email protected]> > 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 > >> > [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 > >> > > > > > _______________________________________________ > 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
