Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.
Následující verze | Předchozí verze | ||
howto:hosting:pgsql_instalace [2015/06/22 16:43] – upraveno mimo DokuWiki 127.0.0.1 | howto:hosting:pgsql_instalace [2019/12/06 12:24] (aktuální) – [Upgrade] gandalf | ||
---|---|---|---|
Řádek 16: | Řádek 16: | ||
* '' | * '' | ||
* '' | * '' | ||
+ | |||
+ | |||
+ | ==== 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 pg_dropcluster 9.1 main | ||
+ | |||
+ | postgres@dev: | ||
+ | psql (9.4.24) | ||
+ | Type " | ||
+ | |||
+ | </ | ||