Rozdíly

Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.

--- howto:hosting:pgsql_instalace [2015/06/22 16:43] – upraveno mimo DokuWiki 127.0.0.1
+++ howto:hosting:pgsql_instalace [2024/10/03 19:31] (aktuální) – [Zalohovani] gandalf
@@ Řádek 14: / Řádek 14: @@
 Spousteno cronem pod uzivatelem postgres
-  * ''%%pg_dumpall -f jmeno_souboru.sql%%'' - provede dump celeho clusteru, tj. vsech databazi vcetne roli a schemat
+  * ''%%pg_dumpall -c -f jmeno_souboru.sql%%'' - provede dump celeho clusteru, tj. vsech databazi vcetne roli a schemat
-  * ''%%pg_dump davical -f jmeno_souboru.sql%%'' - provede dump pouze obsahu zvolene databaze
+  * ''%%pg_dump davical -c -f jmeno_souboru.sql%%'' - provede dump pouze obsahu zvolene databaze
+==== Upgrade ====
+Popisujeme upgrade z verze 9.1 na 9.4
+<code>
+su postgres
+pg_dropcluster --stop 9.4 main  #zatavime defaultne nainstalovany cluster
+pg_upgradecluster -v 9.4 9.1 main   #pg_upgradecluster -v NEW OLD 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
+psql (9.4.24)
+Type "help" for help.
+</code>