h1. Converting database from sqlite to postgres

It may not be the best way but it worked for me. I used "taps":https://github.com/ricardochimal/taps gem for conversion.

First add taps gem to your foreman Gemfile

<pre>

gem 'taps'

</pre>

and run bundle install.

Then start taps server which will make your current sqlite accessible

<pre>

taps server sqlite:///path/to/foreman/db/development.sqlite3 user pass

</pre>

Make sure you have existing postgres DB, username and password ready. With this command you'll start copying data from sqlite to postgres.

<pre>

taps pull postgres://username:password@localhost/foreman http://user:pass@localhost:5000

</pre>

It will take few minutes (based on amount of data). You'll see the progress during the process.