Changing database names from SQlite3 to Postgres

Question

I am currently trying to switch from SQlite3 to Postgres, and was wondering how I can change my database name? According to Heroku, they say this:

Note the adapter name is postgresql not postgres or pg. You will also need to change the database: to a custom name. A final version might look something like this:

development:
  adapter: postgresql
  database: my_database_development
  pool: 5
  timeout: 5000
test:
  adapter: postgresql
  database: my_database_test
  pool: 5
  timeout: 5000

production:
  adapter: postgresql
  database: my_database_production
  pool: 5
  timeout: 5000

I see right now that I have the following for my database name for test environment:

test:
  <<: *default
  database: db/test.sqlite3

For this (and dev and production environments) do I need to simply change the name of the database, or do I need to do something more than this. Because for the SQLite3 files, it has a .sqlite3 extension. Does postgres have a similar situation?

Tomislav Mikulin · Accepted Answer · 2017-08-25 20:05:30Z

1

Yes, you can just change the database name for each additional environment. The

<<: *default

means that is the part of the configuration that will be used in the other environments, so you don't have to duplicate your code (DRY).

For postgres you don't have to give extensions (as I remember). Just give the databases clear names, and that should work.

answered Aug 25, 2017 at 20:05

Tomislav Mikulin

6,0935 gold badges27 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jack Moody Over a year ago

Perfect! Worked great. There is no reason to set database names in ENV variables, is there?

Collectives™ on Stack Overflow

Changing database names from SQlite3 to Postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related