I want to copy vertica database from test cluster to qa cluster. Test and QA have different number of nodes.
Vertica documentation says we should have same number of nodes for this copy to work.
https://my.vertica.com/docs/7.0.x/PDF/H ... sGuide.pdf
Are there any other workarounds to make this happen? If there are none, I think this will be a severe limitation as we may not always have same
number of nodes across different regions.
Thx,
Giri
Copying the Database to Another Cluster
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Copying the Database to Another Cluster
Maybe you can look into the EXPORT TO VERTICA functionality?
https://my.vertica.com/docs/7.0.x/HTML/ ... ERTICA.htm
https://my.vertica.com/docs/7.0.x/HTML/ ... ERTICA.htm
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Copying the Database to Another Cluster
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:08 pm, edited 1 time in total.
Re: Copying the Database to Another Cluster
Agreed with Skwa,
Lets not call it a limitation, it is part of smart design of product's Backup and Restore feature.
And for the workaround , Vertica gives this feature / tool to export your data from one cluster to another, using Export to Vertica options.
Hope this helps
Lets not call it a limitation, it is part of smart design of product's Backup and Restore feature.
And for the workaround , Vertica gives this feature / tool to export your data from one cluster to another, using Export to Vertica options.
Hope this helps