Blog

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 …

Simpycity now available on Github

Following up on our brand-new Simpycity 0.3.1 release from earlier today, you're now able to get hold of Simpycity via the ever-popular code-sharing platform GitHub. Check us out @ GitHub, and track all the Command Prompt projects!

Announcement: Simpycity 0.3.1 Released

Following up on the blog post covering the new coolness in 0.3, and better docs on working with Simpycity, we've just released Simpycity 0.3.1, our best release yet! Simpycity can be downloaded from our Wiki, and our code is available from the Subversion repository. Finally, starting today, all new releases of Simpycity are available on the PyPI package index, and Simpycity installable via:

$ easy_install Simpycity

Active Object in Simpycity

Simpycity is, as we've previously covered, a small library that permits for the direct mapping of arbitrary SQL statements to Python callables. This power allows for the development of complex representations that do not need to directly map to the underlying database representation. This differs from most conventional ORM technology, which follows the ActiveRecord pattern. Simpycity was implemented in this way for a great many reasons, first and foremost that …

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 …

Cool Features I'm Looking Forward to in PostgreSQL 9.0

Recently, I was able to attend the local PostgreSQL community meeting here in Portland, and the topic du jour was covering the nifty and interesting features that are found in PG 9.0. Confessing that I haven't really been paying close attention to what's new in 9.0, the talk was incredibly interesting - covering a range of new features in 9.0.The ones I'm really excited about are: /contrib/passwordcheck This newly-added contrib …

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
# …

Postgres and Open Source Experts

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.

Simpycity now available on Github

Announcement: Simpycity 0.3.1 Released

Active Object in Simpycity

PgWest 2010: Call for Papers

Time line:

Cool Features I'm Looking Forward to in PostgreSQL 9.0

PostgreSQL High Availability options

Scala... really?

Recent posts

PgManage 1.3 Release: Powerful New Features and Enhanced Usability

Part 3: Why Autovacuum Stops — PostgreSQL Internal Mechanics Explained

Lessons from the Road: The weight of consumerism

Part 2: Reproducing and Diagnosing Autovacuum Failures

Lessons from the Road: Know your values

Part 1: When Autovacuum Silently Fails Across Databases

Lessons from the Road: What is Essential