Hi all! I need to migrate from my Sqlite3 DB to Postgresql DB. Do you know any good guide to do this? Thanks in advance.

You could try with the simplest:

pgloader sqlite:///path/to/file.db <pgsql://pguser@pghost/dbname>

after creating your empty postgres database

Thanks @kennyadsl. But in my

db/

folder I have not the extension .db, I have .sqlite3 extension.

I think it might work anyway

thanks.

Nice!

Now, I have the data converted to Postgresql. But I need to remove the sqlite3 gem from my Gemfile and add the Postgres gem to it;

gem "pg"

. And I need to modify the `config/database.yml`file. Do you know where can I find a database.yml template with the correct postgres configuration? I've found some of them but they are diferent and I dont know wich is the correct. Thanks in advance.