zosintha za nthambi zonse za PostgreSQL zothandizidwa: , , , , ΠΈ . Kutulutsidwa 9.4.26 ndikomaliza - kukonzekera zosintha za nthambi 9.4 . Zosintha za nthambi 9.5 zidzapangidwa mpaka February 2021, 9.6 - mpaka November 2021, 10 - mpaka November 2022, 11 - mpaka November 2023, 12 - mpaka November 2024.
Mabaibulo atsopano amakonza nsikidzi 75 ndikuchotsa chiwopsezo
(CVE-2020-1720) chifukwa cha cheke chololeza chosowa pochita lamulo la "ALTER ... ZIMADALIRA PA EXTENSION". Nthawi zina, chiwopsezochi chimalola wogwiritsa ntchito wopanda mwayi kuchotsa ntchito iliyonse, njira, mawonekedwe owoneka bwino, index, kapena choyambitsa. Kuwukira ndi kotheka ngati woyang'anira ayika chowonjezera chilichonse, ndipo wogwiritsa ntchito atha kuyika lamulo la CREATE kapena mwini wake wowonjezerayo atha kutsimikiza kuti apereke lamulo la DROP EXTENSION.
Kuphatikiza apo, mutha kuwona mawonekedwe a pulogalamu yatsopano , zomwe zimakulolani kubwereza deta pakati pa ma seva angapo a PostgreSQL. Pulogalamuyi imathandizira kubwereza koyenera kudzera pawayilesi ndi kusewera pagulu lina la malamulo a SQL omwe amaperekedwa pa seva yayikulu, zomwe zimapangitsa kusintha kwa data. Khodiyo imalembedwa mu Go ndi zololedwa pansi pa Apache 2.0. Kusiyanitsa kwakukulu kuchokera kumakina omangika momveka bwino:
- Thandizo pamitundu iliyonse yamatebulo omwe mukufuna (mawonedwe, fdw (Foreign Data Wrapper), matebulo ogawidwa, ma tebulo a citus);
- Kutha kutanthauziranso mayina a tebulo (kubwereza kuchokera patebulo limodzi kupita ku lina);
- Kuthandizira kubwerezabwereza kobwerezabwereza potumiza zosintha zakumaloko ndikunyalanyaza kubwereza kochokera kunja;
- Kupezeka kwa njira yothetsera mikangano yotengera LWW (womaliza-wolemba-wopambana) algorithm;
- Kutha kusunga zidziwitso za momwe kubwereza kubwereza ndi zolemba zomwe sizinagwiritsidwe ntchito patebulo lapadera, lomwe lingagwiritsidwe ntchito kuchira pambuyo poti nodi yolandirira kwakanthawi yabwezeretsedwa.
Source: opennet.ru