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 with passphrase-protected SSL keys under systemd
/0 Comments/in Eisentraut's PlanetPostgreSQL /by Peter EisentrautPostgreSQL supports SSL, and SSL private keys can be protected by a passphrase. Many people choose not to use passphrases with their SSL keys, and that’s perhaps fine. This blog post is about what happens when you do have a passphrase. If you have SSL enabled and a key with a passphrase and you start […]
Buildfarm RSS feed
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanIf 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 […]
Postgres is the coolest database – Reason #1: Developers love it!
/3 Comments/in PostgreSQL, Umair's PlanetPostgreSQL /by Umair ShahidPostgreSQL has been my livelihood since 2004 – so I am naturally biased in its favor. I think it is the coolest piece of software on the planet, and I am not alone. DB-Engines See those 2 badges up there? That’s 2 years in a row. DB-Engines monitors a total of 343 databases and their […]
I am Developer! (And You Can Too!)
/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasA while back, 2ndQuadrant notified a few of us that we should get more involved in Postgres Development in some capacity. Being as I’ve essentially fallen off the map in corresponding with the mailing lists in general, it would be a good way to get back into the habit. But wait! Don’t we want more […]
PostgreSQL Buildfarm Client Release 10
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanAnnouncing 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 […]
Postgres-XL and global MVCC
/0 Comments/in 2ndQuadrant, Koichi’s PlanetPostgreSQL, Postgres-XL /by Koichi SuzukiBack to the PG I’m very excited to become a 2ndQuadrant member. I was involved in PostgreSQL activities in NTT group (Japanese leading ICT company, see here and here), including log shipping replication and PostgreSQL scale out solution as PostgresXC and PostgresXL. At NTT I had several chances to work very closely with 2ndQuadrant. After three years involvement in deep […]
Where and when you need a root.crt file
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanThis 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 […]
Having Group By Clauses — elein’s GeneralBits
/0 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by EleinSome people go to great lengths to avoid GROUP BY and HAVING clauses in their queries. The error messages are fussy but they are usually right. GROUP BY and HAVING key words are essential for good SQL reporting. The primary reason for GROUP BY is to reduce the number of rows, usually by aggregation. It […]
Sequential UUID Generators on SSD
/0 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas VondraAfter I shared the sequential UUID benchmarks a couple of weeks ago, one of the points raised in feedback was the choice of the storage space. I’ve intentionally used a fairly weak storage system (RAID10 on three 7.2k SATA drives) because I wanted to demonstrate the benefits. But a couple of readers suggested using SSDs might significantly reduce […]
JOIN LATERAL
/2 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by Elein