Heroku's new, free PostgreSQL 9.1 development database

https://postgres.heroku.com/blog/past/2012/4/26/heroku_postgres_development_plan/

by chanks • 14 years ago

94 25 14 years ago

postgres.heroku.com

chanks2• 14 years ago

It looks like Heroku's dropping the larger shared database offering ($15/month for 20 GB). That's... disconcerting. That means their cheapest production database now is the Ronin for $200 a month, but I have an app going into production soon that won't need anywhere near that much power.

jonny_eh2• 14 years ago

Time to switch to a db add-on provided by a third party?

Try: https://addons.heroku.com/justonedb or https://addons.heroku.com/cleardb

heimidal• 14 years ago

What reason would you have to switch because of this? It seems like an enormous improvement.

benatkin• 14 years ago

I downvoted this, but I wish I hadn't, because the links more than make up for the trite comment. If you haven't checked out the Heroku Add-ons in a while, as was the case with me, it's worth a look!

velominati5• 14 years ago

The shared 20gb plan (based on the older, Postgres 8.3-based architecture) is still available, as is the free 5mb shared offering. We won't replace these until this new development plan is out of beta. Once we do we will continue to have a database plan at or near this price point. Stay tuned.

Matt Soldo (Product Manager, Heroku Postgres)

chanks2• 14 years ago

Thanks, Matt. Can you share what the dev plan's row limit is? The blog post doesn't say.

Stwerner3• 14 years ago

Looking forward to hearing the features the "database plan at or near this price point" will have. We would love to be able to connect to our database with other apps besides the main one - even if it ended up somewhere between the $200/month plan and the $15/month - it would be incredibly useful.

Stwerner3• 14 years ago

I wonder if this will come with some smaller production plans between dev and Ronin. We're also in the situation of getting enough performance out of the shared db offering and not needing the power of Ronin yet.

Also, I'd hope they will give a few months warning before flipping the switch completely, similar to how the hoptoad/airbrake switch went.

velominati5• 14 years ago

We will certainly have a deprecation / transition period between the existing shared db plan and the new development plan that will give users ample opportunity to migrate their data. Safely preserving data is our number one priority, so this will be handled carefully.

hgimenez• 14 years ago

> Also, I'd hope they will give a few months warning before flipping the switch completely, similar to how the hoptoad/airbrake switch went.

Funny you should say that, as I was involved in the hotpoad/airbrake transition and am now involved in the Heroku postgres one. The transition will be as smooth as we possibly can, no data will be lost, there will be plenty of time to move your data, and easy ways of doing so.

We are really excited about offering a development and free 9.1 postgres service, a huge step forward from the current 8.3 shared database service, and are looking forward to moving people over to the new instances.

bad_user• 14 years ago

If you can work with MySQL, then you'll get a much cheaper plan with a reserved instance of Amazon's RDS.

Besides being MySQL under the hood, which has known flaws compared to PostgreSQL, with Amazon RDS you get to be completely worry free. You can also do backups on Amazon's S3 and setting up a replicated slave is literally just a push of a button.

killion• 14 years ago

This is great because if you watch Heroku outages the shared database is down more than anything else. Now my staging environment will be up as often as production.

fdr• 14 years ago

To clear up a potential misconception, the availability characteristics of the new dev plan will probably be about the same as before. It is just that historically Heroku has had a hair-trigger about reporting any shared database being offline, a practice that continues now.

Besides considerably better production/dev parity in the higher-level paid plans versus the aging shared Postgres 8.3, the biggest feature I'm excited about is being able to connect directly to the shared database such as via "psql". One can also run pg_dump/pg_restore directly to their local environment, which for development purposes with small amounts of data can result in drastically faster backup/restore cycles between one's computer and Heroku than what PGBackups can provide.

Disclaimer: I work for Heroku, on data stuff.

jarcoal2• 14 years ago

I realize that the shared databases weren't really designed for production, but I used them for many projects in production, and they worked great. They included free backups, so I just took snapshots often and figured if they zapped one, I could just reload the data. The lack of backup on these new free ones kind of sucks.

I appreciate what they are doing, but this is a step back for how I utilize Heroku.

velominati5• 14 years ago

Keep in mind that the dev databases have Continuous Protection (https://postgres.heroku.com/#protect), and manual backup plans work on them as well.

jarcoal2• 14 years ago

Good to know! Thanks

chrishas35• 14 years ago

Likewise. I asked about something between dev and the $200/mo. Ronin plan on twitter and received a rather snarky reply about how I was assuming there wouldn't be other plans announced in the future.

Maybe it's just me, but if you're going to announce the depreciation of a solution at a TBD date with no indication of what the advanced warning period would be, and this is the only thing you announce along side that, I think it's fair for people to ask about the gap they see. The announcement of any planned non-dev plans should have been right alongside the announcement that removes functionality; otherwise anxiety is a given.

jguimont• 14 years ago

How do you migrate your apps?

willlll• 14 years ago

PGBackups https://devcenter.heroku.com/articles/pgbackups

Heroku's new, free PostgreSQL 9.1 development database

Related Stories