We have two Vertica hosts sitting on two AWS clusters. We are planning to migrate data from one Vertica host to the other one.
From Vertica document, I can use command COPY FROM VERTICA or EXPORT TO VERTICA to perform the data migration. I first call CONNECT TO VERTICA command to establish connection between two hosts, however it returned error below. Do I need to set up some configuration? Thanks.
ERROR 2823: Could not connect to server [myhost]: Operation now in progress
Is the server running and accepting
TCP/IP connections on port 5433?
Migrate data from one Vertica host to another Vertica host
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Migrate data from one Vertica host to another Vertica ho
Follow the guide on using private and public networks to configure an interface and nodes for Vertica to export/import on.
Checkout vertica.tips for more Vertica resources.
Re: Migrate data from one Vertica host to another Vertica ho
Thanks norbertk!