Andrew's PlanetPostgreSQL Archives - 2ndQuadrant

When to deploy or upgrade to a new major PostgreSQL release

September 25, 2020/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

With the release yesterday of PostgreSQL 13, now is perhaps a good time to talk about when and how it should be deployed. We often get questions at such times like "When should I upgrade?" and "Should I switch my new planned deployment to the new release?" The first thing to consider is this: you […]

Updating the PostgreSQL root.crt file

August 20, 2020/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Let’s say you have two PostgreSQL servers that connect to each other using postgres_fdw. They communicate over TLS and they use client certificates to authenticate. You have a Certificate Authority you have set up, and it has issued server and client certificates for each server. On server one you have server1.crt, server1.key, client1.crt, client1.key and […]

NSS on Windows for PostgreSQL development

August 5, 2020/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Daniel Gustafsson has done some terrific work on using NSS as an alternative TLS library to OpenSSL for PostgreSQL. I’ve done some work making that build and run on Windows. Daniel recently asked how to get a working NSS on Windows to use for development, and this blog is about that process. First you need […]

Partitioning a large table without a long-running lock

July 21, 2020/8 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Let’s say you have an application that has a huge table and that needs to be available all the time. It’s got so big that managing it without partitioning it is getting increasingly difficult. But you can’t take the table offline to create a new partitioned version of the table, which would take a great […]

jsonb_set_lax

January 20, 2020/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Recently there were some complaints about the behaviour of the jsonb_set function. Specifically, the complain was that if the value argument of the function is null the result is null. This happens because the function is declared STRICT, like many PostgreSQL functions. STRICT is in fact another way of spelling RETURNS NULL ON NULL INPUT. […]

Release 11 of the PostgreSQL Buildfarm client

September 24, 2019/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Release 11 of the PostgreSQL Buildfarm client is now available. The release includes numerous bug fixes plus following features: Allow a list of branches as positional arguments to run_branches.pl This overrides what is found in the config file. The list can’t include metabranches like ALL, nor can it contain regexes. improve diagnostic capture for git […]

Buildfarm RSS feed

April 8, 2019/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

If you’ve visited almost any web page on the PostgreSQL Build Farm server in the last few days you might have noticed that it is sporting a new RSS feed, of changes in status. This is similar to the information on the buildfarm-status-green-chgs mailing list, except that it has all status changes, not just to […]

PostgreSQL Buildfarm Client Release 10

April 4, 2019/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Announcing Release 10 of the PostgreSQL Buildfarm client Principal feature: support for non-standard repositories: support multi-element branch names, such as “dev/featurename” or “bug/ticket_number/branchname” provide a get_branches() method in SCM module support regular expression branches of interest. This is matched against the list of available branches prune branches when doing git fetch. This feature and some […]

Where and when you need a root.crt file

March 29, 2019/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

This is something people seem to get confused about quite often. A root.crt file is used to validate a TLS (a.k.a. SSL) certificate presented by the other end of a connection. It is usually the public certificate of the Certificate Authority (CA) that signed the presented certificate, and is used to validate that signature. If a non-root […]

PostgreSQL Buildfarm Client Release 9

November 12, 2018/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew Dunstan

Announcing Release 9 of the PostgreSQL Buildfarm client. Along with numerous fixes of minor bugs and a couple of not so minor bugs, this release has the following features: new command line parameter –run-parallel for run_branches.pl runs all branches in parallel, possibly across animals as well new config setting max_load_avg inhibits a run if the […]

2ndQuadrant is now part of EDB