Create Postgres RDS with rake db:create:all

Question

I have an app that I am migrating to Deis and want to use RDS for my Postgres instance. I have Postgres set up but if i run rake db:create:all from my local machine, configured to point to RDS, I get:

This task only modifies local databases. <db_name> is on a remote host.

Is there a way to create the DB from an existing migration or the schema.rb file?

Update 1 Here is the database.yml file. All environments inherit the default

default: &default
adapter: postgresql
encoding: utf8
pool: 5
username: <db user I created>
password: <PW>
host: <my_unique_host>.us-east-1.rds.amazonaws.com
port: 5432

Update 2 For the comment about just creating the DB then running db:migrate like normal, this is exactly the behavior I am not seeing. If I have the DB active and run rake db:migrate, the process completes and I am presented a new terminal line. No tables/columns are created.

Am I better off trying to do a local DB dump and restoring it into RDS?

Update 3: Solution I have resolved this and wanted to share my learnings:

It appears that running the rake db:migrate command from a remote host was not working. This may be possible but I was not able to figure it out.
What solved it was actually SSH'ing into the app container in the Deis cluster and running rake db:create and rake db:migrate. This ack'd back saying the table was created and I was able to verify in the psql prompt.

Hopefully this helps.

Can you post your database.yml?

Zahid
– Zahid

2015-09-19 01:17:52 +00:00
Commented Sep 19, 2015 at 1:17 — Zahid
– Zahid, Commented Sep 19, 2015 at 1:17

Zahid · Accepted Answer · 2015-09-19 01:29:30Z

2

You will have to do manually the part done by rake db:create:all[1], so connect to the DBMS and create the db by running command

CREATE DATABASE db_name CHARACTER SET utf8;

migration can be done in normal way via rake db:migrate

answered Sep 19, 2015 at 1:29

Zahid

1,8504 gold badges19 silver badges27 bronze badges

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

1 Comment

smugcloud Over a year ago

See my second update above. This does not seem to do anything.

smugcloud · Accepted Answer · 2015-09-21 20:12:43Z

2

Update 3: Solution I have resolved this and wanted to share my learnings:

It appears that running the rake db:migrate command from a remote host was not working. This may be possible but I was not able to figure it out.
What solved it was actually SSH'ing into the app container in the Deis cluster and running rake db:create and rake db:migrate. This ack'd back saying the table was created and I was able to verify in the psql prompt.

Hopefully this helps.

answered Sep 21, 2015 at 20:12

smugcloud

6271 gold badge11 silver badges18 bronze badges

Comments

Artur INTECH · Accepted Answer · 2023-02-15 09:00:27Z

0

ActiveRecord::Tasks::DatabaseTasks::LOCAL_HOSTS << "192.168.1.1" # Replace with the IP you want to connect from

P.S. Keep in mind, it is a dirty hack which may stop working anytime, since it alters a constant.

edited Feb 15, 2023 at 9:00

answered Jul 18, 2020 at 17:26

Artur INTECH

7,5833 gold badges49 silver badges41 bronze badges

Collectives™ on Stack Overflow

Create Postgres RDS with rake db:create:all

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related