PDXPUG: November meeting in two weeks

When: 6-8pm Thu Nov 20, 2014
Where: Iovation
What: 9.4 party!

As discussed at last month’s meeting, we’re going to check out some of the new 9.4 features. It will help if you already have 9.4 installed on your laptop, but if you’re new & don’t know how to do that, just show up & we’ll help you out.

If you’re a Vagrant user, try this: https://github.com/softwaredoug/vagrant-postgres-9.4

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 5:45 and building security closes access to the floor at 6:30.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!

PDXPUG: August meeting

When: 7-9pm Thu Aug 15, 2013
Where: Iovation
Who: Mark Wong
What: YAMS Aren’t Sweet Potatoes

We’ll be moving back to our usual location at Iovation for our August meeting. Mark’s going to tell us about a monitoring tool he’s been working on:

“YAMS (Yet Another Monitoring System) is a project that probably should be named by someone more creative. See why I developed a collection system to handle more than 1,000,000 metrics per sample at Emma, and some of the fun queries that are written to retrieve the data.”

Mark gets to work on the database systems at Emma, Inc., where Postgres is the primary relational database system used to manage over a terabyte of data.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Building security will close access to the floor at 7:30.

PDXPUG: June meeting: Lightning Talks (really)

When: 7-9pm Thu June 20, 2013
Where: Iovation
Who: Group
What: Lightning Talks

Last month we had a surprise special guest – Emily Strickland spoke to us about the way Rentrak uses Postgres. It turned into a big group discussion, my favorite kind of meeting.

We’ll be doing Lightning Talks for our June meeting. This time we mean it :) The link to sign up is on the mailing list. See the May meeting announcement for more information.

Packt has promised us some books to give away as well: a couple copies each of PostgreSQL 9.0 High Performance and the PostgreSQL 9 Admin Cookbook, as well as some of their newer eBooks: Instant PostgreSQL Backup and Restore and Instant PostgreSQL Starter. You must be present to win, of course.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Building security will close access to the floor at 7:30.

After-meeting beer location: Huber’s. See you there!

PDXPUG: May meeting: Lightning Talks

When: 7-9pm Thu May 16, 2013
Where: Iovation
Who: Group
What: Lightning Talks

Recent presentations have sparked several conversations of the “no sh–, there I was” variety, so for May we’ll be doing Lightning Talks. Bring your stories of wizardry, abject failure, and “Hail Mary” passes. We do request that your topic have something to do with Postgres, but that’s the only requirement – you don’t even need to have slides if you don’t want to. If you’ve never given a talk before, a lightning talk is a great low-risk way to try it out!

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Building security will close access to the floor at 7:30.

After-meeting beer location: Huber’s. See you there!

PDXPUG: April meeting in two weeks – eXtreme Database Makeover

When: 7-9pm Thu April 18, 2013
Where: Iovation
Who: PSU students
What: eXtreme Database Makeover: Portal, part 2

Usually when we do Extreme Database Makeover, we’re referring to the schema. This time, we’re going to do some GUC tuning. The Portal database is running pretty close to a default configuration, and we can help the student admins improve that.

This will be a group effort; bring your favorite performance tuning references.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Building security will close access to the floor at 7:30.

After-meeting beer location: Huber’s. See you there!

PDXPUG: February meeting this week

When: 7-9pm Thu Feb 21, 2013
Where: Iovation
Who: Selena Deckelmann
What: Dawn of a New Backup Era

Backing up PostgreSQL, like most any database, has never been a simple situation.

Come learn about the latest in backup tools for PostgreSQL. Core tools like pg_basebackup have replaced most of what experienced DBAs used to write shell scripts for. We’ve also got a quiver of third-party tools that compliment and improve upon the core.

Finally, every backup plan needs a solid testing and restore routine. Selena will share a couple useful tricks for getting this into a regular cycle of updates that your developers and operations team both can use and appreciate.


Selena Deckelmann is a major contributor to PostgreSQL, runs conferences, and keeps chickens. She’s also one of the founders of PDXPUG.