Postgres and Open Source Experts

Once upon a time, JD was a assistant manager for Block Buster video. This was a very long time ago and before a 23 month employment stint at Powells Books. It was at Powells that the world of computers was actually introduced to me as a viable employment option. While there I designed a special order database in DBase IV, was introduced to University Ingres, went through Book Buyer …

As a reminder, the CFP for PgNext is still open. We are in Denver this year, let's make it rock! This year we are keeping it simple and getting back to roots. The conference is about community, networking with professionals, learning and in general having a good time. Who can't have a good time in Denver?

Our team has been hard at work on several things. One is the URI patch for libpq which was just committed and sponsored by Heroku (Thanks Heroku). This is a novel patch that brings standard URI connection handling to libpq and any client/driver that decides to implement the functionality. You can see the patch here.

We are still actively working on PgNext: The Next PostgreSQL Conference. The folks on …

We have been working on a large Oracle 8i conversion to PostgreSQL. Our customers were not concerned with the data conversion: there are tools like ora2pg and oracle foreign data wrapper to accomplish this. They do, however, have a significant number of queries that needs to be converted.

Apparently, most queries from Oracle and PostgreSQL look similar; after all, both are relational database systems, as opposed to Cassandra or MongoDB, …

This is something I have seen many times now: a customer calls us because they lost some data and they want help recovering.

Now you must be wondering: surely if they lost data they can just recover from their last backup, right? Right — they had that. However we know that pg_dump takes a while to run and is stressful on the server, so it's normally run just once a …

Come on, admit it: you've always wanted to display the infomask bits from a tuple header in a human-readable manner, but you've never gotten around to it and you still keep htup.h in display while you peek around tuples.

Fortunately, that time is now past! Here's a short and simple recipe to decode the bits for your reading pleasure. Gone is the htup.h cheat sheet. Here's what you need:

create …

West is wrapped up. It was smaller. We split the attendees between Postgres Open and Surge. It was a good conference. We received a lot of positive feedback and I was even able to be nice (stop laughing, just ask others :P) to people for the conference.

We were able to fund two features for PostgreSQL, both of which will hopefully hit for 9.2. The first is work to …

PgWest is only a week a way folks, let's get those registrations in!

This year we have a diverse range of topics on PostgreSQL. Of course we have all the standard topics on backups, performance, mvcc but we also have some very interesting presentations coming from VMWare, Fusion-IO and Translattice.

• You can find the schedule here.
• Registration is open and is available here.

As we all know, PgWest is in San Jose this year in just under 3 weeks. The trainings are filling up fast and you will want to get your registrations in. We have great trainings on:

• Performance
• High Availability
• Administration
• Ruby on Rails (with PostgreSQL focus)
• Normalization
• DRBD

  These are filling up fast, so you will want to get your registration in.