Digest news from the world of PostgreSQL. Issue number 2

Releases and commits

• Cybertec has announced the release of pgconfigurator , a visual configurator for editing the postgresql.conf file. You can customize:
  • replication options;
  • parameters associated with control points;
  • input / output, optimize parallel queries;
  • configure memory.
• Devart offers dbForge Studio for PostgreSQL - a graphical environment for working with databases and PostgreSQL objects.
• JDBC 42.2.0 released
  New:
  • SCRAM-SHA-256 support for PostgreSQL 10 in JDBC version 4.2 (Java 8+),
  • Ongres SCRAM library is used;
  • Make SELECT INTO and CREATE TABLE AS now returns the number of rows to the client.
  • Subject Alternative Names support for SSL connections
  • isAutoIncrement support in metadata for identification columns in PostgreSQL 10;
  • support of primitive arrays;
  • support for get / setNetworkTimeout () in connections;
  • in Make GSS JAAS, login is now optional; jaasLogin option added
• 2ndQuadrant announced the release of pglogical 2.1.1 - a minor release to the logical replication module 2.1 in PostgreSQL. Fixed errors of the previous version and added information when writing logs.
• PgCodeKeeper 4.2.0 released . pgCodeKeeper is a tool for generating migration scripts. Now it supports PostgreSQL 10.
• Michel Paquier writes that the patch adopted by Alvaro Herrera , which will be included in version 11. Now, if you create an index on a partitioned table, an index will be created on all sections, including future ones.
• The patch of Robert Haas to version 11 was adopted . Now when UPDATE in a partitioned table, the modified row may fall into another section (in the free pg_pathman module, a trigger was launched for this).

Developments

Future

• FOSDEM PGDay 2018 Conference will be held February 2 in Brussels. The conference program is here .
• PGConf.Russia 2018
  
  It will be held on February 5-7 in Moscow at the Faculty of Economics of Moscow State University. The conference program has already been formed, registration continues .
• Open lectures by Bruce Momgian
  February 7th. A master class at the PGConf.Russia 2018 conference “Studying common table expressions and window functions” and the report “Protecting PostgreSQL against external attacks”.
  February 8th. Rostov-on-Don, open lecture.
  February 10th. Open lecture at the Ural Federal University.
  12th of February. Novosibirsk Speech at 2GIS office
• PGConf APAC 2018
  The Asia-Pacific Post-aggressors Conference will be held in Singapore from March 22-23. The program includes reports by Oleg Bartunov, Anton Bykov, Alexander Kukushkin and others.
• PostgresConf US 2018 has finished accepting applications. It will be held in Jersey City on April 16-20.

Past

• #RuPostgres Live Mitap 5. Bruce Momjian is a 2-hour live meeting on the Bruce Momgian network with the post-community.
• Mitap #RuPostgres Live 6. Maxim Boguk , DataEgret

Articles

• Azure CLI and Postgres
  Continuing the PostgreSQL theme in the Azure DaaS cloud. Now about reading logs and others. DBA-concerns. By the way, below in the Blogs section there is a note about PostgreSQL in the Amazon cloud.
• Migrating MySQL to PostgreSQL with minimal downtime
  An article on the PG DBA website about the pg_chameleon utility.
• Why PostgreSQL is in demand today
  Matt Esay article from the American InfoWorld . Her translation was published by Russian Computerworld . NoSQL fatigue, horizontal scalability, Citus, and even hipsters.
• And so it will do ... or how the data of 14 million Russians were in my hands
  Chronicle of hacking (for instructive purposes, as the author claims) of the Rosobrnadzor database. The database is based on PostgreSQL, but this is not about database vulnerabilities, but about the disorder of developers / managers. SQL injections were used .
• PostgreSQL Indexes - 9
  Egor Rogov continues to talk about indexes . This time - BRIN .

Blogs

• Using plantuner for debugging indexes in PostgreSQL
  In his LJ blog, Oleg Bartunov tells how to use the plantuner module to prompt the optimizer which index to use, and hide the rest from it.
• AWS Aurora Postgres, not a great first impression
  In the eVOL Monkey blog, they share their experience with cloud AWS Aurora PostgreSQL, which is not very encouraging.
• PostgreSQL Meltdown
  On a fashionable topic, Simon Rigs (2ndQuadrant) argues on his blog.
• DBMS of the Year 2017 - this title won PostgreSQL by DBEngines ratings.
• Set up a connection pool for PostgreSQL with PgBouncer
  Alexander Alekseev's tutorial
• Physical recovery with pg_filedump Alexander Chernyshev explains in his blog how to work with pg_filedump

Books

• A Curious Moon. Learn PostgreSQL on the Job at Red: 4
  An unusual book became available for purchase in electronic form (there is no information about the paper version). The basics of PostgreSQL are laid out in a sci-fi narrative genre. The heroine is studying PostgreSQL - she has to become a DBA in Red: 4 startup , who has equipped the NASA ship to the satellite (moon) of Saturn. Book-aid Curious moon. As I learned PostgreSQL, working in Red: 4 costs $ 19.
• Migrating to PostgreSQL, Tools and Methodology White paper of the book Dm. Fontaine , who decided to summarize his migration experience to PostgreSQL