Blog

FOSSExperts, a new way to fund Open Source (Beta)

The cat is out of the proverbial bag. I originally planned to have a quiet roll out with a few close contributors but that has gone by the wayside. Now I am going to be pushing hard for people to test, beat on, object to, argue about, flame upon, scream at, praise and hopefully help us build out something that is truly useful for the FOSS Community. What am I …

A better backup with PostgreSQL using pg_dump

This is generously borrowed from the PostgreSQL Docs, and updated to something that represents a modern approach to PostgreSQL backups. This documentation has always bothered me because it should have been re-written years ago. Yes I plan on submitting a more comprehensive version as a patch but I don't have time to push it into DocBook right now. If someone else wants to grab it, please do. Yes, I really …

Multiple Drupal installations, single login, 10 steps

We have several Drupal sites, no I am not typing this blog on one. We needed a way to have single sign on with these Drupal sites. One of which is PostgreSQL Conference. There are a few modules out there that can do it, some don't work with PostgreSQL, some are usable but not user friendly (HTTP AUTH) and still others use external services such as OAuth. I didn't …

Let the jokes begin! PostgreSQL Conference West has changed locations.

About a week ago I announced PostgreSQL Conference West 2010 CFP. In that CFP I also announced the location. A nice place, the Westin at Union Square in San Francisco. We were excited, the hotel was top knotch.

Then on Monday I received notice, the hotel acquisitions team (EDB) has received an amazing counter offer from a competing hotel.

The hotel is still in San Francisco, it is …

PgWest 2010: Call for Papers

PostgreSQL Conference West, The PostgreSQL Conference for Decision Makers, End Users and Developers, is being held at the St. Francis, Westin Hotel in San Francisco from November 2nd through 4th 2010. Submit your talk.

Time line:

July 14th: Talk submission opens Sept 5th: Talk submission closes Sept 10th: Speaker notification

This year we will be continuing our trend of covering the entire PostgreSQL ecosystem. We would like to see talks …

PostgreSQL High Availability options

PostgreSQL is widely accepted as the most scalable and stable Open Source database in the industry. It is also known to hold its own against any of the proprietary databases as well. There are a plethora of High Availability options available for every workload and business requirement. Below is a brief listing of the common High Availability options for PostgreSQL. This is by no means an exhaustive list but it …

Scala... really?

I am not writing this to jump all over Big Jim's post but after reading it and seeing the syntax of Scala (and Java), I can't help but wonder, why anyone would use either language (based on syntax). Yes I know it is a matter of taste and everyone has an opinion. Let's just say my taste lean toward more succinct code.

#!/usr/bin/python
#
# Set up initial work
# …

PostgreSQL 7.4, 8.0 and 8.1 END OF LIFE

If you are running any version of PostgreSQL 7.4, 8.0 or 8.1, it is now time to upgrade to 8.3 or 8.4. The versions 7.4 and 8.0 are slated for end of life at the end of this month. The 8.1 version is slated for end of life in November. This is not an item to take lightly. Once a version is end of life you will not be able …

WHERE bing = 't'

I was on #postgresql today and someone asked an interesting question: (edited for readability)

I'm trying to write a constraint for a table. The constraint should check for unique-ness of two columns, one string and one boolean. However I have special logic, I can have only one row with a given string and true attribute. I can have multiple rows with the same string but with false attribute. For example, …

Entering 9 days of PostgreSQL Dimension

On the 6th, I leave town, travelling again to an unknown land. A land of mystery, a land of great mobster movies and incredible picture opportunities. Of course, I speak of Chicago where I will be delivering a 5 day training on our illustrious database, PostgreSQL. After the 5 day training, I will be taking a short jaunt to South East Linux Fest where I will be speaking on PostgreSQL …

Postgres and Open Source Experts

FOSSExperts, a new way to fund Open Source (Beta)

A better backup with PostgreSQL using pg_dump

Multiple Drupal installations, single login, 10 steps

Let the jokes begin! PostgreSQL Conference West has changed locations.

PgWest 2010: Call for Papers

Time line:

PostgreSQL High Availability options

Scala... really?

PostgreSQL 7.4, 8.0 and 8.1 END OF LIFE

WHERE bing = 't'

Entering 9 days of PostgreSQL Dimension

Recent posts

Of Unicorns and Donkeys

pg_dump Gets a Speed Boost in PostgreSQL 18

Driving Excellence

The Essential

PgManage 1.0 Released

An act of kindness for the PostgreSQL community

An update on the hunt for 195