| Postgres Weekly |
Issue 10
May 15, 2013
|
|
|
Featured
| PostgreSQL 9.3 Beta 1 Released |
|
Postgres 9.3, like many other releases before it, is shaping up to be a great release and the beta is now here. Get started with the beta to take advantage of materialized views, writable foreign data wrappers, improved JSON support via new operators, and of course much more.
|
|
From our sponsor
| Heroku Postgres - Fully managed Postgres on EC2 |
There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.
Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
|
|
 |
The rest
| Quickly Migrate A DB From MySQL To Postgres |
|
For the few of you still on MySQL and hoping to get off here's a simple but straightforward guide on how you can get migrated. It also has a good callout to some more complicated options for those that need zero downtime migrations.
|
|
| Deploying PostgreSQL on Amazon EC2: A Case Study |
|
If you're running your own amazon instance especially on EC2 theres many gotchas that can occur. Here's a case study from OmniTI so you can take advantage of their lessons learned from running on top of Amazon.
|
|
| Database Insight with pg-extras |
|
If you're running on Heroku pg-extras is a CLI plugin that provides extra commands for the CLI to give you more insight. Even if not on Heroku you can take a look at the github repo for a great set of queries that can be beneficial to you.
|
|
|
|
|