#334 — December 4, 2019

Read on the Web

Postgres Weekly

Discovering Lesser-Known PostgreSQL 12 Features — If you’re an ardent Postgres Weekly reader, you’ll know about a few of these, but 12 was such a big release that there were lots of minor improvements people haven’t blogged about yet.

Kaarel Moppel

Playing with Postgres's 'SQL Beautification' Skills — It’s common to use a ‘SQL beautifier’ to turn otherwise ugly queries into more attractively formatted strings.. but did you know Postgres has some built-in functionality you can misuse to similar ends? I’m not sure how useful this is but it’s an interesting corner of Postgres to be aware of.

Hans-Jürgen Schönig

Managed PostgreSQL by DigitalOcean — Deploy a highly scalable PostgreSQL cluster with no admin overhead.

DigitalOcean sponsor

Hope Is Not A Strategy: How Hardware Issues Can Affect Your Postgres Data — Not a technical post, but more a lesson or words of advice. A recent announcement by HPE (Hewlett Packard Enterprise) about some SSDs that would fail suddenly after 32,768 hours of operation might give you some food for thought as to how you’d deal with such a failure in your own setup.

Joe Conway

Setting SSL/TLS Protocol Versions in Postgres 12ssl_min_protocol_version and ssl_max_protocol_version are two new config settings to control the lowest and highest versions of the SSL/TLS protocol family you want Postgres to support.

Peter Eisentraut

A Postgres 12 Improvement: Fewer Benign Log Entries — A look at a surprisingly minor Postgres 12 improvement, but in the long run, fewer unnecessary log messages like this one can only be a good thing.

Jobin Augustine

Top Ten Reasons to Migrate from Oracle to Postgres — We’re no doubt preaching to the converted here (!) but if you know someone considering the move, here’s some of the advantages of migrating from Oracle to Postgres.

Paul Namuag

supported by EnterpriseDB

💡 Tip of the Week

Did you know about the Postgres IRC (chat) channel?

Yesterday, on Twitter, Kelly Sommers noted just how active and fantastic the Postgres IRC channel was, and I realized I had been unaware of its existence till now.

There's around 1000 people lurking on the channel and the Postgres site has more info here. If you have an IRC client running already, you can go to #postgresql on irc.freenode.net.

If you don't have an IRC client, never fear, webchat.freenode.net is a Web-based client you can use to check out the chatroom in the next 30 seconds.

Please be kind and patient with any questions you may have and remember that #postgresql is a community space and you will be expected to adhere to the PostgreSQL code of conduct.

This week's tip is sponsored by EnterpriseDB, the most complete open-source database platform. Learn more about our enterprise Postgres solutions.

📂 Code and Projects

pg-structure: Extract the Structure of a Database into JavaScript — Provides a mechanism for ‘reverse engineering’ a Postgres database by letting you quickly grab hold of tables, columns, indexes, schemas, etc.

Özüm Eldoğan

Crunchy High-Availability PostgreSQL Keeps Critical Applications Up — Leverage trusted open source software to ensure your PostgreSQL data is always available.

Crunchy Data sponsor

pg_variables: Session Wide Variables for Postgres

Postgres Professional

Azure Database for PostgreSQL: Hyperscale (Citus) Now Generally Available — Citus, now a Microsoft technology, transforms a Postgres database into something that can easily scale horizontally (if you’re on Azure, naturally).

Craig Kerstiens (Microsoft)

🗓 Upcoming Events

  • PgDay SF (January 21 in San Francisco) — A one-day, single-track event.
  • PgConf.Russia (Febuary 3-5 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions.
  • PGConf India (Febuary 26-28 in Bengaluru, Maharashtra, India) — A dedicated training day and a multi-track two-day conference.
  • pgDay Paris 2020 (March 26 in Paris, France) — Learn more about the world’s most advanced open source database among your peers.
  • Swiss PGDay 2020 (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community.

If you are running a Postgres related event that's beyond the scale of a small local meetup or user group (so, say, 50+ people with people likely to travel to your event from afar), let us know and we can include it here in future issues.