Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Update] Instructions for migrating data from existing PG table #627

Open
mfreed opened this issue Dec 23, 2020 · 1 comment
Open

[Update] Instructions for migrating data from existing PG table #627

mfreed opened this issue Dec 23, 2020 · 1 comment
Labels

Comments

@mfreed
Copy link
Member

mfreed commented Dec 23, 2020

Our docs provides isntructions for migrating from the same database, but appears to have been written prior to the support for migrate_data in a hypertable. Specifically, it suggests creating a second table, then running INSERT INTO new_table SELECT * FROM old_table;

https://docs.timescale.com/latest/getting-started/migrating-data#same-db

We should update these instructions to instead just point at migrate_data feature/parameter of hypertables:

https://docs.timescale.com/latest/api#create_hypertable

@rept
Copy link

rept commented Dec 30, 2020

Definitely! Didn't know this was possible. Since this saves people from having to over dimension their machines in order to migrate. Is it also possible to immediately convert an existing table to a hypertable with compression as well?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants