Blog

PostgreSQL mininum requirements

In this article we will be discussing the minimum requirements for production usage of PostgreSQL whether on-prem or in the cloud. We will not be discussing proprietary forks such as Amazon RDS or other Open Source forks such as Yugabyte or Greenplum.

PostgreSQL is the Linux of databases. It provides the kernel and key features to the most critical database services available today.

What is that sound ... ... ... that is the sound of JD stomping.

After years of listening to Dave Page, Magnus Hagander, Josh Berkus, David Fetter, Stefan Kaltenbrunner, Ads, Gabrielle, JPA and numerous other contributors that I should mention but won't. I have finally submitted to get a passport. Well at least the application is filed. So let's tell a story about acquiring a passport in the United States. Generally speaking it doesn't seem to bad. I needed my birth certificate and my …

Configuring Pylons on Ubuntu Hardy

I recently configured a complete Pylons + PostgreSQL environment for a customer. The operating system was (of course) Ubuntu Hardy. The system included the use of Simpycity and WSGI. Although I could never done it without the Pylons documentation, I found that it was unnecessary complicated for those who just want to get it done. These are the steps I took:

Install some dependencies: The use of …

2nd call for papers: PostgreSQL Conference East!

PostgreSQL Conference East is being held at historic Drexel University on April 3rd through 5th 2009 . This is the second call for papers. The call for papers ends Feb 23rd and speakers will be notified on the 27th. You may submit your talk here. We are looking for a wide range of topics. Can you speak on any of the below topics? What about a different topic? As long …

PostgreSQL and Replicator at Northwest Python Day

Last Saturday I gave a talk at the Northwest Python Day in Seattle. Unfortunately it was a short talk of only 30 minutes so I didn't get to cover all the topics I wanted but I was able to briefly share on PostgreSQL and on configuring PostgreSQL (Mammoth) Replicator. Just for grins I started the talk off with a question, "Please raise your hand if you are running Ubuntu." There …

Reflecting on the great community discussion

As I diligently prepare for PostgreSQL Conference East 09 by trying to ensure that we have enough talks (hint: talk submission closes Feb 27th). We have a suggested hotel and that everyone knows it is going on (including the Groovy, Python, MySQL, PHP and Ruby communities), I take heart in knowing that our community PostgreSQL can have a well thought out, pointed and productive discussion like no other. I …

East 09: Call for papers!

PostgreSQL Conference, U.S., East 09 will be held in Philadelphia at historic Drexel University from April 3rd through 5th. The call for papers is now out.

As always we let our submissions define our actual tracks. If you have something you want to talk about it. Submit it. As long as it is about PostgreSQL (or doing something with PostgreSQL) we will consider it.

We are seeking creative ideas about …

FK, CHECK, ENUM or DOMAIN. That is the question.

We have a customer that recently asked me to comment on which I would use for a particular problem. This is a simple validating lookup. For example, CHECK(VALUE IN ('foo','bar')). Should we use a CHECK constraint, FK, ENUM or DOMAIN?

A CHECK constraint is easy to apply and has simple syntax. It is also extremely flexible in solving other types of validating problems. If your valid values change you must …

Replicator meeting log for 01-08-09 is up

The PostgreSQL + Replicator meeting logs for 01-08-09 are up. This was a long meeting held on #replicator using the Freenode IRC service. Topics covered were the removal of the Single Point of Failure of the MCP which is partially done. The new in the PostgreSQL backend forwarder works but now the question is how to safely handle failover. Take a look, maybe you have an idea.

PostgreSQL Conference / PgCon.US update

In an attempt to ensure the continued positive growth of the community, PostgreSQL Conference, U.S. is going to change its current policy toward the domain PgCon.US. The current policy is that the domain would only be used in lieu of http://www.postgresqlconference.org/ when space was significantly to display the long URL was significantly limited. The new policy will be that PgCon.US will not be used. I would encourage any and all …

Postgres and Open Source Experts

PostgreSQL mininum requirements

What is that sound ... ... ... that is the sound of JD stomping.

Configuring Pylons on Ubuntu Hardy

2nd call for papers: PostgreSQL Conference East!

PostgreSQL and Replicator at Northwest Python Day

Reflecting on the great community discussion

East 09: Call for papers!

FK, CHECK, ENUM or DOMAIN. That is the question.

Replicator meeting log for 01-08-09 is up

PostgreSQL Conference / PgCon.US update

Recent posts

The Essential

PgManage 1.0 Released

An act of kindness for the PostgreSQL community

An update on the hunt for 195

PgManage 1.0b2 released

PgManage 1.0b released

Your work-life balance is killing you