> Say we have a 7GB database.  Is there a way to way to use 2 tape
> drives...  Argh, I guess not, since the Unix pipe mentality presumes
> that the mode of operation will be:
>   $ pg_dump /some/database | tar cvfz /dev/st0/db.tgz
> 
> What would be darned useful (but only, I think, with heavy usage of
> tablespaces) is:
>   $ pg_tapedump /some/database /dev/st0,/dev/st1,/dev/st2,/dev/st3

Would passing the --multi-volume option be useful to you?

http://www.apl.jhu.edu/Misc/Unix-info/tar/tar_97.html

Regards,

Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to