With applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes, or even changing data types. In order to discuss Schema Migration in detail, 2ndQuadrant hosted the “Application Schema Migration” webinar, providing an in-depth overview of […]
+39 0574 159 3000
Announcing New PostgreSQL Online Training Series
/0 Comments/in 2ndQuadrant, training /by Umair Shahid2ndQuadrant’s training courses are very popular amongst PostgreSQL professionals and enthusiasts, and have hosted more than 500 trainees in the last 10 years. Our current Public and On-Site training options, however, have their limitations. We are often asked: “When are you going to offer a training course in my region?“ It’s disheartening to tell people […]
Creating a PostgreSQL procedural language – Part 2 – Embedding Julia
/1 Comment/in Mark's PlanetPostgreSQL /by Mark WongJulia provides an API so that Julia functions can be called from C. PL/Julia will use this C API to execute Julia code from its user defined functions and stored procedures. Julia’s documentation provides an example C program that starts up the Julia environment, evaluates the expression sqrt(2.0), displays the resulting value to the standard […]
How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
/0 Comments/in PostgreSQL, repmgr, Sadeq's PlanetPostgreSQL /by Sadequl HussainThis is the second installment of a two-part series on 2ndQuadrant’s repmgr, an open-source high-availability tool for PostgreSQL. In the first part, we set up a three-node PostgreSQL 12 cluster along with a “witness” node. The cluster consisted of a primary node and two standby nodes. The cluster and the witness node were hosted in […]
Webinar: Application Schema Migration [Follow Up]
/0 Comments/in Webinars /by Liaqat AndrabiWith applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes, or even changing data types. In order to discuss Schema Migration in detail, 2ndQuadrant hosted the “Application Schema Migration” webinar, providing an in-depth overview of […]
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
/2 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
/0 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
/3 Comments/in PostgreSQL, repmgr, Sadeq's PlanetPostgreSQL /by Sadequl Hussainrepmgr is an open-source toolset from 2ndQuadrant, a leading specialist in PostgreSQL-related technologies and services. The product is used to automate, enhance, and manage PostgreSQL streaming replication. Streaming replication in PostgreSQL has been around since version 9.0. Natively setting up and managing streaming replication involves a number of manual steps which includes: Configuring replication parameters […]