I have been recieving errors such as: PGError: ERROR: duplicate key violates unique constraint "topics_pkey" after a db:data:load. Everything works fine and works until i make a new entry in the database, eg. create a new user or post in the forum. My schema before the load and after is identical and I have check as much as possible to find faults in the yaml file but it seems to be fine.
On May 7, 5:59 pm, justindz <[EMAIL PROTECTED]> wrote: > How tolerant of schema changes is the dump and load process? If a > column is gone from the DB on load or a column has been added (that's > probably simple), will this process succeed? > > If so, I can see this tool being useful even in the fully hosted mode > for some kinds of schema modifications. Appreciate your thoughts. > I've had problems in the past getting schema changes to be applied > without having to dump and rebuild my database so I'm looking for ways > to modify the schema without wiping out all my beta activity. > > Thanks, and I'll be bookmarking the OS page in general :-) > > On May 6, 9:14 pm, "Adam Wiggins" <[EMAIL PROTECTED]> wrote: > > > We've got a new version of yaml_db online which has some substantial > > optimizations contributed by Ricardo Chimal. This should make yaml_db > > much more usable on production databases with tens of thousands of > > records. For dump/load on Heroku, you don't need to do anything - the > > latest version is already installed. If you're using yaml_db locally, > > you'll want to get the latest version: > > > script/plugin installhttp://opensource.heroku.com/svn/rails_plugins/yaml_db > > > Note that this introduces a slight formatting change, splitting each > > table into separate YAML documents (basically just an extra --- and a > > newline above each), which turned out to be key in getting better > > throughput. The old formats will load into the new yaml_db, but if > > you export from a new yaml_db and try to load it into an old version > > of the plugin, it won't work. So just make sure your local plugins > > have the latest version if you're taking data out of Heroku and into a > > local app. > > > Adam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
