PGDG announced the General Availability of PostgreSQL 9.6 on the 29th of September. Like each year, this new release brings with it a lot of exciting new features. Using these features, of course, requires installing PostgreSQL … a task that can be a touch daunting for novice users. 2UDA, a graphical installer for PostgreSQL, is designed to […]
More ‘POWER’ for PostgreSQL
/0 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniNow Available! Debian and Ubuntu packages for Power Architecture. The official announcement was published last Friday, September 30, 2016: the PostgreSQL repository for Debian and Ubuntu packages, apt.postgresql.org, has been extended by adding binary packages of IBM’s Little Endian POWER8 architecture.
How will Postgres-XL exploit the Parallel Query Capabilities of PostgreSQL 9.6?
/0 Comments/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeWith PostgreSQL 9.6 now out, many of our users and customers are asking us about the plans for Postgres-XL 9.6. The new release of PostgreSQL implements some new features, especially around parallel query processing and many are interested to know when those capabilities will be available in Postgres-XL. Postgres-XL itself is a massively parallel processing system. […]
2UDA – Installing PostgreSQL 9.6 the easy way
/0 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidPGDG announced the General Availability of PostgreSQL 9.6 on the 29th of September. Like each year, this new release brings with it a lot of exciting new features. Using these features, of course, requires installing PostgreSQL … a task that can be a touch daunting for novice users. 2UDA, a graphical installer for PostgreSQL, is designed to […]
Cool Runnings
/2 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsIn an earlier post I commented on a post by Evan Klitzke on his reasons for recommending a move from PostgreSQL to MySQL. The summary was that the technical details were incorrect, apart from two points. This post returns to those points to discuss what we’ve done about them. 1. When one indexed column is […]
2ndQuadrant speaks at PostgreSQL sessions
/1 Comment/in Giulio's PlanetPostgreSQL /by Giulio CalacociOn the 22nd of September I attended the 8th edition of the PostgreSQL sessions, a conference in Lyon organised by Dalibo and Oslandia, as a speaker.
Untangling the PostgreSQL upgrade
/8 Comments/in pglogical, PostgreSQL /by Martín MarquésPostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server. Upgrading to a new major version is a task which has a high ratio of preparation over […]
Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
/3 Comments/in 2ndQuadrant, Featured, Umair's PlanetPostgreSQL /by Umair ShahidThe latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source database, PostgreSQL strives to release a major version roughly once every year. With an active and collaborative community, this PostgreSQL release boasts impressive features and updates thanks […]
The PostgreSQL 9.6 release is almost here!
/3 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David RowleyThe PostgreSQL 9.6 Release It feels like only just a few months ago that we were celebrating the release of PostgreSQL 9.5.0, but already we’re very close to the 9.6.0 release! For me personally, I’m very excited about this particular release of PostgreSQL. It was just 5 or 6 months ago that I was busy […]
Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5
/1 Comment/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressIn the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual switchover involves just two nodes that have to be aligned. But what happens with HA clusters when there are several (also cascading) standbys? Now, consider […]
pgFincore 1.2, une extension PostgreSQL
/0 Comments/in Cedric's FR PlanetePostgreSQL, PostgreSQL /by 2ndQuadrant PresspgFincore 1.2 est une extension PostgreSQL pour auditer et manipuler le cache de pages de données du système d’exploitation. L’extension a déjà une histoire de 7 ans d’utilisation, avec des évolutions correspondant aux besoins de production. Télécharger ici la dernière version 1.2, compatible avec PostgreSQL 9.6.