I was happily running SQLite3 as my production database when I ran into
concurrency issues. Therefore I embarked on the attempt to migrate to
Postgres.
The first step I ran was to update database.yaml and add a section for the
postgres DB (called it development).
I then
/usr/bin/ruby193-rake db:migrate RAILS_ENV=production/usr/bin/ruby193-rake db:migrate RAILS_ENV=development
To ensure both databases were up to the latest version. The final step was
to do the actual migration.
/usr/bin/ruby193-rake db:convert:prod2dev
Upon running this I received errors regarding missing tables in the
postgres scheme (resources, source_files, resource_tags, puppet_tags) that
were present in the sqlite3 DB. To get around this I created an empty table
in Postgres. That got me past that. However now I have the following error:
PGError: ERROR: insert or update on table "fact_values" violates foreign
key constraint "fact_values_host_id_fk"
DETAIL: Key (host_id)=(56) is not present in table "hosts".
: INSERT INTO "fact_values" ("created_at", "fact_name_id", "host_id", "id",
"updated_at", "value") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id"
Which looks like it is trying to import facts prior to the actual host data
being imported (thus the FK constraint error).
Any idea what I am doing wrong or if I am missing a step in the procedure?
Thanks