I love the PostgreSQL concurrency model. Have I mentioned that lately? Today, I want to tell you about snapshot exports. You're probably used to the READ COMMITTED isolation level. (That's the default.) This mode means you can see any committed data, whether it was commmitted before the transaction started or…
I noticed a PostgreSQL 9.1 streaming replication slave had stopped replicating. I dug in a bit, and... well, this is a new one: 08:57:57 CDT FATAL: could not receive data from WAL stream: SSL error: sslv3 alert unexpected message 08:59:51 CDT LOG: invalid magic number…
Background: I have two problems with my computer that I'd like to solve. The CPU is a pain point. It's a quad-core i7, but it spends a lot of time at 100%. (Test suites, transcoding media, crunching weather models, etc.) I would upgrade, but none of the newer laptops are…