Postgres and Open Source Experts

24x7x365 since 1997

Blog

Break out your credit card, support #PGXN

PGXN is the stuff. It is going to enable a whole new ecosystem of software for PostgreSQL complete with easy install, easy search, modular design and yeah unfortunately Perl.

That said, it is time to pony up. David Wheeler has put in some serious effort, well thought out, professionally designed and peer reviewed effort on delivering a new architecture for PostgreSQL software and modules. He needs our financial support.

Go …

Interviewed by Linux.com

So, I broke down at purchased my Linux Foundation membership. Shortly thereafter I was requested to be interviewed. Here it is.

PgWest 2010 Early Bird Registration Open!

We are still finalizing the three days of content but the first tutorials of the conference have been accepted and early bird registration is now open.

Tutorials:

  • Test Driven
  • Database Development
  • Building an Open Geospatial Analysis Technology Stack
  • Normalization Workshop
  • GUCs: a Three-Hour Tour
  • Django and PostgreSQL
Mini-tutorials:
  • PostgreSQL Backup and Recovery Methods
  • MVCC Unmasked
  • The PostgreSQL Query Planner
  • Writing C Functions and C User Defined Types on Windows Using …

Is your PgWest 2010 presentation submitted?

One of the aspects of the Open Source community I love is the agile, on demand nature of getting things done. If a feature is missing, you can just add it and you can add it on demand, as you need it. If a bug is present, you can fix it yourself or pay someone else like CMD to fix it for you.

Unlike other communities that are closed where …

PgWest 2010, CFP about to close!

Yes, we said it was the 5th that the CFP would be closing but then we belatedly realized that a good portion of the United States would be having a BBQ and drinking whatever their favorite beverage is over the weekend. Thus in true PostgreSQL fashion, PgWest is missing its CFP release date but only for a week! That means, submit your paper, now.

PgWest: 2010 Call for Papers (2nd call)

Yes, it is the second call. That means some of you haven't submitted after the first call. Of course, I haven't submitted mine either; so it is time for everyone to get on it. West is just around the corner and from all observations this West stands to be the largest PostgreSQL Conference, ever. (O.k. we might not over take Brazil).

Here is the announcement for everyone to review, enjoy …

FOSSExperts, day 2

I expected feedback from the community on FOSSExperts. I did not expect feedback with such immediacy. All the feedback I have received so far is positive. Which is a great feeling. Here are the key points that are coming back.

How do deal with disagreement about the deliverable:

This is an interesting one. I wanted to keep FOSSExperts simple. That is why the deliverable on the ALTER TABLE project …

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 …