Converting database from sqlite to postgres¶
It may not be the best way but it worked for me. I used taps gem for conversion.
First add taps gem to your foreman Gemfile
and run bundle install.
Then start taps server which will make your current sqlite accessible
taps server sqlite:///path/to/foreman/db/development.sqlite3 user pass
Make sure you have existing postgres DB, username and password ready. With this command you'll start copying data from sqlite to postgres.
taps pull postgres://username:password@localhost/foreman http://user:pass@localhost:5000
It will take few minutes (based on amount of data). You'll see the progress during the process.