Installing 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 […]
Road test your patch in one command
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanIf you have Docker installed on your development machine, there is a simple way to road test your code using the buildfarm client, in a nicely contained environment. These preparatory steps only need to be done once. First clone the repository that has the required container definitions: git clone http://github.com/PGBuildFarm/Dockerfiles.git bf-docker Then build a container […]
Using Window Functions for Time Series IoT Analytics in Postgres-BDR
/0 Comments/in Haroon's PlanetPostgreSQL, Internet of Things, Time Series Data /by Muhammad HaroonInternet of Things tends to generate large volumes of data at a great velocity. Often times this data is collected from geographically distributed sources and aggregated at a central location for data scientists to perform their magic i.e. find patterns, trends and make predictions. Let’s explore what the IoT Solution using Postgres-BDR has to offer […]
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 […]
PostgreSQL Buildfarm Client Release 8
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanI have just release version 8 of the PostgreSQL Buildfarm client It can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-8.tgz or http://github.com/PGBuildFarm/client-code/archive/REL_8.tar.gz This release contains a number of small changes to make using the –from-source feature a bit nicer. It also contains a good deal of code cleanup to be perlcritic clean, with some exceptions, down to severity […]
PG Phriday: BDR Around the Globe
/2 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasWith the addition of logical replication in Postgres 10, it’s natural to ask “what’s next”? Though not directly supported yet, would it be possible to subscribe two Postgres 10 nodes to each other? What kind of future would that be, and what kind of scenarios would be ideal for such an arrangement? As it turns […]
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 […]
PG Phriday: Securing PgBouncer
/1 Comment/in Shaun's PlanetPostgreSQL /by Shaun ThomasWe all love PgBouncer. It’s a great way to multiplex tens, hundreds, or even thousands of client connections to a small handful of Postgres sessions. What isn’t necessarily so endearing, is that it can’t pass authentication from itself to Postgres, as each Postgres session may exist before the connection to PgBouncer is established. Or can […]
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 […]