---
title: "This Week's PostgreSQL News (#28)"
publication: "Postgres Weekly"
issue: 28
published_at: "2013-09-18"
canonical_url: "https://postgresweekly.com/issues/28"
---

Postgres Weekly Issue 28 - September 18, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/28)**Postgres Weekly****Issue 28**
September 18, 2013Featured[PostgreSQL Data Recovery](http://tapoueh.org/blog/2013/09/16-PostgreSQL-data-recovery.html?utm_source=postgresweekly&utm_medium=email)Losing data is the single worst thing that can happen to your database, but sometimes things happen. Here’s an interesting deep dive on when things broke, backups that didn’t work, and how data was recovered.[All Your Base: A Database Conference for Web Developers (Oxford, UK)](http://allyourbaseconf.com/#speakers?utm_source=postgresweekly&utm_medium=email)In many ways, this newsletter was kicked off at last year's All Your Base conference when I, [@craigkerstiens](http://www.twitter.com/craigkerstiens), and [@peterc](http://www.twitter.com/peterc) connected and began talking about creating a Postgres weekly. Of course, its also a great conference and you can get a discount of £70 if you register with code `zer0wing`From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)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._[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)The rest[Postgres 9.3 feature highlight: Event Triggers](http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-event-triggers/?utm_source=postgresweekly&utm_medium=email)Postgres 9.3 is packed with great features, here’s a highlight of one of the lesser talked about ones: event triggers.[Taking advantage of bgworkers](http://michael.otacoo.com/wp-content/uploads/2011/09/20130916_pgopen_bgworker.pdf?utm_source=postgresweekly&utm_medium=email)PostgresOpen is currently going on in Chicago with a great mix of the Postgres community of contributors along with end users. The slides from this talk on background workers offers a great deep dive into a 9.3 feature, and other slides/talks will cover others which will make sure to include a they’re available.[Diving into Postgres JSON operators and functions](http://www.craigkerstiens.com/2013/09/11/diving-into-postgres-json-operators/?utm_source=postgresweekly&utm_medium=email)The new JSON operators and functions make the JSON datatype even more useful, here’s a specific example how you can get started working with some of the operators and functions._Craig Kerstiens_[hppt: High Performance PostgreSQL Tools](https://github.com/gregs1104/hppt?utm_source=postgresweekly&utm_medium=email)Author of the defacto Postgres performance book, PostgreSQL High Performance, Greg Smith has consolidated many of his most handy and helpful scripts into a single github repo for others to take advantage of._GitHub_[Why PostgreSQL is so Awesome](http://java.dzone.com/articles/why-postgresql-so-awesome?utm_source=postgresweekly&utm_medium=email)_Javalobby_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)