This will tell you where your data is located: su grep data_directory /etc/postgresql/9.3/main/postgresql.conf du -sh /var/lib/postgresql/9.3/main/* cd /var/lib/postgresql/9.3/ tar -czf /var/lib/postgresql/9.3/backup-20140318.tgz main
Based on what you reported, I would apt-get remove the packages you installed and then apt-get install --reinstall the postgis packages.
and then restart the DB and see if you can get to your data. -Steve On 3/18/2014 4:42 PM, Willem Buitendyk wrote:
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] <mailto:[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] <mailto:[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 <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] <mailto:[email protected]> >> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] <mailto:[email protected]> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > _______________________________________________ postgis-users mailing list [email protected] <mailto:[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
