PostgreSQL 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 total execution time. Specifically when skipping a release in the middle, for example, when you jump from version 9.3 to version 9.5.
On the other hand, point release upgrades don't need as much preparation. Generally, the only requirement is for the postgres service to be restarted. There are no changes to the underlying data structure, so there's no need to dump and restore. In the worst case scenario you may need to recreate some of your indexes (more…)
Did you know - 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?!
With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The 5432...MeetUs! post-conference training is your chance!
In addition to the Kanban System Design training course with Dragos Dumitriu we mentioned last week, there will be a variety of other training courses in the days following the 5432...MeetUs! conference. When you attend a course with 2ndQuadrant, you learn from experts who understand PostgreSQL, the platforms, programs, and languages at the deepest level.
Learn in depth about the (more…)
The second edition of the 5432...MeetUs! conference is sure to be one to remember. They will be hosting PostgreSQL experts, users, and contributors from all over the world. With talks, workshops, and trainings - we are sure to stay busy every minute!
With speakers like Zalando's Valentine Gogichasvili and IBM's Andrea Vercellini, it will be great to be in good company with fellow PostgreSQL supporters and hear real life case studies of individuals who have successfully applied PostgreSQL and Open Source practices and tools within their enterprises.
In addition to the independent developers, other companies we look forward to catching up with at the event include Dalibo, Subito.it, Navionics, InnoGames, PaxLife, and more.
Check out who all will be in attendance!
The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer a data structure in a “key-value” array, dictionary style (widely used in the field of development) and, at the same time, ensures all the advantages of a relational database.