Tracks sqlite to pg

Post tags: | postgresql | sqlite | tracks_gtd | tracks_sql |

stackoverflow.com article

See pgloader answer first

pgload home page

pgloader.io article Loading SQLite files with pgloader

configuration to use postgresql

create branch for db move


        tracks git:(local-master) git checkout -b 20160402-sqlite-to-pg
  • local-master
    • local-live
    • 20160402-sqlite-to-pg

Note files ignored by git

  • config/database.yml
  • config/deploy.rb
  • config/site.yml
  • /db/*.db
  • /db/*.sqlite3
  • db/data.yml