PostgreSQL supports many procedural languages, which can be used to write user defined functions or stored procedures. There are four that are readily available as part of the standard PostgreSQL distribution: PL/pgSQL, PL/Tcl, PL/Perl, PL/Python. Yet procedural languages don’t have to be created as part of the core project. There are a number more that […]
Creating a PostgreSQL procedural language – Part 1 – Setup
/2 Comments/in Mark's PlanetPostgreSQL /by Mark WongPostgreSQL supports many procedural languages, which can be used to write user defined functions or stored procedures. There are four that are readily available as part of the standard PostgreSQL distribution: PL/pgSQL, PL/Tcl, PL/Perl, PL/Python. Yet procedural languages don’t have to be created as part of the core project. There are a number more that […]
Releasing Cloud Native BDR Operator for Kubernetes
/0 Comments/in 2ndQuadrant, Cloud Native /by Gabriele BartoliniI am very excited to announce the first release of "Cloud Native BDR Operator" for Kubernetes. BDR Operator is the first 2ndQuadrant product to be launched in the Cloud Native landscape and it is part of our long term commitment in this area: 2ndQuadrant indeed is a Silver member of the Cloud Native Computing Foundation […]
How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
/0 Comments/in 2ndQuadrant, PostgreSQL, Seemab's PlanetPostgreSQL /by Semab TariqThis article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In the article, we’ll use an example of Animals to predict whether they are mammals, Birds, Fish or Insects. Software versions We’re going to use 2UDA version 11.6-1 to implement the Machine Learning model. 2UDA version 11.6-1 combines: PostgreSQL 11.6 […]
Developing PostgreSQL for Windows, Part 1
/3 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter EisentrautAs a PostgreSQL developer, I occasionally need to make my code work on Windows. As I don’t normally use Windows and don’t have a permanent Windows installation around, this has always been a bit cumbersome. I have developed a few techniques to make this easier, and I figure they are worth sharing. And actually this […]
Barman Cloud – Part 1: WAL Archive
/5 Comments/in 2ndQuadrant, Barman, DevOps, Featured, Jonathan's PlanetPostgreSQL, PostgreSQL /by Jonathan BattiatoPreamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL server itself? Well, since Barman 2.10 this is now possible! How? Let’s discover that together in the following articles.
How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1
/39 Comments/in PostgreSQL, repmgr, Sadeq's PlanetPostgreSQL /by 2ndQuadrant Pressjsonb_set_lax
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanRecently 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. […]
Webinar: BDR – Latest Features & Updates [Follow Up]
/1 Comment/in Webinars /by Bilal IbrarBDR is a rapidly evolving project — and has been generating great interest from the Postgres community. In order to give further insights into BDR, how it works and where to best apply it, 2ndQuadrant organized a live webinar on 15th January 2020. The BDR – Latest Features and Updates webinar was hosted by Simon […]
Support for PostgreSQL’s System identifier in Barman
/3 Comments/in Florins PlanetPostgreSQL /by Florin IrionThe latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is and why it is a good thing that Barman uses it. What is the PostgreSQL system identifier? PostgreSQL gives a unique system identifier to every […]
Adventure in programming languages and simple statistics
/6 Comments/in Mark's PlanetPostgreSQL /by Mark WongThis is a story about how I found myself trying programming languages. I’ve been running an OLTP type database test (DBT-2, if you’ve heard of it), and noticed the post-processing reporting scripts for analyzing the database test results were running longer than I thought they would. I was running tests on 16 systems at the […]