Webinar : Ansible & PostgreSQL [Follow Up]
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiPostgreSQL administration, configuration, and deployment can be a tough ask while working in an agile environment with strict deadlines. The key to simplify these operational tasks for PostgreSQL is Ansible – an open source IT automation tool. To explain how these technologies work together, 2ndQuadrant hosted a Webinar on PostgreSQL deployments using Ansible. The webinar […]
Scaling IoT Time Series Data with Postgres-BDR
/3 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad HaroonA couple of weeks back, I wrote about how to use Windows Functions for time series IoT analytics in Postgres-BDR. This post follows up on IoT Solution‘s time series data and covers the next challenge: Scalability. ‘Internet of Things’ is the new buzzword as we move to a smarter world equipped with more advanced technologies. From transport […]
Data Modelling – It’s a lot more than just a diagram
/0 Comments/in 2ndQuadrant /by George McGeachieIf the title of this blog post rings a bell with you, perhaps you were at PG Day in Horwood House in 2014, when I stood up for 5 minutes to make the case for data modelling; a data model is much more than just a diagram. I shouldn’t be, but I am often amazed […]
Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
/1 Comment/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Postgres Installer, PostgreSQL /by Liaqat AndrabiInstalling the world’s top enterprise-class open source database – PostgreSQL – is now a whole lot easier with Postgres Installer. Postgres Installer is a GUI based, user-friendly installer for PostgreSQL that is digitally signed and certified by 2ndQuadrant. The installer is currently available for PostgreSQL versions 9.5, 9.6, 10, 11 and 12(beta) and has the […]
Introduction to Postgres-BDR [Webinar Follow-up]
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiThe announcement of Postgres-BDR 3.0 last month at PostgresConf US had been long-awaited in the PostgreSQL community. Complex use cases from customers have driven the development of BDR far beyond the original feature set, resulting in a more robust technology than ever imagined – so we’re happy to say that it was worth the wait. Postgres-BDR […]
Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
/0 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin YildirimI’ve started to write about the tool (pglupgrade) that I developed to perform near-zero downtime automated upgrades of PostgreSQL clusters. In this post, I’ll be talking about the tool and discuss its design details. You can check the first part of the series here: Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I). The tool is […]
2ndQuadrant at PostgresConf US 2018
/0 Comments/in 2ndQuadrant, PostgreSQL /by Marriya MalikThe world of PostgreSQL continues to grow stronger by the year! Last week we saw it all come together at PostgresConf US 2018 in Jersey City. The conference was held to promote awareness and usage of PostgreSQL through tutorials and case-studies, as well as providing the opportunity to listen first hand to some of the best […]
OmniDB: Console Tab
/0 Comments/in 2ndQuadrant, OmniDB, William's PlanetPostgreSQL /by William IvanskiIntroduced in OmniDB 2.6.0, the new OmniDB Console Tab provides an easy and comfortable way to interact with your databases. Users familiar with the psql command line utility will find that Console Tab behaves very similarly. In fact, many of the backslash commands Console Tab provides are present in psql. For example, \? shows a […]
Partition Elimination in PostgreSQL 11
/16 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David RowleyThe feature freeze for the PostgreSQL 11 release is now upon us. During the last few days my colleague Álvaro Herrera pushed two changes into the development branch of PostgreSQL: 1. Faster Partition Pruning 2. Partition Pruning at Execution Time These patches aim to improve the performance and usability of the declarative table partitioning feature […]