Skip to content

Sqlite to Postgres Migration

7sempra edited this page Jul 22, 2017 · 4 revisions
  1. Pull down the latest changes
  2. Install & prepare Postgres
  3. Open your .env file, add the following line:
    DATABASE_URL=postgres://<username>@localhost:<port>/eve_roster
    Replace <username> with your username on the development machine, <port> with the Postgres port, probably 5432.
  4. Compile the server:
    $ npm run build-server
  5. Update the new database:
    $ nf run npm run updatedb
  6. Run the migration script:
    $ nf run node out/bin/importSqliteToPostgres.js
  7. Start the server as usual:
    $ nf start