How to migrate from sqlite to psql db

JupyterHub Zero to JupyterHub on Kubernetes
,
1

Hi Team,

We are using jupyterhub on k8 using helm charts. It is running fine with the default sqlite database. Now, we want to migrate the sqlite db to psql db along with the sqlite db data.

We have went through many docs, but there is no clear understanding on how to do it.
https://jupyterhub.readthedocs.io/en/0.7.2/upgrading.html

pls note- we are able to connect and initialise the jupyterhub with new psql db, but we are not able to migrate the sqlite db data to psql db.

we have tested pglooader- the issue with it is, after migrating it is changing the primarykeys and foreign key names.

any leads on the db migration will help us.

Thanks,
Vijay

2

Data types are different between SQLite and PostgreSQL and you need to translate them during migration. This SO thread is a good resource to how to make those translations.

1 Like