Re: restore without export/import

On Wed, Jul 10, 2013 at 5:02 PM, John P. Rouillard <[email protected]>wrote:

>
> >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?
>

On the new computer, I went into postgres (same version as I used before)
and restored the roundup database from a backup.  I created the roundup
user.
Then I placed the 'tracker home' folder in my home directory.
I then went into the terminal and entered:
roundup-server support=/home/username/roundup_automation_app/

Then I went to http://localhost:8080/
and received that error above.

Postgres and roundup versions are the same as they were before.


> Make sure you have backups of the postgres database files (I assume
> taken with the database turned off) and the tracker home
> directory.


Yes, these are the two pieces I have.


> That way if trying to put these things back together goes
> wrong you have safe original copies of everything you need to try
> again.
>

Indeed.


> My first thoughts:
>
>   Do you have the same version of roundup installed as before?
>

Yes


> Do you have the same postgres version?
>

Yes


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

I have not tried this - will do.  Previously I just connected through psql
and looked around and everything looked fine.


> 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.
>

I have done the first few but not the last - thanks for the ideas.

--
>                                 -- rouilj
> John Rouillard
>

Thanks for your help


On Wed, Jul 10, 2013 at 5:09 PM, Tom Ekberg <[email protected]> wrote:

> Henry,
>
> You could use pg_dump to dump the database, and use pg_restore to put the
> data in another database.
>
> Tom Ekberg
> Senior Computer Specialist, Lab Medicine
> University of Washington Medical Center
> 1959 NE Pacific St, MS 357110
> Seattle WA 98195
> cell: (253) 561-2509
> email: [email protected]
>
>
> On Wed, 10 Jul 2013, Henry Drexler wrote:
>
>  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<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
>>
>>
>> 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?
>>
>> Thanks in advance.
>>
>>
>>

------------------------------------------------------------------------------
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

_______________________________________________
Roundup-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/roundup-users