Postgres and Open Source Experts

24x7x365 since 1997

Blog

Real-world example of adding SAML authentication to a JBoss application

What is SAML?

SAML stands for Security Assertion Markup Language. It's an XML-based markup language and also an open security protocol standard. The most important feature of this protocol is Web Browser Single Sign-On (SSO.) SSO allows users to login once and never be prompted for login/password later.

In this post we'll describe how to add SAML support to existing web application with the bare minimum of modifications to the …

Actually, I am going to #PgWest (and you might not want to)

OK, I am just trying to set the record straight. People are still confused thinking I might not be going to #PgWest, but I am. I know where the confusion comes from; there are a few other conferences going on during that time frame but the only two that matter are #PgWest and Surge. So, to be clear, I will be going to #PGWest this year not Surge. …

#PgWest 2011: CFP Open

Following on the smashing success of PostgreSQL Conference East, PostgreSQL Conference West, The PostgreSQL Conference for Developers, End Users and Decision Makers, is being held at the San Jose Convention Center, in San Jose, CA from September 27th - 30th. Please join us in continuing to make this the largest PostgreSQL Conference series in North America.

PGCon 2011 Developer's Meeting picture

For those that are curious (and which for some reason don't follow the #pgcon tag at twitter), here's a picture of the attendees of Developer's Meeting.

Back row, from left to right: Robert Haas, Selena Deckelmann, Marko Kreen, KaiGai Kohei, Stephen Frost, Magnus Hagander , Robert Treat, Tom Lane, Heikki Linnakangas, Mark Wong, Josh Berkus, Kevin Grittner, Dimitri Fontaine, Koichi Suzuki, Andrew Dunstan, Fujii Masao, Jeff Davis, Greg Smith, Tatsuo …

PgWest 2011: San Jose Convention Center, September 27th-30th

I am currently at the Gartner BI conference (yes really), so I won't have time to announce officially until later this week but I have had a lot of people asking me about when West will be. So, here ya go. San Jose, September 27th-30th at the convention center. The conference is already set up at Lanyrd if you want to get social.

The website is not quite updated yet …

An attempt at finding glaring btree problems

Some time ago, a customer came to us with a strange vacuuming problem. Their regular vacuum job would die with a message such as this one:

vacuumdb: vacuuming of database "clint_app" failed:
  ERROR: failed to re-find parent key in index "work_items_pkey" for deletion target page 6100

Eventually, it turned out that their storage firmware had some glitch that caused things to go wrong in random ways, and corruption in various …

This is what table bloat looks like

I got curious about a bloat problem on a customer's system today. The statistics as calculated by normal tools/queries say that one of the tables is 2x bloated. Another table is 6x bloated. And so on. For some reason I wanted to see what it looked like in a graphical way, so I threw together this simple query:

select s, coalesce(count, 0)
  from (select block, count(*)
          from (select split_part(tid, ',', …

Our company, EnterpriseDB, is the commercial company that brings to market the open source Postgres database., Ed Boyajian.

I tend to spend a lot of my time reviewing what is going on in the wider PostgreSQL ecosystem. Over the past few months I have been increasingly intriqued at a overriding theme that is starting to emerge in the market. That "EnterpriseDB" is "The PostgreSQL Company". This isn't about taglines but actual perception in the market.

I was speaking with an individual from 10Gen (#PgEast Gold Sponsor and creator …

Things you learn.... Reddit runs PostgreSQL (and Cassandra)

Not much to say here, but this is a great thread on why the "Cloud" is a serious problem real, production quality, database use.

When Too Smart Becomes Stupid: fixing a RoR PgSQL driver issue

One of our customers who is using Ruby on Rails with the PostgreSQL database backend notified us of a long-standing issue with the database driver: Lighthouse ticket #3721

The driver is doing something that at first glance looks like a smart thing, but apparently it's not that smart. What it does is it tries to detect the bit-string notation (binary vs. hexadecimal) based on the string content passed to it. …