Migrating sqlite3 to postgres in rails app

Question

I have read several posts and watched the railscast on migrating from sqlite3 to pg and all of them seem to have conflicting settings and I have not seen anyone run into the error I'm getting. I have data locally that i do NOT care about. If it gets destroyed that's fine.

Here is what I have done.

Changed database.yml from this:

development:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000

To this:

development:
adapter: postgresql
database: app_name_database
pool: 5
timeout: 5000

One thing I did notice about this file and some of the examples is that I do not have encoding, username, or password. Is this necessary?

I updated my gem file from this:

group :production do
 gem 'pg'
 gem 'rails_12factor'
end

group :development do
 gem 'sqlite3'
end

To this:

group :production do
 gem 'pg'
 gem 'rails_12factor'
end

group :development do
 gem 'pg'
end

Following the instructions - the railscast says to rake db:create:all. However, when I run this I get the following error in console:

could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

Any ideas on what I'm doing incorrectly? Are there rake tasks that need to be done before this?

Thanks

Have you installed and configured PostgreSQL locally?

Simone Carletti
– Simone Carletti

2014-01-09 21:44:19 +00:00
Commented Jan 9, 2014 at 21:44 — Simone Carletti
– Simone Carletti, Commented Jan 9, 2014 at 21:44
Yeah - psql --version is psql (PostgreSQL) 9.1.9

brad
– brad

2014-01-09 21:48:43 +00:00
Commented Jan 9, 2014 at 21:48 — brad
– brad, Commented Jan 9, 2014 at 21:48

user1854802 · Accepted Answer · 2014-01-09 22:12:54Z

1

Have you started the Postgresql database ? This is how I start mine - pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start ?

answered Jan 9, 2014 at 22:12

user1854802

3883 silver badges14 bronze badges

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

4 Comments

brad Over a year ago

so you run from the command line: "pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start" and it starts your pg server?

user1854802 Over a year ago

Unlike SQLite which staarts automatically you need to start Postgresql, at least in developmetn, whenver you start work for the day. Further info postgresql.org/docs/9.1/static/server-start.html - Pierre

brad Over a year ago

This was it. Railscasts failed to mention that. Make sure pg is started before rake db:create:all. thanks!

user1854802 Over a year ago

apologies comannd is - pg_ctl -D /usr/local/var/postgres stop -s -m fast 2- Also you can (I haven't done so) start the database as part of the autostart - see blog.willj.net/2011/05/31/…

Collectives™ on Stack Overflow

Migrating sqlite3 to postgres in rails app

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related