Handling dates, time, and time zones is a very complex matter and gets even more complicated when you implement them into databases. PostgreSQL is well equipped to handle such complexities and provides powerful, native support for handling date/timestamp data types. In order to explore the proper use of dates, timestamps, and interval data types, 2ndQuadrant […]
Security and Compliance with PostgreSQL [Webinar]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by LiaqatFor businesses handling personal data, the security of their database is a serious matter. Faced with an increasing number of attacks, organizations must improve their security and compliance policies, enhance their database infrastructure, and ensure all proper security protocols are in place. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on […]
Backup manifests and pg_verifybackup in PostgreSQL 13
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniPostgreSQL 13 introduces two useful features to enhance automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. In this short article I attempt to provide an overview of them.
Webinar: KNN Indexing in PostgreSQL [Follow Up]
/0 Comments/in Webinars /by Bilal IbrarK-nearest neighbor is a proximity algorithm to find data in order of distance. Typically, this data cannot be indexed in advance, as both the centroid and the data can be in constant motion. PostgreSQL provides efficient searching algorithms for finding proximity data on the fly, including unique, high-performance indexing options. For a deeper understanding of […]
How to migrate from inheritance-based partitioning to declarative partitioning in PostgreSQL
/1 Comment/in Caterina's PlanetPostgreSQL /by Caterina MaginiPartitioning is one of the coolest features in the latest PostgreSQL versions. PostgreSQL 10 introduced native partitioning and more recent versions have continued to improve upon this feature. This article provides a guide to move from inheritance based partitioning to declarative partitioning, using the native features found in PostgreSQL 11+.
How to use Tree Machine Learning model with 2UDA – PostgreSQL and Orange (Part 4)
/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab TariqThis article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we will use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We are going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL […]
Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
/4 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk RoybalWe find ourselves at the third article in the Oracle migration series. This time, we look at those strange operators that modify the WHERE clause criteria in Oracle (+). Like everything else, PostgreSQL has a solution for that.
Webinar: Date/Timestamp types in PostgreSQL [Follow Up]
/0 Comments/in Webinars /by Bilal IbrarHandling dates, time, and time zones is a very complex matter and gets even more complicated when you implement them into databases. PostgreSQL is well equipped to handle such complexities and provides powerful, native support for handling date/timestamp data types. In order to explore the proper use of dates, timestamps, and interval data types, 2ndQuadrant […]
A tale of password authentication methods in PostgreSQL
/0 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter EisentrautLet’s say you want to implement a password authentication method in a client/server protocol. How would you do that and what would be the possible problems? The following is the story of how this was done in PostgreSQL. password In the beginning, PostgreSQL only had the method that is now known as "password" in pg_hba.conf. […]
Automated rapid switchover with a BDR database cluster in Kubernetes
/0 Comments/in Cloud Native /by Gabriele BartoliniDiscover how BDR and Kubernetes allow you to reach very high uptimes in a year for a database solution thanks to the fast failover capability. Watch the demo! In my previous article we went through the deployment of a BDR database in a Kubernetes cluster using our Cloud Native BDR Operator, and in particular we […]
Webinar: Creating Graph Databases in PostgreSQL [Follow Up]
/0 Comments/in Webinars /by Bilal IbrarPostgreSQL is a hyperconverged DBMS offering functionalities that otherwise require specialized database technology. Developing a Graph Database is one such use case. To explore Graph Databases in more detail, 2ndQuadrant held a live webinar, “Creating Graph Databases in PostgreSQL”, which was hosted by Simon Riggs (CEO at 2ndQuadrant). In this webinar, Simon demonstrated how PostgreSQL […]