Roughly:
mknod my_pipe1 p mknod my_pipe2 p nohup compress < my_pipe1 > my_pipe2 & nohup split -m 2000 < my_pipe1 & nohup pg_dump > my_pipe1 &
How about
pg_dump | split -m 2000
?
Regards, Bjoern
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match