Postgres Professional yakazivisa kuwanikwa kweiyo proprietary Pro Enterprise 15.1.1 DBMS, zvichibva paPostgreSQL 15 code base uye kusanganisira zvinhu zvitsva zvakatamiswa kuti zvibatanidzwe mumapazi anotevera ePostgreSQL, pamwe nehuwandu hwekuwedzera kwepamusoro-. load systems. Iyo DBMS inotsigira akawanda-master kudzokorodza, block-level data compression, incremental backups, yakavakirwa-mukati yekubatanidza pooler, yakagadziridzwa tafura yekugovera, yakagadziridzwa yakazara-manyoro kutsvaga, otomatiki kuunganidza mibvunzo uye kuronga.
Zvitsva zvikuru:
- Tsigiro yeOracle-style mapakeji (Packages, seti yemabasa uye maitiro) kurerutsa kutama kwePL/SQL kodhi kana uchitama kubva kuOracle kuenda kuPostgres. Kubva pakuona kwehunyanzvi, rutsigiro rwepakeji ndeyekuwedzera kweiyo PL / pgSQL mutauro syntax (ine madiki ekuwedzera kune iyo DBMS musimboti), nekuda kweiyo inoshanda analogue yeOracle mapakeji inoshandiswa uye yakati wandei mirairo inounzwa kushanda. navo.
- Kupfuudza ma parameters kune script mu psql, iyo inokutendera iwe kuti ugadzire anochinjika uye akasiyana-siyana shell zvinyorwa zvekushanda neDBMS. Pamusoro pezvakanakira zviri pachena paunenge uchigadzira zvinyorwa zvitsva, izvi zvinorerutsa kuchinjika kweSQL zvinyorwa kana uchitama kubva kuOracle DBMS, uko kushanda kwakadaro kunozivikanwa nemushandisi.
- Iyo pgpro_anonymizer yekuwedzera yedata masking (obfuscation), iyo inokutendera iwe kuti uve nechokwadi chekuchengetedza data mubhizinesi-level masisitimu, pamwe nekugadzira makopi asingazivikanwe edhatabhesi kuti ashandiswe mukuyedza nekusimudzira nharaunda.
- Zvichienderana nepg_probackup, chishandiso chitsva chekuchengetedza nharaunda pg_probackup Enterprise yakagadziridzwa, iyo inoshandisa: itsva I / O subsystem inovandudza mashandiro; tsigiro yeS3 protocol yekuchengetedza data mumafu masystem; kugarisana kweCFS (data compression) ine mashandiro ekugadzira ma backups ekuwedzera; Tsigiro yeese backup modes (DELTA, PEJI uye PTRACK); rutsigiro rweLZ4 uye ZSTD compression algorithms.
- Itsva JSON yekugadzirisa mabasa kubva kuSQL:2016 chiyero mukuwedzera kune yakamboitwa JSONPATH mutauro.
- Yakagadzirira kushanda neTimescaleDB yekuwedzera (mushure mekuzivisa zviri pamutemo nemugadziri wayo nezve PostgreSQL 15 rutsigiro).
- Kuwedzera tds_fdw module kuti kurerutsa kutama kubva kuMS SQL Server.
- Tsigiro yepamutemo yeElbrus processors.
Source: opennet.ru