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.
Mark & I left David Wheeler in charge of the PDXPUG February meeting while we were at SCALE last week.
Here’s David’s report:
This week Dave Kerr discussed using Bucardo mutli-master replication to gradually migrate a production database from EC2 to RDS. This work allowed his team to switch back and forth between the two systems with the assurance that the data would be the same on both. It also allowed them a fallback in case the RDS database didn’t work out: the S3 system would still be there. The discussion allowed those present to complain about Bucardo, EC2, RDS, and the French.
We had about 50 folks attend the PDXPUGDay 2014 last week, between DjangoCon and Foss4g. A lot of folks were already in town for one of the other confs, but several folks also day tripped from SeaPUG! Thanks for coming on down.
Thanks again to our speakers:
(Plus our lightning talk speakers: Josh B, Mark W, and Basil!)
And our sponsors:
And of course, PSU for hosting us.
Videos are linked from the wiki.
I updated our speaker and topic tag clouds for our 8th anniversary.
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.
6 folks turned out for our first Streaming Replication lab day. Here’s what we accomplished:
– lively discussion about the different pieces involved (WAL files, various GUCs, etc)
– worked on a step-by-step cheatsheet
– got sr running between two vms, between two Pg instances on the same VM on different ports, and between two Pg instances on the same VM via unix sockets
– learned some new tools (terminator, anyone?)
– spread the \e love
There will be a followup to this lab, as we didn’t cover everything we wanted to, and (of course) created more questions for ourselves.
Thanks to everyone who attended for taking time to hang out inside on a sunny day, and to EDB and Emma for lunch and facilities!
Our next regular meeting will be Thursday Feb 20th; watch for the announcement next week.
Last week, Eric Hanson showed off Aquameta’s “Spacebase”. Neat stuff! I’m still trying to wrap my head around some of it. 🙂
Here are Eric’s slides and the pg_meta git repo. Watch for Aquameta’s release on pg-announce.
No meeting in December, as usual. Go to the Seventh Winter Coders’ Social instead.
We’ll be back in January. An exciting lineup for the first few months of next year is taking shape.