Migration from PostgreSql to Vertica

Moderator: NorbertKrupa

Post Reply
corcelli
Newbie
Newbie
Posts: 5
Joined: Thu Mar 26, 2015 12:34 pm

Migration from PostgreSql to Vertica

Post by corcelli » Thu Mar 26, 2015 12:43 pm

Im trying migrate a PostgreSql Database to Vertica, my database have 550 GB of data, I am using DBeaver to do that, but the process is slow and complicated for some incompatible DBeaver reasons, someone know another tool to accomplish this ? Thanks.

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Migration from PostgreSql to Vertica

Post by adrian.oprea » Thu Mar 26, 2015 1:55 pm

corcelli wrote:Im trying migrate a PostgreSql Database to Vertica, my database have 550 GB of data, I am using DBeaver to do that, but the process is slow and complicated for some incompatible DBeaver reasons, someone know another tool to accomplish this ? Thanks.
    • Create objects in Vertica(tbls)(alter data types, sort,etc)
    • Dump your Data out of PostgreSql into cvs files (ex:

      Code: Select all

       \copy tablename to 'filename' csv;
      )
    • Load a small sample of your data to validate it.
    • Load data using direct option and keep an eye on the rejected/exception data.
    • Run DBD(query,comprehensive,loading)
Done
trying so hard !!!

corcelli
Newbie
Newbie
Posts: 5
Joined: Thu Mar 26, 2015 12:34 pm

Re: Migration from PostgreSql to Vertica

Post by corcelli » Thu Mar 26, 2015 1:58 pm

I will try it right now!, thanks a lot!

corcelli
Newbie
Newbie
Posts: 5
Joined: Thu Mar 26, 2015 12:34 pm

Re: Migration from PostgreSql to Vertica

Post by corcelli » Thu Mar 26, 2015 2:08 pm

Adrian.oprea, vc é do rio! cara, como eu faço o load no vertica, no copy ele gera somente os dados em CVS, o cliente do vertica é muito limitado, não tem como fazer um load direto pra tabela, como seria esse import. ?

corcelli
Newbie
Newbie
Posts: 5
Joined: Thu Mar 26, 2015 12:34 pm

Re: Migration from PostgreSql to Vertica

Post by corcelli » Thu Mar 26, 2015 2:13 pm

Já deu certo, o próprio copy faz o load, obrigado brother!

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Migration from PostgreSql to Vertica

Post by adrian.oprea » Thu Mar 26, 2015 2:19 pm

Ola,
Sim sou do Rio mesmo ! Voce e Basileiro ?
Que bom que deu certo. Caso precisa de mais ajuda pode me escrever no pm.
Ou aqui no forum msm.
trying so hard !!!

corcelli
Newbie
Newbie
Posts: 5
Joined: Thu Mar 26, 2015 12:34 pm

Re: Migration from PostgreSql to Vertica

Post by corcelli » Thu Mar 26, 2015 2:32 pm

Cara, deu mas não deu :/ , estou migrando um banco de dados de um solução BI, optei pelo vertica por conta do MPP (uso de mais de um core por processo) e fazer o load desses dados está dando dor de cabeça, fiz agora o copy from, aparentemente tudo ok, mas ele não carrega nada na tabela, e não apresenta erro, notei algumas particularidades nessa migração, mas enfim, se ele pelo menos apresentasse o erro dava pra correr atrás, mas ele simplesmente não reporta nada.

Post Reply

Return to “Vertica Database Administration”