Uživatelské nástroje
howto:hosting:pgsql_instalace
no way to compare when less than two revisions
Rozdíly
Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.
| Předchozí verzePoslední revize | |||
| — | howto:hosting:pgsql_instalace [2019/12/06 12:22] – gandalf | ||
|---|---|---|---|
| Řádek 1: | Řádek 1: | ||
| + | ====== PostgreSQL (Instalace, konfigurace) ====== | ||
| + | |||
| + | https:// | ||
| + | |||
| + | ===== Prikazy ===== | ||
| + | * Vstup do konzole (na Debianu?) | ||
| + | * '' | ||
| + | * '' | ||
| + | * Vytvoreni spravcovskeho uctu | ||
| + | * '' | ||
| + | |||
| + | ===== Zalohovani ===== | ||
| + | |||
| + | Spousteno cronem pod uzivatelem postgres | ||
| + | |||
| + | * '' | ||
| + | * '' | ||
| + | |||
| + | |||
| + | ==== Upgrade ==== | ||
| + | |||
| + | Popisujeme upgrade z verze 9.1 na 9.4 | ||
| + | < | ||
| + | su postgres | ||
| + | pg_dropcluster --stop 9.4 main #zatavime defaultne nainstalovany cluster | ||
| + | pg_upgradecluster -v 9.4 9.1 main # | ||
| + | ... | ||
| + | Fixing hardcoded library paths for stored procedures... | ||
| + | Upgrading database czfmapa... | ||
| + | Analyzing database czfmapa... | ||
| + | Fixing hardcoded library paths for stored procedures... | ||
| + | Upgrading database template1... | ||
| + | Analyzing database template1... | ||
| + | Fixing hardcoded library paths for stored procedures... | ||
| + | Upgrading database hosts... | ||
| + | Analyzing database hosts... | ||
| + | Fixing hardcoded library paths for stored procedures... | ||
| + | Upgrading database nagios... | ||
| + | Analyzing database nagios... | ||
| + | Fixing hardcoded library paths for stored procedures... | ||
| + | Upgrading database postgres... | ||
| + | Analyzing database postgres... | ||
| + | Fixing hardcoded library paths for stored procedures... | ||
| + | Upgrading database davical... | ||
| + | Analyzing database davical... | ||
| + | Re-enabling connections to the old cluster... | ||
| + | Re-enabling connections to the new cluster... | ||
| + | Copying old configuration files... | ||
| + | Copying old start.conf... | ||
| + | Copying old pg_ctl.conf... | ||
| + | Copying old server.crt... | ||
| + | Copying old server.key... | ||
| + | Stopping target cluster... | ||
| + | Stopping old cluster... | ||
| + | Disabling automatic startup of old cluster... | ||
| + | Configuring old cluster to use a different port (5433)... | ||
| + | Starting target cluster on the original port... | ||
| + | Success. Please check that the upgraded cluster works. If it does, | ||
| + | you can remove the old cluster with | ||
| + | |||
| + | postgres@dev: | ||
| + | psql (9.4.24) | ||
| + | Type " | ||
| + | |||
| + | </ | ||
howto/hosting/pgsql_instalace.txt · Poslední úprava: 2019/12/06 12:24 autor: gandalf
Kromě míst, kde je explicitně uvedeno jinak, je obsah této wiki licencován pod následující licencí: CC Attribution-Share Alike 4.0 International
