https://www.auul.pri.ee/wiki/index.php?action=history&feed=atom&title=PostgreSQL 2026-05-03T15:50:37Z Selle lehekülje redigeerimiste ajalugu MediaWiki 1.39.13 https://www.auul.pri.ee/wiki/index.php?title=PostgreSQL&diff=532&oldid=prev 2023-02-18T13:50:14Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="et"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←Vanem redaktsioon</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Redaktsioon: 18. veebruar 2023, kell 16:50</td> </tr><tr> <td colspan="2" class="diff-lineno">60. rida:</td> <td colspan="2" class="diff-lineno">60. rida:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:pg_statsinfo]]</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:pg_statsinfo]]</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:PGObserver]]</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:PGObserver]]</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* [[:pgwatch2]]</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Kasulikud lisamaterjalid===</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Kasulikud lisamaterjalid===</div></td> </tr> <!-- diff cache key db_ika-s_ika-:diff:wikidiff2:1.12:old-33:rev-532:1.11.0 --> </table>

Imre https://www.auul.pri.ee/wiki/index.php?title=PostgreSQL&diff=33&oldid=prev 2021-08-08T19:54:22Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="et"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←Vanem redaktsioon</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Redaktsioon: 8. august 2021, kell 22:54</td> </tr><tr> <td colspan="2" class="diff-lineno">37. rida:</td> <td colspan="2" class="diff-lineno">37. rida:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:PostgreSQL Logical Replication]]</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:PostgreSQL Logical Replication]]</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:Pglogical]]</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [[:Pglogical]]</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* [[:Voogamine]]</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Klasterdamine===</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Klasterdamine===</div></td> </tr> <!-- diff cache key db_ika-s_ika-:diff:wikidiff2:1.12:old-32:rev-33:1.11.0 --> </table>

Imre https://www.auul.pri.ee/wiki/index.php?title=PostgreSQL&diff=32&oldid=prev 2021-08-08T19:53:33Z

<p>Uus lehekülg: &#039;Järgnevad tekstid kirjeldavad PostgreSQL andmebaasi paigaldamist, haldamist ja kasutamist. ===Kasutamine=== * <a href="/wiki/PostgreSQL_SQL" title="PostgreSQL SQL">PostgreSQL SQL</a> * <a href="/wiki/PostgreSQL_haldamine" title="PostgreSQL haldamine">PostgreSQL haldamine</a> * :PostgreSQL m...&#039;</p> <p><b>Uus lehekülg</b></p><div>Järgnevad tekstid kirjeldavad PostgreSQL andmebaasi paigaldamist, haldamist ja kasutamist.<br /> <br /> ===Kasutamine===<br /> <br /> * [[:PostgreSQL SQL]]<br /> * [[:PostgreSQL haldamine]]<br /> * [[:PostgreSQL monitooring]]<br /> * [[:PostgreSQL monitooring pg_monz]]<br /> * [[:PostgreSQL koormustestimine]]<br /> <br /> ===Paigaldamine erinevatele operatsioonisüsteemidele===<br /> <br /> * [[:Lähtetekstist kompileeritud PostgreSQL kasutamine Debianiga]]<br /> * [[:PostgreSQL andmebaasi haldamine operatsioonisüsteem Debian keskkonnas]]<br /> * [[:PostgreSQL tarkvara kasutamine Solarisega]]<br /> * [[:EnterpriseDB kasutamine operatsioonisüsteemiga Ubuntu 12.04]]<br /> <br /> ===Haldust ja kasutamist hõlbustav tarkvara===<br /> <br /> * [[:Andmebaasi haldus-ja arendustarkvara SQL Studio for PostgreSQL]]<br /> * [[:PgAdmin3]] PostgreSQL andmebaasi arendus ja haldusvahend<br /> * [[:PgAdmin4 kasutamine operatsioonisüsteemiga Debian]] PostgreSQL andmebaasi arendus ja haldusvahend<br /> * [[:WalMgr kasutamine]]<br /> * [[:PgBouncer kasutamine operatsioonisüsteemiga Debian]] Andmebaasi ühenduste fondeerija.<br /> * [[:Londiste v. 2]] Asünkroonne master/slave-tüüpi andmete replitseerimislahendus<br /> * [[:Londiste v. 3]] Asünkroonne master/slave-tüüpi andmete replitseerimislahendus<br /> * [[:PostGIS]] Geograafilised objektide kirjeldamine<br /> * [[:Raamistik]] Veel toores tekst<br /> * [[:Streaming replication kasutamine PostgreSQL v. 9.x tarkvaraga]]<br /> * [[:pgAgent]]<br /> * [[:phpPgAdmin]]<br /> * [[:Postgres-XC]]<br /> * [[:pg_partman]]<br /> * [[:Ora2Pg]]<br /> * [[:Postgres-BDR]]<br /> * [[:pg_rewind]]<br /> * [[:PostgreSQL Logical Replication]]<br /> * [[:Pglogical]]<br /> <br /> ===Klasterdamine===<br /> <br /> * [[:repmgr üldiselt]]<br /> * [[:repmgr käsijuhtimisel kasutamine]]<br /> * [[:repmgrd automaatjuhtimisel kasutamine]]<br /> <br /> ===patroni===<br /> <br /> [[:patroni kasutamine]]<br /> <br /> ===Varundamine===<br /> <br /> * [[:pgbarman kasutamine]]<br /> * [[:pgbackrest kasutamine]]<br /> <br /> ===Statistika===<br /> <br /> * [[:PostgreSQL statistikast üldiselt]]<br /> * [[:PostgreStats]]<br /> * [[:pg_statsinfo]]<br /> * [[:PGObserver]]<br /> <br /> ===Kasulikud lisamaterjalid===<br /> <br /> * http://www.postgresonline.com/<br /> * http://www.postgresql.org/developer/coding<br /> * http://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations<br /> * http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling<br /> * http://petereisentraut.blogspot.com/<br /> * http://www.endpoint.com/services/postgresql<br /> * http://villemain.org/</div>

Imre