Josh, starter tier plans don't support fork/follow. You'll have to use a pgbackups dump/restore cycle to get on to a new plan. In fact, the whole reason we put a row limit on `basic` plans was to help protect people from getting to a database too big to be able to migrate without major down-time, but it seems we haven't got those limits right yet.
-p On Tue, Nov 13, 2012 at 1:27 PM, Josh Coffman <[email protected]> wrote: > 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 > -- 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
