Loading SQLite files to postgreSQL with pgloader

The SQLite database is a respected solution to manage your data with. Its embeded nature makes it a source of migrations when a projects now needs to handle more concurrency, which PostgreSQL is very good at. pgloader can help you there. 

The Command

To load data with pgloader you need to define in a command the operations in some details. Here's our command: 

load database  
     from 'sqlite/Chinook_Sqlite_AutoIncrementPKs.sqlite'  
     into postgresql:///pgloader  
 
 with include drop, create tables, create indexes, reset sequences  
 
  set work_mem to '16MB', maintenance_work_mem to '512 MB'; 

You can see the full list of options in the pgloader reference manual, with a complete description of the options you see here. 

Note that here pgloader will benefit from the meta-data information found in the SQLite file to create a PostgreSQL database capable of hosting the data as described, then load the data.