Re: restore without export/import

In message
<CAAtgU9Tvc+AgRR5_ojpCzvGn8JMvAvV9-63Q_+UPjifCQQ982A@mail.gmail.com> ,
Henry Drexler writes:
>I had to move to a new computer - however I was not able to do the steps in:
>http://www.roundup-tracker.org/docs/admin_guide.html#moving-a-tracker
>
>However I still have the:
>    tracker home folder
>and the
>    postgres database
>
>Is there a way to hook these up to work - or are you pretty much out of
>luck without doing the export/import?
>
>When just trying to hook them up I get the error:
>ProgrammingError: relation "schema" already exists    Python 2.7.5

What are you doing when this error happens?

>So yes, the question is:
>Outside of the export/import is there a way to marry the tracker home
>folder and the postgres database back together?

Make sure you have backups of the postgres database files (I assume
taken with the database turned off) and the tracker home
directory. That way if trying to put these things back together goes
wrong you have safe original copies of everything you need to try
again.

My first thoughts:

  Do you have the same version of roundup installed as before?

If not find the version you were using and install it replacing the
newer version.

Do you have the same postgres version?

Can you run "roundup-admin -i <path_to_home>" and connect to the
database and do something simple like list the status table?

If you use psql directly on the database, does the database look sane?
   * the roundup database exists when listed uisng \l
   * you can connect to the database
   * some tables show up when you do a \dt
   * select * on a small table (e.g. status) returns recognizable names etc.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.

------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk