+1 An additional option that I would like to see that would make import/export of databases easier is to be able to do a database dump (ex: pg_dump -o app_db_name > "some s3 bucket/key") where the database gets dumped from the Heroku Postgresql server to an S3 bucket (and the reverse for pulling a database into Heroku).
This would allow us to use S3Fox or similar app to upload a big database to S3 and then have Heroku pull it in bypassing Taps. Of course this would necessitate the end user using Postgresql for their development environment, but my personal opinion is that anyone who is dealing with huge datasets should be doing that already anyway if they are planning on using Heroku. This would also allow for importing of single tables which is currently a problem on Heroku. If doing a 'heroku db:copy app1 app2' is not feasible directly on Heroku servers without first pulling the database down locally (for various technical reasons) I personally would still prefer to dump to S3 rather than pull local since that should still be significantly faster. My $0.02. -Chris On Tue, Mar 16, 2010 at 8:03 AM, Daniele <[email protected]> wrote: > +1 > > Really nice feature! > > On 15 Mar, 18:57, Mike Doel <[email protected]> wrote: >> I imagine we're not alone in having both a staging and production >> environment up on heroku. We frequently use heroku db:pull to grab the >> production database and will occasionally put it up to our staging >> environment with heroku db:push. >> >> Is it possible to do this in one step? Something like: >> >> heroku db:copy app1 app2 >> >> Ideally, this would happen without having to download locally and uploading >> as separate steps (i.e. direct server-to-server transfer). > > -- > 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.
