PDXPUG: August meeting in two days

When: 6-8pm Thursday August 18, 2106
Where: iovation
Who: Brian Panulla, Marty Zajac, Gabrielle Roth
What: ETL Throwdown (or up)

For August, we’re having a panel discussion on various ETL tools we’ve tried.
Brian: moving from bulk ETL to near real time ETL with Tungsten Replicator to replicate from MySQL to PostgreSQL and Solr
Marty: Pentaho
Gabrielle: CloverETL, home-grown solution using postgres_fdw, and a brief rant about Informatica if we have time.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: 10th anniversary meeting tonight!

We’re having our 10th Anniversary meeting tonight!

As in previous years, I generated speaker & topic tag clouds:

When: 6-8:30pm Thursday July 21, 2016
Where: iovation
What: 10th Anniversary Social
This meeting is 100% social and will take the place of our regular July meeting.  iovation will provide a light dinner and beverages.  We will provide the conversation and reminiscing.  There will not be any long speeches, but there will be cupcakes.
iovation is 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.
See you there!

PDXPUG: July meeting – It’s Our 10th Anniversary!

When: 6-8:30pm Thursday July 21, 2016
Where: iovation
What: 10th Anniversary Social

I can’t believe it’s been 10 years since OSCON 2006, when Selena and I spoke to Josh B about starting a user group.

And here we are.

This meeting is 100% social and will take the place of our regular July meeting. iovation will provide a light dinner and beverages. We will provide the conversation and reminiscing. There will not be any long speeches; there might be cupcakes.

iovation is 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.

See you there!

PDXPUG: June meeting

When: 6-8pm Thursday June 16, 2016
Where: Iovation
Who: Josh Berkus
What: HA PostgreSQL Cluster In A Box

Josh Berkus, crazy container guy and core team member, will demonstrate high availability Postgres using a tiny rack of mini servers, just 12″ high. Not only is this a fun stunt, but the software and techniques used are ones which work on real servers. This stack includes PostgreSQL, Patroni, Kubernetes, Atomic Host, Docker, etcd, and a stack of Minnowboards. Learn to scale out PostgreSQL with containers. He may also be able to demo the new multi-master PostgreSQL.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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!

Iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG April Meeting recap

What a great meeting last night! Made me feel a bit better about missing PgConf.US🙂

We had a good turnout, too; several first-timers showed up, some hauling themselves all the way in from Nike & Intel.

Thanks to Eric Ferreira, AWS Database Engineer, and Tony Gibbs, AWS Solutions Architect, for coming all the way down from Seattle to give this excellent talk. Eric is the originator of Redshift (it’s based on Pg 8.0.4), and he shared with us some of the features & why he made some of the decision he did.

Special thanks goes to Veronika Megler, RDS Professional Services team, for proposing the topic and arranging for Eric & Tony to come on down to PDX.

We’re already working on a return visit for late summer, so if you missed this meeting, you will get another chance.

PDXPUG: April meeting in two weeks

When: 6-8pm Thursday April 21, 2016
Where: Iovation
Who: Eric Ferreira, Database Engineer, Amazon Web Services
What: How to hide a petabyte-scale Data warehouse inside a small OLTP database

You may have heard that Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse. You’ve heard that it’s a shared-nothing cluster architecture, that it scales to hundreds of nodes and terabytes, and that it’s “based on Postgres”. How is that combination possible, and how much of Postgres survived that transformation? Eric Ferreira, who was the first engineer to work on Redshift, will discuss the design, tradeoffs and modifications made to make Redshift the scalable system it is today. Bring your questions!

We will also talk about ways to mix and match Postgres (OLTP) tables and Redshift (DW) tables on a single connection using pgboucer-rr and Postgres external data sources.

Eric started in the database world 26 years ago in Brazil and has implemented most flavors of RDBMS thought his career. He joined Amazon on 2003 and while on AWS/RDS worked on bringing various databases engines into the service. 5 years ago he ventured to start the project that would become Redshift.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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.

When you arrive at the Iovation office, please sign in on the iPad at the reception desk.

See you there!

(You can RSVP on our meetup group, if you like.)

PDXPUG: March meeting in two weeks

When: 6-8pm Thursday Mar 17, 2016
Where: Iovation
Who: Josh Berkus
What: Big Data on Pg 9.5

PostgreSQL 9.5, released in January, is full of tasty goodness for big data folks: UPSERT, new aggregation types, OLAP support, new Foreign Data Wrapper functionality, BRIN indexes, and more. Josh Berkus will give us a rundown of these features, with multiple demos.

Josh Berkus is a member of the PostgreSQL Core Team, and works at Red Hat where he manages the Project Atomic community. Containers, containers, containers! Which is appropriate, since he’s also a potter.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

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.

When you arrive at the Iovation office, please sign in on the iPad at the reception desk.

See you there!