List Info

Thread: exporting importing tracdb postgres db




exporting importing tracdb postgres db
country flaguser name
United States
2007-09-05 20:54:37

Folks,

I am trying to export => import a trac postgres database ...


tried ....


export ====      pg_dump --data-only --format=c trac > tracdata

import ====     pg_restore --data-only --format=c /home/lprgo1/tracdata


If you do a table by table  ...  select * from tablename;      the data looks good ...  but it does not apear to map in the trac instance ... ????

Any clues anyone on what the problem may be or suggestions for a better way to dump the data from the one postgres  and restoring (importing)
the data to the other trac postgres database ?

Appreciate any help. Thanks !!


Best Regards,
 
Joe
 
________________________________________________________________________________________
Joseph H. Dayney | Contract Software Engineer | RR Donnelley
630W 1000N | Logan, UT 84321 | (: 435-755-4278 | È: 801-608-1052 | Ê: 435-755-4210 | *: rrd.com>joseph.h.dayneyrrd.com
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
  --~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users"; group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to trac-users-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Re: exporting importing tracdb postgres db
country flaguser name
United States
2007-09-05 22:15:46
What errors do you get, or what are the problems in the
target database after the restore command? Trac has such a 
nice simple database schema that I doubt the problem is
anything Trac-specific. A postgres expert would probably 
want to know what version of postgres you're in, what's in
the target database before the restore, and that kind of 
thing.

=-=-> Jenn Drummond // jennrice.edu


On Wed, Sep 05, 2007 at 07:54:37PM -0600,
joseph.h.dayneyrrd.com wrote:
> Folks,
> 
> I am trying to export => import a trac postgres
database ... 
> 
> 
> tried ....
> 
> 
> export ====      pg_dump --data-only --format=c trac
> tracdata
> 
> import ====     pg_restore --data-only --format=c
/home/lprgo1/tracdata
> 
> 
> If you do a table by table  ...  select * from
tablename;      the data 
> looks good ...  but it does not apear to map in the
trac instance ... ????
> 
> Any clues anyone on what the problem may be or
suggestions for a better 
> way to dump the data from the one postgres  and
restoring (importing) 
> the data to the other trac postgres database ?
> 
> Appreciate any help. Thanks !!
> 
> 
> Best Regards,
>  
> Joe
>  
>
____________________________________________________________
____________________________ 
> 
> Joseph H. Dayney | Contract Software Engineer | RR
Donnelley
> 630W 1000N | Logan, UT 84321 | (: 435-755-4278 | ?:
801-608-1052 | ?: 
> 435-755-4210 | *: joseph.h.dayneyrrd.com
>  
> This email and any files transmitted with it are
confidential and intended 
> solely for the use of the individual or entity to whom
they are addressed. 
> Any unauthorized review, use, disclosure or
distribution is prohibited. If 
> you are not the intended recipient, please contact the
sender by reply 
> e-mail and destroy all copies of the original message.

>  
> > 
> 
> 
> !DSPAM:5814,46df5df1315198414610956!

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Trac Users" group.
To post to this group, send email to trac-usersgooglegroups.com
To unsubscribe from this group, send email to
trac-users-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )