PostgreSQL Archives - 2ndQuadrant

Developing PostgreSQL for Windows, Part 3

March 24, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

Let’s wrap this up. In part 1 of this blog series, I explained the different Windows build targets supported by PostgreSQL. In part 2, I showed how to test patches for Windows compatibility and how to easily spin up a Windows environment for testing and simple development. Now, in this third and final part, we’ll […]

PostgreSQL is the worlds’ best database

March 12, 2020/0 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

The title is not clickbait or hyperbole. I intend to prove that by virtue of both design and implementation that PostgreSQL is objectively and measurably a better database1 than anything currently available, with or without money considerations.

How in the world can I claim and justify such a lofty statement? Read on, gentle nerd. I promise that your time will not be wasted.

How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall

March 11, 2020/2 Comments/in 2ndQuadrant, PostgreSQL, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

In today’s world, organizations increasingly face an unprecedented level of threat of cyberattacks against their information assets. Cyberattacks can come in many forms. One such attack is called SQL injection. With SQL injection, rogue players target the backend database of any system. Usually, these systems are public-facing. Hackers try to send seemingly innocuous and regular […]

Developing PostgreSQL for Windows, Part 2

March 4, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

In the previous blog post, we discussed the different Windows build variants that PostgreSQL supports. In this post, we’ll discuss how, as a Unix-based developer, you can check whether your patch might work on Windows. (For simplicity, I’ll say “Unix” to mean Linux, BSD, macOS, and similar.) First, there are a few ways to check […]

Researching PostGIS slowness (2019 edition)

February 27, 2020/2 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

Just as last year was ending, one of our long-time customers came to us because one of their long-existing PostgreSQL queries involving PostGIS geometry calculations was much slower for specific values. We researched the problem and found out how to solve it; read on! What we found as the cause of the problem will surprise […]

How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2

February 11, 2020/8 Comments/in PostgreSQL, repmgr, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

This 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 […]

How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)

February 4, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Seemab's PlanetPostgreSQL /by Semab Tariq

This 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

January 29, 2020/3 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

As 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

January 27, 2020/0 Comments/in 2ndQuadrant, Barman, DevOps, Featured, Jonathan's PlanetPostgreSQL, PostgreSQL /by Jonathan Battiato

Preamble 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

January 24, 2020/3 Comments/in PostgreSQL, repmgr, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

repmgr 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 […]

Developing PostgreSQL for Windows, Part 3

PostgreSQL is the worlds’ best database

How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall

Developing PostgreSQL for Windows, Part 2

Researching PostGIS slowness (2019 edition)

How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2

How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)

Developing PostgreSQL for Windows, Part 1

How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1

Support & Services

Products

Postgres Learning Center

About Us