Re: scp in a multi-piped command?

From: Jared (jared_at_hwai.com)
Date: 02/02/04 

Date: 2 Feb 2004 05:02:33 -0800

Cool! Can't wait to try it Monday morning.

Thank you.

Kind regards,

Jared Hecker

Darren Dunham <ddunham@redwood.taos.com> wrote in message news:<FHgQb.5161$NF7.2585@newssvr29.news.prodigy.com>...
> Jared <jared@hwai.com> wrote:
> > Hi all,
>
> > I am trying to determine a means of:
>
> > exporting from Oracle |
> > passing it through gzip or compress |
> > transferring the file |
> > gzip -d or uncompress on the other end |
> > import into Oracle
>
> > It is very straightforward to take an Oracle export and pipe it to
> > 'compress'. This works, and is a well-known technique. What I want
> > to do is use scp in batch mode for the transfer.
>
> scp transfers files, not pipes. You'll want ssh.
>
> # run the ssh on the sending end.
> ls -l | compress | ssh host "uncompress > /file/location"
>
> # run the ssh on the receiving end
> ssh host "ls -l | compress" | uncompress > /file/location
>
> Or let ssh do the compression...
>
> ls -l | ssh -C host "cat - > /file/location"
>
> Just change the commands above with the ones you want.

Relevant Pages

  • dummynet for edonkey and ssh limiting
    ... so i can't do any limiting there. ... ssh, which is often used by outsiders to download from. ... ipfw pipe 1 config bw 800Kbit/s ... ipfw queue 1 pipe 1 weight 50 ...
    (comp.unix.bsd.freebsd.misc)
  • Re: debugging os.spawn*() calls
    ... >> spawned process, so I can't tell what's going wrong. ... > these days as I had a few problems using ssh with the os.* family ... remote command, and it does so if it can. ... I might rewrite os._spawnvef with a pipe. ...
    (comp.lang.python)
  • Re: exec and pipe
    ... should be passed to procmail via ssh. ... involved fails, or if the program exits with non-zero status. ... Closing a pipe also waits for the process ...
    (perl.beginners)
  • odd shell behavior after using ssh
    ... I have a ksh function, defined in my ~/.profile, I use to ssh to several ... nodes and just pipe the errpt to 'head -15'. ...
    (AIX-L)
  • Re: SSH Help
    ... There is also an Open-Source'd implementation of the Secure Shell at ... > You could set up an SSH server on your Oracle server and SSH clients on all ... > applications that need to access Oracle. ...
    (Security-Basics)