Error trying to load structure with rake db: structure: load, "schema_migration" does not exist

Question

I run rake db:structure:load, but after loading the whole structure, it cannot embed versions in schema_migrations.

PostgreSQL seems to be unaware of newly created tables. Already googled around, but did not find anything useful.

+5

Pablo Jul 12 '12 at 15:32

1 answer

Koop otten · Answer 1 · 2014-04-02T08:56:28+0000

Have you changed or deleted any migrations?

Anyway. You can look into the postgres console and try:

to get a list of all the databases (to find yours)

\list

thereafter

\c yourdatabasename_yourenvironment

and

\dt

to see all the tables in the postgres database.