Writing PostgreSQL Functions with PL/pgSQL (8 tags)
One of the most powerful features of PostgreSQL is its support for user-defined functions. The language to learn is PL/pgSQL, an unpronounceable but powerful way to write UDFs. David Wheeler introduces the language and demonstrates why UDFs are useful.
Introducing Slony (5 tags)
Slony is an experimental new feature intended to introduce powerful replication to PostgreSQL. It's a complicated problem, though. Elein Mustain introduces the Slony project, its aims, and the goals of Slony-I, the first milestone.
Automating PostgreSQL Tasks (4 tags)
Databases aren't just create-once, ignore forever sinkholes for data. You'll likely spend time maintaining them, if not generating reports. Save your tender wrists and automate some of those routine tasks. Manni Wood demonstrates how to combine Perl, the shell, and the psql command-line utility to do repetitive jobs for you.
Modifying Slony Clusters (3 tags)
Slony is the intended replication project for the PostgreSQL database. As you might expect, it supports changing your cluster's configuration. A. Elein Mustain demonstrates how to add nodes, switch masters, fail gracefully, and change schemas with Slony.
Managing Many-to-Many Relationships with PL/pgSQL (3 tags)
SQL gives you plenty of options for handling relationships--you can use joins and database relations, or you can make multiple queries and write complex logic on the client. What are the benefits and drawbacks of each? David Wheeler recently experimented with moving complex relationship logic into PostgreSQL's PL/pgSQL language; the results were stunning.