Page 1 of 1
migrating data with identity columns
Posted: Wed Mar 30, 2016 11:07 am
by sreediff
How to migrate tables having identity columns and keep the number same across both servers?
Re: migrating data with identity columns
Posted: Wed Mar 30, 2016 11:42 pm
by JimKnicely
Hi,
Check out the documentation for "Copying Data" and see if it helps It explains how to copy tables that have identity columns.
https://my.vertica.com/docs/7.2.x/HTML/ ... ngData.htm
Re: migrating data with identity columns
Posted: Thu Mar 31, 2016 6:16 am
by sreediff
Thanks Jim,
I don't have connectivity set up between servers
dbadmin=> CONNECT TO VERTICA <> USER dbadmin PASSWORD '<>' ON 'ip_address',5433;
CONNECT
dbadmin=> COPY test_1 FROM VERTICA test_1 DIRECT;
dbadmin=> COPY test_1 FROM VERTICA test_1 DIRECT;
ROLLBACK 4236: One or more nodes did not open a data connection to this node. This may indicate a network configuration problem. Check that the private interfaces used for communication among the cluster hosts reside in the same subnet and are returned first by host address lookup
ERROR 4789: [dbname] Statement is canceled
To avoid this issue i plan to manually create dump in csv file and import the data from csv in another server.