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.


Streaming Rep Lab, Part 2 – two weeks from today

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

This is in addition to our regular monthly meeting, which is next week.

We didn’t quite get everything covered last time, so we’re having a followup lab to:
– practice recovery (which means we’ll be breaking it ๐Ÿ™‚ )
– discuss monitoring options
– check out the human-readable WAL

You are welcome to attend if you couldn’t make the first lab. We’ll have a quick review of what we did, but won’t be spending too much time on it. As with the previous lab, there is no set schedule or exercises – we’ll make it up as we go.

Please come prepared with a laptop with the SR setup of your choice. Bonus points if it’s broken and we need to troubleshoot it. (SR, not your hardware.)

Space is limited, so please sign up in advance:

Streaming Rep Saturday

We’re having a lab day!

When: Sat Jan 25, 10am-2pm (lunch provided)
Where: Emma, B-side 6 Building, 5th floor

Come experiment with streaming rep in a friendly environment with a delicious lunch and beverages, instead of in a crisis environment with your boss breathing down your neck.

Agenda, as much as we ever have one:
– Discussion of the various configurations (streaming rep, hot standby, etc)
– Actual setup
– Is it working?
– Discussion of results
– If time allows, we’ll come up with creative ways to break it and look at what’s required to recover.

As for previous labs, we have limited space. Please sign up here.

Please come prepared with a laptop with two VMs, both with the latest version of Postgres installed. If you don’t have a laptop, we can set up VMs for you on the community equipment – please indicate that when you sign up, because we need some lead time to do that.

If you have any tips, tricks, questions, or horror stories, please bring those, too!

Lunch provided by EnterpriseDB.
Space provided by Emma.

September Meeting next week!

Come on out for the PDXPUG monthly meeting!

Where: FreeGeek http://www.freegeek.org
When: 7pm 17 Sept, 2009
Who: David Wheeler
What: Unit Test Your Database!

Talk description:

Given that the database, as the canonical repository of data, is the most important part of many applications, why is it that we don’t write database unit tests? This talk promotes the practice of implementing tests to directly test the schema, storage, and functionality of databases.

We’re all used to unit testing our applications by now. The Extreme and Agile programming movements have done a great deal to promote unit testing, to the extent that many of us are now dependent on tests to assure that our applications work reliably. But how often do we test the database underlying our applications? Given that the database, as the repository for all of the knowledge and data for an application, just might be the single most important part of that application, the time for standardized database unit testing has come.

This talk promotes the practice of writing and running unit tests that directly test the schema, storage, and functionality of application databases. Following a review of the available PostgreSQL unit testing frameworks, we’ll review examples of testing tables, views, columns, constraints, indexes, triggers, and functions. The idea is to promote complete test coverage every aspect of a database, independent of application unit tests, to ensure reliably canonical data integrity.

After David’s talk, we’ll head to the SE Lucky Lab to crash the PDX.pm weekly hackathon.

See you there!

PDXPUG October Meeting – Oct 16

Even though PG Con West will be going on October 10-12 in sunny (we hope) Portland, we will still have our monthly meeting on October 16, 2008. This month, Selena Deckelmann will provide a tutorial on setting up Point-in-time recovery (PITR) for your PostgreSQL installation. This will be hands on, with the ever-dangerous LIVE DEMO.

We will be meeting at FreeGeek – 1731 SE 10th Avenue, Portland, OR.

In November, our own Randal Schwartz of Stonehenge Consulting (http://www.stonehenge.com/) will be giving a talk on Smalltalk and Postgres integration.

Looking forward to seeing everyone there….and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.


Next Meeting: March 20, 2008

TOPIC: Managing internet services: using the right tool for the job
SPEAKER: Ed Sawicki
WHEN: March 20, 2008, 7pm
WHERE: FreeGeek, 1731 SE 10th Ave, Portland, OR 97214

Also: What the heck is the United States PostgreSQL Association?, Selena Deckelmann

AND: ELEPHANT BUTTONS! courtesy of David Fetter.

Here’s what Ed had to say about his presentation:

“I’ll probably end up doing live benchmarks, showing code snippets, and explaining my rationale for why I chose
to do things the way I do.

“My current projects involve managing a variety of Internet services, such as spam suppression and the associated per-user black/white list management, DNS record management, PKI key management, and a variety of others. Some of these services require that I deal with the storage and retrieval of both discrete IP addresses and CIDR blocks in real time.

“I’ve had to decide on data stores that include plain text files, SQL using SQLite and Postgres, and constant databases using tinycdb. At every stage of development I’ve had to decide which of these was best based on tools available and performance testing. For example, Postgres has IP and CIDR data types and adequate facilities to search for IP addresses within a CIDR block but performance pales in comparison to simpler tools that use plain text files. As a result, my applications use various data stores instead of just one.””

Refreshment afterward at the Lucky Lab!