Blog

Thoughts on the PostgreSQL EU non profit.

I was talking with a peer about the particular PGEU problem that I am currently arguing on the following thread. I wanted to see if I could explain my position outside of the thread to allow the thread to stay productive.

I am aware that there are variable levels of cultural idioms in all countries. Americans have theirs, Canadians, Germans... all of them. Whenever I make a comment about the …

Call for Papers: PostgreSQL Conference East

The call for papers went out tonight for PostgreSQL Conference East which is being held in College Park Maryland on March 29th and 30th. At West, we only had one day and a series of 9 talks. This time around, we have two days and three rooms... During EAST we plan on having a series of talks, tutorials and a new format (for us at least) mini-tutorials. The idea behind …

Phew... Handling PostgreSQL Conference East 08

When Selena and I started with the Fall Conference last October we had no idea what a success it was going to be. O.k., Selena swears she knew but I was surprised. After Fall there was zero question that we were going to do an East. The community demand was just too high and we have a volume of not only contributors but also general community on the East coast. …

PostgreSQL Conference East 08 (updated)

It's that time, after a wildly successful conference last October in Portland, Oregon we are now beginning to ramp up for the East Coast 08 conference! The current plan is to host a two day conference of Tutorials (new) and Talks on March 28th and 29th. The currently designated location for the conference is the Univserity of Maryland. This will be confirmed within two weeks. For now, we are making …

PostgreSQL logging, time for a change

I have often thought that PostgreSQL logging although very flexible is also unwieldy. PostgreSQL has so many logging options, it is difficult if not impossible to find the "right" logging setting without a lot of trial and error. Let's just break it down. Below is all of the logging options available to DBAs when 8.3 hits store shelves.

#log_destination = 'stderr'		
# This is used when logging to stderr:
#logging_collector …

PostgreSQL Conference Fall 2007: My wrap up

We had a great time at the conference and subsequent party. If you are ever in PDX and want some great food and interesting accommodations I strongly suggest the Paramount Hotel and Dragon Fish cafe. They treated all of us very well and had great food! The conference did well above expectations, signing on 10 sponsors, some at the last minute (LinuxFund). Our original goal was only 4. And as …

PostgreSQL Conference: Good Lord... twice as many as we expected

When Selena Deckelmann and I decided to start a PostgreSQL Conference series, we believed that a small, regional, technically specific conference was appropriate. We considered that at most, we would get around 35 people and it would essentially be a large user group meeting that had a series of talks and was good for the community. That was the end of July. It is now the night before the conference, …

plphp 1.3.5 Beta 1 Released

Not much to say here but plphp 1.3.5 Beta1 supports named parameters and PostgreSQL 8.3 Beta1. Enjoy :) PL/php website

PostgreSQL Gotcha: Default timestamps are not exact!

If you are compiling PostgreSQL from source you have a configure option called:

--enable-integer-datetimes

Now Debian/Ubuntu wisely turn this option on by default, unfortunately the RPM provided by PostgreSQL.Org and the RPM provided by RedHat/Fedora do not. Why is this a problem? I think we can all agree that given that a particular value is within a column that value should be able to be retrieved from that column. Consider …

Recursive PLPGSQL, Lookup Table and Ltree

There are many reasons and needs to implement a tree structure inside of an SQL database. In our particular example today, we're using a basic knowledge base tree as an example of a small- to large-scale tree inside of an SQL database. Additionally, any sort of directory/file system layout would be a good match for these concepts. I am going to discuss three basic concepts on dealing with small, medium, …

Postgres and Open Source Experts

Thoughts on the PostgreSQL EU non profit.

Call for Papers: PostgreSQL Conference East

Phew... Handling PostgreSQL Conference East 08

PostgreSQL Conference East 08 (updated)

PostgreSQL logging, time for a change

PostgreSQL Conference Fall 2007: My wrap up

PostgreSQL Conference: Good Lord... twice as many as we expected

plphp 1.3.5 Beta 1 Released

PostgreSQL Gotcha: Default timestamps are not exact!

Recursive PLPGSQL, Lookup Table and Ltree

Recent posts

Support California Wildfire Relief Efforts

Part 2: The Essential Role of Rollback Plans

The Critical Importance of Robust Change Control Policies and Rollback Plans in Technology Projects

The PostgreSQL Roadmap: Understanding Milestones in Versioning, Features, and Upgrades

Out of Cycle PostgreSQL Release: November 21, 2024

PgManage 1.2 Released

PgManage 1.1.1 released