Re: COPY to/from non-local file

[Enrico Sirola <enrico.sirola@xxxxxxxxx>]

Hi,

Il giorno 27/giu/07, alle ore 20:54, Jaime Silvela ha scritto:

The problem is that the getline/readline interface, which does exist for Ruby, doesn't seem to work so well, and anyway operates line by line; I would have preferred to just hand a file descriptor and be done with it.

Thanks for your suggestions too, Erik and Ted. Performance-wise the best solution may be a network mount as you suggest Erik.

I transfer some million rows (for like 20 tables) every day from a server to another.

The two servers are in two separated networks, with different security levels, so unfortunately

network mounts are not available. At the beginning I used to transfer record-by-record within

a python application hosted by the source server, but it took ages. At the end, 

some scripting around ssh proved to be enough. just put the public key file in

the .ssh/authorized_keys of the postgresql system user and you are done. You can transfer 

files without the need for a password, and it's perfectly scriptable

I hope it helps,

Enrico Sirola

enrico.sirola@xxxxxxxxx