Cassandra to Postgres migration?

[Patrick Pierson]

I am currently running 0.8.3 on cassandra but considering a move to postgres.  Is there any migration documentation? 

[Marco]

There is an unofficial way in this branch (https://github.com/Mashape/kong/tree/feature/import-export) which exposes a new "kong transfer" command.

I would reccomend starting a new 0.8.3 cluster on the side with Postgres, execute the "transfer" command from the current cluster to the new cluster, and make sure that everything has been transferred properly. After the transfer, you could also upgrade to 0.9 on the new cluster (highly recommended).

Worst case: not all the data will be transferred to the new cluster, but nothing will happen to your old cluster, so you are safe to try "kong transfer --from OLD_CLUSTER:8001 --to NEW_CLUSTER:8001".

 Marco Palladino | CTO @ Mashape | mashape.com | +1 (415) 361-3858

On Tue, Aug 30, 2016 at 1:43 PM, Patrick Pierson <patrick....@gmail.com> wrote:

I am currently running 0.8.3 on cassandra but considering a move to postgres.  Is there any migration documentation? 

--
You received this message because you are subscribed to the Google Groups "Kong" group.
To unsubscribe from this group and stop receiving emails from it, send an email to konglayer+unsubscribe@googlegroups.com.
To post to this group, send email to kong...@googlegroups.com.
Visit this group at https://groups.google.com/group/konglayer.
To view this discussion on the web visit https://groups.google.com/d/msgid/konglayer/09653b8b-94c3-4a69-a65a-47db3dbc08cd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Patrick Pierson]

I did some digging and found a solution that I figured I would post in the event anyone else is looking for cassandra to postgres migration:

https://github.com/mybuilder/kongfig Is described as "Declarative configuration for Kong" however it has a dump and apply option that worked perfectly.

> kongfig dump --host api-using-cassandra:8001 > config.yml

> kongfig apply --path config.yml --host api-using-postgres:8001