PDXPUG: June meeting in two weeks

When: 7-9pm Thu June 19, 2014
Where: Iovation
Who: David Kerr
What: Postgres on Docker

David Kerr’s back this month to talk about Postgres on Docker.

Linux containers are finally getting their day, and leading the way is a project known as Docker. Docker is in use today at places like Google, eBay, and New Relic and aims to change the way we think about deploying software.

Join us as we get a quick primer on Docker and then run it through its paces with the not-so-typical, but interesting, use-case of running PostgreSQL in a container.

We’ll look at benchmarks, and various novel use cases where Docker may be an interesting fit in the database world.

Dave Kerr is a recovering DBA, PostgreSQL evangelist and is currently working as a Software Engineer on the Site Engineering team at New Relic.

We have a new meeting location while the Iovation offices are being renovated. We’re still in the US Bancorp Tower at 111 SW 5th (5th & Oak), but on the ground floor in the Training Room. As you face the bank of elevators from the main lobby, take a good deep breath of drywall dust and head to your right to a hallway. Follow the hallway as it turns to the left. The Training Room is the 2nd door on your right and is labeled “Training Room”. There is no room number.

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: May meeting next week

When: 7-9pm Thu May 15, 2014
Where: Iovation
Who: Selena Deckelmann
What: The Final Crontab

Crontabber is a new open source utility that makes cron jobs automatically retriable, uses Postgres to store useful information like duration and failure reasons, and integrates easily with Nagios. Come hear about the reasons Mozilla created this tool, and how it’s helped us make our environment more stable and reliable, and less prone to getting calls on the weekend.

Selena Deckelmann is a major contributor to PostgreSQL and a data architect at Mozilla. She’s been involved with free and open source software since 1995 and began running conferences for PostgreSQL in 2007. In 2012, she founded PyLadiesPDX, a portland chapter of PyLadies. She founded Open Source Bridge, Postgres Open and speaks internationally about open source, databases and community. You can find her on twitter (@selenamarie) and on her blog. She also keeps chickens and gives a lot of technical talks.

We have a new meeting location while the Iovation offices are being renovated. We’re still in the US Bancorp Tower at 111 SW 5th (5th & Oak), but on the ground floor in the Training Room. As you face the bank of elevators from the main lobby, take a good deep breath of drywall dust and head to your right to a hallway. Follow the hallway as it turns to the left. The Training Room is the 2nd door on your right and is labeled “Training Room”. There is no room number.

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 Lab – Streaming Rep Saturday Part 3 happens in two weeks.

When: Thu May 8, 6pm-9pm (dinner provided)
Where: Emma, B-side 6 Building, 5th floor

Yeah, we’re not quite finished yet. But I expect that this will be the last one & we’ll move on to something else next time.

The general plan:
- review of setup
- try this: https://github.com/darkixion/pg_rep_test
- look into the monitoring
- alternatives to the ‘cp’ archiving command example
- failover & recovery

As before, you are welcome to come to this one, even if you missed the first two.

Please come prepared with a laptop with two Postgres clusters of the same version installed. You can do this by having a couple of VMs, linux containers, or just run two instances of Pg on different ports. If you don’t understand how to do that, or you don’t have a laptop of your own, please let me know when you sign up, and we’ll take care of that for you.

Space is limited, so please sign up in advance.

Dinner provided by PDXPUG.
Space provided by Emma.

What’s a Chelnik, you ask?

PDXPUG’s official logo is a mask-wearing Slonik:
pdxpug_logo

Hir name is Chelnik. Sort of like Slonik, but different.*

A couple years ago, my co-leader Mark Wong starting making amigurumi, little crocheted stuffed animals. I think he started with Angry Birds, but pretty soon after, he made a Chelnik (the one in the banner on this blog, in fact). And then another…

He took one to PgCon 2012, and donated it to the charity auction, where it netted $500 for The Ottawa Mission.

To date, Mark’s made a dozen of these elephants for sale or auction at various Pg conferences, raising money for donations to the following organizations:
PGUS ($350), The Ottawa Mission ($680), Chicago Hopes ($640), and most recently at PGConf NYC, $1200 for Heartsong.

Thanks to Mark and everyone who’s participated in these auctions.

stowaway_cropped

* No, it doesn’t really mean anything. Beer was involved in the naming.
There’s a tumblr with some photos of the various Chels he’s distributed.

PDXPUG: April meeting this week

When: 7-9pm Thu April 17, 2014
Where: Iovation
Who: Brian Panulla
What: Intro to Graph Databases

Brian Panulla is a Business Intelligence Developer at Acureo. He’s been fulfilling PDXPUG’s rhombic triacontahedron needs for over a year. Next week, he’ll be giving us an Intro to Graph Databases!

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.

See you there!

PDXPUG: March meeting in two weeks

When: 7-9pm Thu Mar 20, 2014
Where: Iovation
Who: Mark Wong
What: An Adventure in Data Modeling: The Entity-Attribute-Value Model

Emma, Inc. is an email marketing company that provides a Web based
application for managing email lists and marketing campaigns. This is a
tale about Emma’s experience with a database schema design refactor that
is now using the Entity-Attribute-Value (EAV) data model on the members
in email lists. We will briefly describe the previous data model and
why we had to move to a new one. This is followed by all the places
where Emma stumbled and recovered in implementing the EAV data model and
rebuilding the application around it. Finally we will touch on where
Emma might go next with respect to the data.

Mark is a Data Architect at Emma, Inc. and works with their PostgreSQL
database systems.

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.

See you there!

Streaming Rep Lab Part 2 – recap

We had our Streaming Rep Lab followup last night1. It was mostly successful: half of the new people got it up & running, and the people who’d been at the previous workshop got to experiment with almost everything on the agenda.

The cheatsheet is up on our git repo: https://github.com/pdxpug/cheatsheets 2.

We talked a bit about monitoring and messed around with some of the available functions (e.g. pg_last_xact_replay_timestamp), started looking at pg_xlogdump (for “educational purposes”, of course), checked out a packet capture between the master & standby, and finished up with breaking the link between the master & the standby: the standby cried a bit about not being able to reach the master, but as soon as we restored the link, everything was fine.

The overarching theme of the evening is that we need to come up with a more robust plot to make Postgres fail in an interesting way.

SELECT pg_last_xact_replay_timestamp(); will give you a WAL ID, but is only valid on a standby.
The function to translate it to a file name: SELECT pg_xlogfile_name([id]); can only be run on the master. So that’s kinda weird and requires some puzzling out.

I started a wiki page of ideas for future labs, but we may be hung up on streaming rep & breaking it for a little while :)

Thanks to Emma for hosting & providing dinner!



1 – With a puppy.
2 – Yes, I know there is something wrong with the step numbering. It renders correctly in github’s md validator, but not when I upload it.