Backup Vertica to S3

Moderator: NorbertKrupa

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Backup Vertica to S3

Post by chenshaulian » Thu Aug 11, 2016 9:06 am

Thanks

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Backup Vertica to S3

Post by chenshaulian » Sun Aug 14, 2016 12:30 pm

Hi Victor,

I think I misunderstood, (sorry for the bothering)... just copy the files that in data and catalog folder to S3?
Because I didn't find any document on backup\ restore vertica database with the Vertica catalog , data, and temp directories...

Or you mean to use the data that we have on HDFS (before we copy to vertica), and just load this data to new cluster...?

Victorgm
Beginner
Beginner
Posts: 25
Joined: Fri Jul 17, 2015 2:22 pm

Re: Backup Vertica to S3

Post by Victorgm » Mon Aug 22, 2016 4:18 pm

I was referring to data files that were used to load the Vertica cluster. In your case, it sounds like that would be the HDFS files.

I highly recommend you read Ralph Kimball's Data Warehouse Toolkit. It is a free PDF, but don't be fooled by the word "free" - it is a real book, the technical writing is some of the best I've ever seen, and very dense with info. Google it to find free downloads. The first edition was written a while ago for row-oriented SQL databases, but the concepts translate easily to Vertica. I recommend everyone read all of Kimball's books.

Post Reply

Return to “Vertica Database Administration”