Is there any recommended steps to migrate sqlite data to postgresql

Dear Smith,
You have 2 options:

1. take a complete backup of survey(s) and data from the Backup / Restore module in Collect and restore the backup in the new installation of Collect, the one using PostgreSQL
2. export the content of the database from SQLite to SQL, using for example a software like SQLite browser, that is free, modify the generated SQL and try to restore it into PostgreSQL; the structure of databases is similar, you shouldn't have big issues (skip the part of the database/schema/tables generation while restoring it).

We suggest you to use the first option, that is probably faster.
Let us know, many thanks.
Open Foris Team

Dear Smith,
If you have a small number of surveys in your installation of Collect, the easiest thing would be to take a Backup of each survey and Restore it in the new installation of Collect.
You can easily do it from the Backup/Restore module in the application.
Many thanks,
Open Foris Team