Re: [Treebase-devel] db2->pg data transfer

[Mark D. <mj...@ge...>]

On Fri, 2009-05-29 at 11:12 -0400, Jon Auman wrote:
> 
> rsync will work fine for me if we need incremental updates, otherwise  
> scp is faster.

I like rsync because it's easier to restart if the transmission is
interrupted partway through.  With scp you get to start over again, or
keep track separately of how far you got.  But I guess you already know
that.  We can probably do the initial transfer by scp'ing compressed
files, and then use rsync for any later updates.

> Unless I hear otherwise from Hilmar, I'm assuming that person will be  
> me. 

Excellent, thanks.

> If the SQL inserts all contain UTF8 characters, then there should be  
> no problem with the import into a UTF8 postgresql database. If there  
> are non-UTF8 characters in the SQL file,

I'm not sure what that would mean.  What is a "non-UTF8 character"?


-- 
Mark Jason Dominus                               mj...@ge...
Penn Genome Frontiers Institute                         +1 215 573 5387