I got some help from Peter at Heroku, and things are better. It's now under the row limit but still takes up a huge amount of space. I think that's used by deleted rows which haven't been cleaned up yet. I ran a VACUUM on the table without the FULL option, however. I don't want to take this offline again, if avoidable. I'm thinking now of starting a follower on the higher plan then switching the app to that db after it catches up to the other. Is that a safe and reliable way to switch?
Thanks, Josh On Tue, Nov 13, 2012 at 7:23 AM, Josh Coffman <[email protected]> wrote: > Yes I tried that > On Nov 13, 2012 3:18 AM, "Matheus Mendonça" <[email protected]> > wrote: > >> Josh, >> >> Have you tried to restore a snapshot from your db to a new one? It would >> be my first try. >> >> Matheus Mendonça >> www.nazar.la >> >> >> Sent from my iPhone >> >> On 13/11/2012, at 02:44, Josh Coffman <[email protected]> wrote: >> >> Hi, >> >> One of my apps is currently write-locked and I'm unable to migrate to a >> larger plan. I filed a ticket earlier today, and I stayed patient because I >> thought it was moving along. It's not resolved and clearly not going to be >> resolved at least until tomorrow morning. Meanwhile, this app is still down >> and we are meeting with the client in the morning. I love heroku, but this >> is a problem for me. >> >> Are there no other support options? Is there some inside trick to get a >> migration to a larger postgres plan to work when command line currently >> fails? >> >> Also, are there any tools or rake script for early notification when a >> database is approaching limits? >> >> Thanks, >> Josh >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Heroku" group. >> >> 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_US?hl=en >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Heroku" group. >> >> 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_US?hl=en >> > -- You received this message because you are subscribed to the Google Groups "Heroku" group. 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_US?hl=en
