Sabuntawar PostgreSQL tare da gyara rauni. Sakin tsarin kwafi pgcat

An kafa sabuntawar gyara ga duk rassan PostgreSQL masu tallafi: 12.2, 11.7, 10.12, 9.6.17, 9.5.21 и 9.4.26. Sakin 9.4.26 shine ƙarshe - shirya sabuntawa don reshe 9.4 daina. Za a samar da sabuntawa don reshe 9.5 har zuwa Fabrairu 2021, 9.6 - har zuwa Nuwamba 2021, 10 - har zuwa Nuwamba 2022, 11 - har zuwa Nuwamba 2023, 12 - har zuwa Nuwamba 2024.

Sabbin nau'ikan suna gyara kwari 75 kuma suna kawar da rauni
(CVE-2020-1720) wanda ya ɓace ta rajistan izini lokacin aiwatar da umarnin "CANZA ... DEPENDES A EXTENSION". Ƙarƙashin wasu yanayi, rashin lafiyar yana bawa mai amfani mara gata damar share kowane aiki, tsari, gani na zahiri, fihirisa, ko faɗakarwa. Za a iya kai hari idan mai gudanarwa ya shigar da kowane tsawo, kuma mai amfani zai iya aiwatar da umarnin CREATE ko kuma mai shi zai iya gamsuwa da aiwatar da umarnin DROP EXTENSION.

Bugu da ƙari, zaku iya lura da bayyanar sabon aikace-aikacen pgcat, wanda ke ba ku damar kwafin bayanai tsakanin sabar PostgreSQL da yawa. Shirin yana goyan bayan maimaita ma'ana ta hanyar watsa shirye-shirye da sake kunnawa akan wani rukunin rafi na umarnin SQL da aka aiwatar akan babban uwar garken, yana haifar da canje-canjen bayanai. An rubuta lambar a cikin harshen Go da rarraba ta lasisi a ƙarƙashin Apache 2.0. Babban bambance-bambance daga ginanniyar hanyar kwafi na hankali:

  • Taimako ga kowane nau'in tebur da aka yi niyya (ra'ayoyi, fdw (Wrapper Data Wrapper), Tables da aka raba, teburin citus da aka rarraba);
  • Ikon sake fasalin sunayen tebur (kwafi daga wannan tebur zuwa wani);
  • Taimako don kwafi bidirectional ta hanyar watsa canje-canje na gida kawai da watsi da kwafi masu zuwa daga waje;
  • Samar da tsarin warware rikici bisa ga LWW (marubuci-nasara-nasara) algorithm;
  • Ikon adana bayanai game da ci gaban kwafi da kwafi marasa amfani a cikin wani tebur daban, wanda za'a iya amfani dashi don murmurewa bayan an dawo da kumburin da ba ya samuwa na ɗan lokaci.

source: budenet.ru

Add a comment