Skip site navigation (1) Skip section navigation (2)

Re: Possible TODO item: copy to/from pipe

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Possible TODO item: copy to/from pipe
Date: 2006-06-04 21:39:17
Message-ID: 87hd30bny2.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Andreas Pflug <pgadmin(at)pse-consulting(dot)de> writes:

> Bruce Momjian wrote:
> >
> > For use case, consider this:
> >
> >  	COPY mytable TO '| rsh x(at)y(dot)com > test ';
> >
> > so you can COPY to another server directly.
> >
> Why not rsh psql -c "\copy foobar to test" ?

Who knows? The sysadmin could have any reason to prefer one to the other. 

One that comes to mind is that he or she may want to automate this and may be
happier granting password-free access to a filesystem server that just holds
encrypted backups than to the live production database.

-- 
greg


In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2006-06-04 21:40:31
Subject: Re: 'CVS-Unknown' buildfarm failures?
Previous:From: Greg StarkDate: 2006-06-04 21:34:47
Subject: Re: More thoughts about planner's cost estimates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group