copy from vertica over ssh tunnel
I have a three node cluster and I want to copy the data from that cluster to a single node vertica instance. I only have ssh access between the databases, so if I wanted to use the copy from vertica command, I have to setup port forwarding. I can then connect from the single node instance to one of the cluster nodes using local forwarding, but when I issue the copy from vertica command, it says connection timed out. On the cluster, it says (vertica.log) that it timed out to port 5433.
This makes me wonder what communications are taking place, and if it is even possible to copy the data if the normal communication ports aren't open. Any thoughts?