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

[Willem]

Thank you thank you thank you from somewhere over the US.  I finally got it back together and working.  I am so relieved.  You all saved my bacon.  You are all fantastically awesome!

Now It's time to have a drink - phew!

Cheers



Sent from my iPad

> On Mar 18, 2014, at 4:58 PM, Stephen Woodbridge <woodbri at swoodbridge.com> wrote:
> 
> 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 <morten at sickel.net
>> <mailto: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
>>    <mailto: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
>>    <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
>>     >> > postgis-users at lists.osgeo.org
>>    <mailto: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 <mailto: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 <mailto: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