opendbteam workspace

opendbteam workspace
opendbteam workspace

Thursday, March 31, 2016

#PostgreSQL9.5 : #New #Security #Release

A new security release is available for PostgreSQL 9.5.
It fixes two potential security issues and one index corruption issue. The index feature might be re enabled in future releases if found to be working properly.

"Security Fixes for RLS, BRIN

This release closes security hole CVE-2016-2193, where a query plan might get reused for more than one ROLE in the same session. This could cause the wrong set of Row Level Security (RLS) policies to be used for the query.

The update also fixes CVE-2016-3065, a server crash bug triggered by using pageinspect with BRIN index pages. Since an attacker might be able to expose a few bytes of server memory, this crash is being treated as a security issue.

Abbreviated Keys and Corrupt Indexes

In this release, the PostgreSQL Project has been forced to disable 9.5's Abbreviated Keys performance feature for many indexes due to reports of index corruption. This may affect any B-tree indexes on TEXT, VARCHAR, and CHAR columns which are not in "C" locale. Indexes in other locales will lose the performance benefits of the feature, and should be REINDEXed in case of existing index corruption"

The complete release overview can be found at: http://www.postgresql.org/about/news/1656/

#postgresql #pgBadger released - Sortie de pgBadger 8 - http://goo.gl/jl1Gy5

pgBadger is a PostgreSQL log analyzer built for speed with fully reports from your PostgreSQL log file. It's a single and small Perl script Perl script that outperforms any other PostgreSQL log analyzer. It is written in pure Perl and uses a javascript library (flotr2) to draw graphs so that you don't need to install any additional Perl modules or other packages. Furthermore, this library gives us more features such as zooming. pgBadger also uses the Bootstrap javascript library and the FontAwesome webfont for better design. Everything is embedded. This is a major release that adds support to pgbouncer log files.

New pgbouncer reports are:

  • Request Throughput
  • Bytes I/O Throughput
  • Queries Average duration
  • Simultaneous sessions
  • Histogram of sessions times
  • Sessions per database
  • Sessions per user
  • Sessions per host
  • Established connections
  • Connections per database
  • Connections per user
  • Connections per host
  • Most used reserved pools
  • Most Frequent Errors/Events

Tuesday, March 22, 2016

We stand united with the #BrusselsBombing victims

We stand united with the city that harbours our headquarters, the victims of the attacks that took place today, their friends and family, as well as with all of the Brussels population.

Friday, March 18, 2016

#OpenSource Days #Copenhagen 2016 #mariadb

Highlights from the event:
Meet MySQL founder Michael "Monty" Widenius from MariaDB Foundation, OpenPOWER Alliance Manager Mandie Quartly
and other speakers/guests at the Open Source Days event in Copenhagen 2016.
https://opensourcedays.org
http://openpowerfoundation.org
http://www.ibm.com/linux
http://www.opendbteam.com

IBM is driving reforms for IP, Open Source & Standards
IBM is an industry leader helping governments move toward greater openness and innovation. Our commitment and perspective on intellectual property, open standards, and open source software emerges from our experience in the marketplace and, equally important, from the direction in which we see information technology taking the larger society.

Thursday, March 17, 2016

#postgresql #Barman 1.6.0 is out!


The main feature of the new release is Streaming Connection & WAL Streaming.  If you are already using Barman, just update it to start using the new features. And, if you don’t yet use it, now is the time you can begin elaborating your disaster recovery plan.
Read Rubens blog to find out more

Wednesday, March 16, 2016

Discover our brand new #postgresql training sessions @brussels: http://ow.ly/ZvAhX

Presentation

OpenDB Team training sessions take place (on a set date) either with various participants from different companies at our venues (Brussels) or onsite intra-company training (company’s venue). Onsite training sessions are specifically tailored to the participants’ profile as well as their professional environment.

The training reflects our commitment to three teaching principles :
  • Our training sessions are given by experts active in the field, who are part of the Open source community (through developments, documentation, translations, press releases and articles). Our trainers are known for their contributions and interventions at international conferences.
  • Our teaching material is continuously updated as to ensure our participants have the most useful skills at their disposal, as well as the most effective tools, and are familiar with the most recent technical know-how.
  • By the end of the training sessions, each participant receives unlimited access to our knowledge base. He or she can then add to their newly acquired knowledge, continue the learning process and download the teaching material in PDF format.

Thursday, March 10, 2016

#New #PostgreSQL #WALsize in #9.5

All that you have ever wanted to know about the new wal options in PostgreSQL 9.5.
The new parameters allow for sizing of your wals based on database activity type and more generally better fine-tune your database.



Find out more here: http://www.databasesoup.com/2016/01/configuration-changes-in-95-transaction.html

#EDB PPAS 9.5 / #PostgreSQL 9.5 event @icab

Introducing the ‘Transform your Database Tour’
Open source is the new Data Center standard
Are you facing the challenge to meet growing IT requirements while operating on a limited budget? Learn more about why you should transform your database management system (DBMS) and make open source part of your strategic business and IT choices at the ‘Transform your Database Tour’ on April 20 in Brussels.
An open source DBMS offers you various benefits, including cost reduction, liberation from vendor lock-in, and a large development community. Paired with enterprise-class services, 24x7 support and reliable management tools, open source is a viable alternative to traditional proprietary DBMSs.
Opendb Team has 8 years of experience in the open source database market and will explain why an open source database should be part of your business and IT strategy. One of its customers will then discuss their DBMS transformation.
After these interactive presentations, you can share your own experience, and discuss the challenges your organization may face with the implementation of a new DMBS strategy. At the end of the day you will leave with considerable new knowledge about open source databases, and new insights about the opportunities to apply this knowledge in your own IT environment.