SPOJE.NET

Technická dokumentace

Uživatelské nástroje

Nástroje pro tento web


howto:hosting:pgsql_instalace

Rozdíly

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

Odkaz na výstup diff

Následující verze
Předchozí verze
howto:hosting:pgsql_instalace [2015/06/22 16:43] – upraveno mimo DokuWiki 127.0.0.1howto:hosting:pgsql_instalace [2019/12/06 12:24] (aktuální) – [Upgrade] gandalf
Řádek 16: Řádek 16:
   * ''%%pg_dumpall -f jmeno_souboru.sql%%'' - provede dump celeho clusteru, tj. vsech databazi vcetne roli a schemat    * ''%%pg_dumpall -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 -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>
  
howto/hosting/pgsql_instalace.1434984188.txt.gz · Poslední úprava: 2015/06/22 16:43 autor: 127.0.0.1