Digest news from the world of PostgreSQL. Issue number 8

We continue to introduce you to the most interesting news on PostgreSQL.

Elephants

Simon Riggs , head of the 2ndQuadrant, encourages companies to participate in the protection of elephants , including reporting cases of online ivory trading.

Releases

PostgreSQL 11 Beta 2 Released
The release of this release is also related to the detected problem with SCRAM. In Beta 1, a major feature of Channel Binding for SCRAM Authentication (channel binding) appeared to prevent man-in-the-middle attacks. But when testing, it turned out that libpq is not able to guarantee channel binding. In Beta 2, the feature itself was not removed, but the documentation for it was deleted, and the feature lost its major status. For more information about the release, you can read here , and you can download Beta 2 here .

PgAdmin 4 version 3.1 released . It fixes more than 30 bugs. Among the new features:

• Added support for SSH tunnels,
• LISTEN / NOTIFY support in the Query Tool,
• PostgreSQL 11 support for functions and procedures.
• Improved support for Greenplum

Details can be found here .

Download packages for Windows, macOS, Python Wheel, Docker Container or source code in the form of tarball here . Promised that RPM and DEB will be available in a few days.

Richardson Software released RazorSQL 8 SQL Editor and Database Query Tool
Rezor supports work with more than 40 DBMS. In version 8, there is support for converting from Firebird to 9 DBMS, including PostgreSQL. Download (for $ 99.95) here.

Pgquarrel 0.4.0 released
The author, Euler Taveria (Euler Taveira) writes that this release also includes support for sectioning, extended statistics.

Developments

Oleg Bartunov was granted the status of a foreign member of the International Advisory Committee of the PostgreSQL Association of the People's Republic of China. This happened during a trip to the Open Source World Summit in Beijing.

Education

PostgreSQL vs SQL Standard
The most useful page that makes PostgreSQL differ from the SQL standard in the PostgreSQL-wiki has appeared.

New training course: DBA3 "Administration of PostgreSQL 10. Backup and Replication . "
This two-day course is available for ordering at authorized training centers. From July 2 to July 5, P.Luzanov and E.Rogov gave a course DEV1 in the city of Kirov (Vyatka). And they also held a seminar on July 6 with VyatSU staff on using PostgreSQL in university curricula.

Slides of the course "Technology and development of a DBMS" are published
This is a course with an emphasis on implementation in PostgreSQL. Postgres Professional employees Anastasia Lubennikova and Alexander Alekseev read it at the Higher School of Economics and VMK MSU.

Articles

Will Postgres live forever?
Bruce Momdzhan performed in an unusual role - postgres-philosopher. Will postgres live forever? let's not spoil: the presentation at the Postgres Vision conference is not that long.

Postgres-BDR 3.0 with OmniDB
2ndQuadrant describes the BDR 3.0 setting in the OmniDB 2.8 version, which supports it. A cluster of 2 nodes is installed in 2 virtual machines. With details and screenshots.

Upgrade your partitioning from inheritance to declarative
This article describes the transition to declarative partitioning in the spirit of PostgreSQL 10-11 from partitioning directly on inheritance, as it was in 9.6 and earlier. Ashutosh Bapat from EnterpriseDB, one of the key developers of declarative partitioning, describes the transition to new partitioning, breaking the process into as many as 9 steps.

Postgres 11 highlight - New System Roles
In his blog, Michel Paquier explains the nuances of working with new roles:

• pg_execute_server_program,
• pg_read_server_files,
• pg_write_server_files.

Including relevant to work with FDW.

New in QGIS 3.2 Save Project to PostgreSQL
Here it is argued that the most important innovation of this version of QGIS is the ability to save QGIS projects in PostgreSQL. Prior to this, it was necessary to save in files, which is inconvenient in cases of complex network topologies with multiple users.

PostgreSQL Tuning: Key Things to Drive Performance
Severalnines blog article . Viorel Tabara offered something like a memo for a DBA.

Tuning Input / Output (I / O) Operations for PostgreSQL
Almost parallel to him, a colleague from Severalnine, Venkata Nagothi, writes in more detail about the factors affecting I / O performance. This, of course, is about vacuum, sections, indices, work in the clouds, etc. There are many well-known tips, but there are not all obvious ones. Many examples.

Options for scaling from 1 to 100,000 tenants
About a hypothetical case with a B2B application on the SaaS model operating in the AWS environment, writes Craig Kerstiens, who heads the cloud direction of Citus Data. As a result, it is proposed (surprise!) To use Citus to scale from 1 user to 100 thousand. Nevertheless, both application-level sharding and NoSQL are briefly considered.

Scaling IoT Time Series Data with Postgres-BDR
The title of this article is slightly disorienting: it does not come to parsing work with BDR - apparently, it is expected in the next series. And here are just examples of partitioning into sections BY RANGE, which can also be useful.

Conferences

PGDay.Amsterdam
The conference will take place on July 12th.

PGConf.Brazil 2018
Should be held in Brazilian São Paulo on August 3-4.

PostgresOpen Silicon Valley 2018
This conference, organized by the community, is scheduled for September 5-7 in San Francisco and this year is merged with PGConf Silicon Valley.

PostgresConf South Africa 2018
To be held in Johannesburg on October 9th.

Postgresql Conference Europe
The 10th Anniversary Conference will be held October 23-26 in Lisbon.

PGconf.ASIA 2018
It will be December 10-12 in Tokyo.

Subscribe to the postgresso channel!

Send your ideas and wishes to email: news_channel@postgrespro.ru
Previous issues: # 7 , # 6 , # 5 , # 4 , # 3 , # 2 , # 1