If you're using a dedicated database (and if your queries are non-trivial you probably want to move off the shared ones) then you can just use heroku pg:ingress + psql.
-p On Wed, Dec 8, 2010 at 10:51 AM, Zach Bailey <znbai...@gmail.com> wrote: > I'm wondering if anyone has had experience importing a large amount of > data into their heroku database and how they went about doing it. I'm > staring down about 3-4M rows of (static) data that I'd like to get into our > DB on Heroku. > > > If I had my own database locally I would probably use the COPY command as > it is blazing fast. Inserting a row at a time from ruby code or going > through an exposed API is looking like it will take multiple days to do > (without spending extra money to crank up more dynos and buy a larger DB > option) > > > Another option I thought of would be to figure out a way to load the data > in a local db then dump only that table and restore it into the heroku db as > a partial backup, but I didn't see any facility for that. > > > Has anyone done anything like this or think of a good way for doing it? > > > Thanks, > Zach > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to her...@googlegroups.com. > To unsubscribe from this group, send email to > heroku+unsubscr...@googlegroups.com<heroku%2bunsubscr...@googlegroups.com> > . > 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 her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.