Rails db:migrate with postgres running in a container

Question

In my dev env I have postgres running in a container, running db:migrate worked fine until recently I needed to change the schema to sql

config.active_record.schema_format = :sql

Not when I run db:migrate I get the following error:

pg_dump: [archiver (db)] connection to database "mydatabase" failed: FATAL:  password authentication failed for user "myuser"

Looks to me that pg_dump ignores the database.yml settings. Anyone else had any luck with this kind of setup?

Calin · Accepted Answer · 2017-11-01 06:34:49Z

2

What I ended up doing is install postgresql-client-common and postgresql-client, in ubuntu you use:

sudo apt install postgresql-client-common postgresql-client

This gave me pg_dump locally, then I've opened a terminal in the docker machine and add host all all 0.0.0.0/0 trust to the default pg_hba.conf file

To open a shell use:

docker exec -i -t <idOfContainer> /bin/bash

To add the line:

cd /var/lib/postgresql/data
echo host all all 0.0.0.0/0 trust >> pg_hba.conf

The last step is that you will need to add your local user to postgress, pg_dump will not use the credential from datbaase.yml so you should connect to psql and run:

CREATE USER <youruser>

edited Nov 1, 2017 at 6:34

answered Nov 1, 2017 at 4:55

Calin

6,9078 gold badges51 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

Rails db:migrate with postgres running in a container

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related