Jesse, Thanks for posting a link to that gist, I must have missed that before. Ok, that would solve half the problem (getting from production to secondary server) In my case the code would be a fraction of the database size so having that in the bundle isn't a big deal (and actually is a good idea since it would be the copy that works with that exact database schema). From what I've read in previous posts it sounds like people are having a hard time restoring a bundle though.
I should point out that I'm really not ragging on Heroku. I really love what they are doing, and if it wasn't for a couple of issues I have with the database there would be no question that I'd use it. I'm just pointing out these issues in the hope that the guys at Heroku can figure out a way to make dealing with the database easier and eliminate any reason I'd have for not using Heroku. Thanks again, -Chris On Wed, Mar 24, 2010 at 1:14 AM, Jesse <[email protected]> wrote: > I believe you are right db:push and db:pull don't touch FKs; I also > agree that FK are a good thing. > > If you create a migration file that generates your FKs it will create > them when you run rake db:migrate on your heroku application > > as far as backups go the other option is the single bundle add on > I found this gist (i think maybe someone posted it here before?) it > downloads the bundle and then uploads it to s3 for back up > https://gist.github.com/1d2853b0a349768a8884 (some nice stuff, learned > a few things from this code) > > the only problem with the bundles is all of your code comes with it > and most of us probably have that in our own source control system > already; I branched that gist above to extract the pgdump.sql file, it > needs some additional cleanup; right now the s3 upload is commented > out and needs a task to move the pgdump.sql > https://gist.github.com/ccfce988fdbc172febc3 > > The pgdump.sql file from the bundle will contain the FK Alter > statements (if the FKs exists on the heroku db) > > Usually when I use the db:pull; first I'll run rake db:drop and rake > db:create -> which will DROP my local development database then run > heroku db:pull and then run a script to apply all FKs; getting the > pgdump file from the bundle is probably going to be better in most > cases. > > > -- > 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. > > -- 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.
