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…