BucardoApril 5, Sunday, 10amBucardo is a replication system for Postgres that uses triggers to asynchronously copy data from one server to many others (master-slave) or to exchange data between two servers (master-master). We’ll look at replication in general and where Bucardo fits in among other solutions, we’ll take a look at some of its features and use-cases, and discuss where it is going next. We’ll setup a running system along the way to demonstrate how it all works.

Monitoring Postgres with check_postgres.plApril 4, Saturday, 2:30pm
What should you monitor? And how? We’ll look at the sort of things you should care about when watching over your Postgres databases, as well as ways to graph and analyze metadata about about your database, with a focus on the check_postgres.pl script.

The Power of psqlApril 4, Saturday 10:30am
All about everyone’s favorite Postgres utility, psql, the best command-line database interface, period. We’ll cover basic and advanced usage.

I’ve seen a few of Greg’s talks — The Magic of MVCC, Cloning an elephant and a few others. He’s a great speaker and cool guy. And he’s my boss. But I’m not just saying that because he’s my boss! Really!

He doesn’t like to brag about himself, so I’m gonna help him out. He maintains DBD::Pg, check_postgres.pl, Bucardo and has had MANY patches committed to PostgreSQL. He’s also a volunteer for the PostgreSQL sysadmins team, and specifically helps maintain the git repo box. He’s a contributor to the MediaWiki project. He’s on the board of the United States PostgreSQL Association. He’s basically awesome.

If you’re gonna be there, you should check out his talks. And if you can’t make it, here’s hoping Josh Drake records the talks and shares them with us all!

Check out the slides from my ptop talk. I was very happy with the end result of the presentation. I had a few people talk to me about the project afterward, including the author of innotop, a perl-based monitoring tool for MySQL. I’m sure we can steal some ideas from that project!

I haven’t gotten much done with ptop since I’ve been back. I’ll have some time after LUG Radio Live!

The last few talks have been rolling in. I’m very excited about the round table Sunday morning with Joshua Drake (USPA and PostgreSQL SPI Liaison), Bruce Momjian (PostgreSQL Core) and Magnus Hagander (PostgreSQL-EU). Bring some questions! We’ll be on IRC taking remote questions as well.