planet.postgresql.org planet.postgresql.org

Luca Ferrari: PostgreSQL 13 Explain now includes WAL information

The upcoming version of PostgreSQL now includes new information in the EXPLAIN output. PostgreSQL 13 Explain now includes WAL information The upcoming PostgreSQL 13 includes a lot of new features, as a very consolidated habit in every release. One interesting feature among the others is that EXPLAIN now supports a new WAL option (that requires ANALYZE to be set). This new WAL feature allows EXPLAIN to provide information about the...

planet.postgresql.org planet.postgresql.org

Bruce Momjian: Force Password Changes

I have written about the limitations of passwords before. Postgres has limited ability to control passwords — mostly how passwords are transferred and how long passwords remain valid. For more complex password requirements, the Postgres project recommends using an external authentication system that manages passwords like LDAP or GSSAPI. Cert authentication has many advantages because it does not require a password. Last year, one...

planet.postgresql.org planet.postgresql.org

Magnus Hagander: PGConf.EU 2020 - Conference canceled

fter a long discussion, we have made the painful decision to cancel PostgreSQL Conference Europe 2020. During the past weeks attendees, speakers, sponsors and volunteers have contacted us and asked if the conference will take place, expressing their concerns regarding the ongoing COVID-19 situation. For some countries it is clear that no one can travel to Berlin in October, for others it might be possible but it is not certain at this...