Marc Millas <marc.millas@xxxxxxxxxx> writes: > the data in the redhat 6.5 machine is NOT in Postgres, its in an old Oracle > instance, 4TB of it. > So I am working on a way to extract it to a file or, better to a pipe. > If I was able to get a local psql then, fine, i'll pipe the flow to it, > done.(almost...) > If no local postgres tool, as said, I will try to pipe data through the > network, > but this imply that data will be put exactly as psql, on the new machine, > will be able to 'ingest' it. I'm not really following why this requires any processing to be done locally on the old machine. You've got to shove the data over the network sooner or later, so why not sooner? regards, tom lane