Clustering, High Availability, Replication - Scalability for Business
This year's Swiss PGDay will be held on June 30, 2017 at the University of Applied Sciences in Rapperswil (Switzerland).
Postgres Vision is the preeminent event for thought leadership, collaboration, and networking with the best and brightest companies defining the future of enterprise Postgres and open source data management.
5432...MeetUs! The opportunity to share your own experiences with PostgreSQL and more.
A two-day full immersion event with the opportunity to meet some of the leading experts, to hear first-hand accounts of companies who have adopted it and to interact with those who have made PostgreSQL their own personal mission. http://5432meet.us/
5432...MeetUs! L’occasione di condividere le proprie esperienze con PostgreSQL e non solo.
Una full immersion di due giorni, con l’opportunità di incontrare alcuni dei maggiori esperti, di ascoltare le testimonianze dirette di aziende che lo hanno adottato e di interagire con chi ha fatto di PostgreSQL la propria mission. http://5432meet.us/
Note: Multi-languages conference (English and Italian)
PostgreSQL exhibitor at PyCon 2017
The Percona Live Open Source Database Conference is the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software. The conferences have a technical focus with an emphasis on the core topics of MySQL, MongoDB, PostgreSQL and other open source databases, and has a single-day PostgreSQL track.
PGConf US 2017 will be held March 28-31, 2017 at the Westin, Jersey City. PGConf US 2017 focuses on how people use PostgreSQL, from the perspective of developers, DBAs, systems administrators, business-intelligence analysts, and decisions makers, and combines the open-source feel with the needs of individual and enterprises.
For more information please visit http://www.pgconf.us
Encuentro del PostgreSQL en Latino América, oportunidad para que interesados en temas afines al gestor compartan experiencias y conocimientos
pgDay Paris 2017 is the third annual one-day, one-track, English-language PostgreSQL conference, held in Paris, France. It will feature presentations about all aspects of PostgreSQL, from beginner testimonials to advanced security features and benchmarking.
Nordic PGDay 2017 is a one-day PostgreSQL conference, held in Stockholm, Sweden. It will feature presentations about all aspects of PostgreSQL, from end user to internals developers, as well as the hallway track where you get to meet and talk to both PostgreSQL experts and users.
On behalf of pgDay Asia organizing committee Ashnik announces the pgDay Asia conference to be held in Singapore on 17th and 18th March 2017.
The next Russian PostgreSQL conference will take place in Moscow Digital October Center on March 15-17, 2017 - one day of tutorials and two days of talks in three parallel sessions.
The All India PostgreSQL UserGroup announces the PGConf India conference to be held in Bengaluru on 3rd March 2017.
As always, PGConf India is an excellent opportunity to get yourself introduced to leading PostgreSQL users, developers, and to learn about features in the latest PostgreSQL release. It also provides a platform to share experiences and to network with like-minded open source database enthusiasts.
We are thrilled to announce that Simon Riggs, Chief Technology Officer at 2ndQuadrant and hacker/committer in the PostgreSQL community will be delivering the Keynote at this event!
The CFP closes on 13th Jan 2017 and the early bird registration closes on 15th Jan 2017. More details about the event can be found at http://pgconf.in/
PostgreSQL@SCaLE is a two day, two track event which takes place on March 2-3, 2017, at Pasadena Convention Center, as part of SCaLE 15X.
The JDBC group is proud to release a new version, and in keeping with the version renumbering meme we have released version 42.0.0.
Notable changes include:
A two-day conference, organized by Czech and Slovak PostgreSQL User Group. The conference will have two parts, as in the last few years - trainings on Feb 15 (either half or whole day sessions) and regular conference (with ~45-minute talks) on Feb 16.
Team pgDay Asia is happy to announce that registrations for the conference are now open. For a limited time, we are offering group discounts for 3+ people. Register yourself by clicking: http://2017.pgday.asia/#registration.
Schedule for the 2-day single-track conference has also been published: http://2017.pgday.asia/#schedule
Please note that the 2nd day of the conference is part of FOSSASIA's dedicated PostgreSQL track. Tickets for FOSSASIA can be purchased separately here: http://2017.fossasia.org/tickets/
A special shout out to all our speakers and sponsors. This event is not possible without your support. For anyone wishing to sponsor, please send an email to firstname.lastname@example.org.
pgDay Asia 2017 is scheduled to be held in Singapore on 17th & 18th of March. More details here: http://2017.pgday.asia/. The conference will be held along with FOSSASIA - one of the largest FOSS conference on the planet. pgDay Asia will be PostgreSQL conference series for all PostgreSQL enthusiasts in the Asia Pacific region.
PostgreSQL@SCaLE is an embedded PostgreSQL conference held as part of SCaLE15x on Thursday and Friday, March 2-3, 2017. We will have 24 one-hour PostgreSQL talks -- two rooms for two days. This is by far the best value for your money of any North American PostgreSQL event!For the talk schedule, please see:
SCaLE15x (the 15th annual Southern California Linux Expo), taking place on March 2-5, 2017 at the Pasadena Convention Center, is the largest community-run open-source and free software conference in North America. It is held annually in the Los Angeles area. PostgreSQL@SCaLE is always very popular and well attended. Don't miss out!
There is a nominal registration cost, but we have a 50% discount code: PSQLPlease go register here.
PostgreSQL@SCaLE15x is made possible by the United States PostgreSQL Association, a nonprofit 501(c)(3) created to support PostgreSQL in the United States through user group development, conferences, educational initiatives, and fun. There is no way we would be able to produce PostgreSQL@SCaLE15x without the generous support of our sponsors:2ndQuadrant Amazon Web Services Command Prompt OpenSCG PostgreSQL Consulting
We hope to see everyone there!
The PostgreSQL@SCaLE15x Committee Joe, Jim, and Gabrielle
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.2, 9.5.6, 9.4.11, 9.3.16, and 9.2.20. This release includes fixes that prevent data corruption issues in index builds and in certain write-ahead-log replay situations, which are detailed below. It also patches over 75 other bugs reported over the last three months.
Users should plan to apply this update at the next scheduled downtime.Build corruption with CREATE INDEX CONCURRENTLY
There existed a race condition if CREATE INDEX CONCURRENTLY was called on a column that had not been indexed before, then rows that were updated by transactions running at the same time as the CREATE INDEX CONCURRENTLY command could have been indexed incorrectly.
If you suspect this may have happened, the most reliable solution is to rebuild affected indexes after installing this update.
This issue is present in the 9.2, 9.3, 9.4, 9.5, and 9.6 series of PostgreSQL.Fixes for visibility and write-ahead-log stability
These release contains several fixes to improve the stability of visible data and WAL logging that we wish to highlight here.
Prior to this release, data could be prematurely pruned by a vacuum operation when a special snapshot used for catalog scans was presently available. Specifically, the vacuum operation would not be aware of the oldest xmin for this special snapshot. The error would surface with a message such as:"cache lookup failed for relation 1255"
This release ensures that vacuum operations will account for the catalog scan snapshots.
Additionally, there are several fixes to improved the stability of write-ahead-logging, including:* A fix for BRIN index WAL logging where a replay could make a portion of the BRIN index useless and require recomputing * A fix for an unlogged table where a WAL-log would be created under the "wal_level = minimal" setting, and upon replay after crash, the table would not appear to be properly reset * A fix in the WAL page header validation when re-reading segments that fixes the error of "out-of-sequence TLI" that could be reported during recovery
Theses issues are present in the 9.6 series of PostgreSQL releases and may also be present in the 9.2, 9.3, 9.4, and 9.5 series.Bug Fixes and Improvements
This update also fixes a number of bugs reported in the last few months. Some of these issues affect only the 9.6 series, but many affect all supported versions. There are more than 75 fixes provided in this release, including:
Update time zone data files to tzdata release 2016j for DST law changes in northern Cyprus (adding a new zone Asia/Famagusta), Russia (adding a new zone Europe/Saratov), Tonga, and Antarctica/Casey. Historical corrections for Italy, Kazakhstan, Malta, and Palestine. Switch to preferring numeric zone abbreviations for Tonga.Updating
All PostgreSQL update releases are cumulative. As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries.
If you believe you have been affected by the aforementioned CREATE INDEX CONCURRENTLY bug, you will have to rebuild the index. Here is an example of how to rebuild an index in a production system without losing the ability to utilize the index:CREATE INDEX CONCURRENTLY new_index_name ON table_name (column_name); DROP INDEX CONCURRENTLY old_index_name; ALTER INDEX new_index_name RENAME TO old_index_name;
Note that using this method means you will briefly have two copies of the same index, so if disk space is an issue you may need to take other approaches.
Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.
Yohz Software has released SQL Multi Select for PostgreSQL, an invaluable too to add to your toolkit if you manage multiple PostgreSQL servers.
SQL Multi Select runs multiple scripts on multiple servers with a single click.
Say you want to find out the 5 largest tables in each database, on each of your 20 PostgreSQL servers. All you have to do is:
Imagine how SQL Multi Select can help you do your work faster. Need to create a new user account on a set of servers? Just select the appropriate query group, write the script, and run the project. Need to create a new database on a bunch of servers? Prepare the CREATE DATABASE script, select a query group, run the script, and you’re done. The possibilities are endless.
About Yohz Software
Yohz Software is a developer of database applications for most popular database engines. Learn more about Yohz Software at http://www.yohz.com.