|
51 | 51 | <para>To upgrade from a <productname>Postgres Pro</productname> version based on |
52 | 52 | any previous <productname>PostgreSQL</productname> major release, you can perform a dump/restore using |
53 | 53 | <xref linkend="app-pg-dumpall">, or use the <xref linkend="pgupgrade"> utility. |
54 | | - The first option is safer, while the second is faster and can |
| 54 | + The first option is safer, while the second is faster and can significantly |
55 | 55 | speed up the upgrade process for large databases. |
56 | 56 | </para> |
57 | 57 | <para>To upgrade from a <productname>Postgres Pro</productname> version |
58 | 58 | based on the same <productname>PostgreSQL</productname> major release, |
59 | | - the <literal>pgpro_upgrade</literal> script provided |
60 | | -in this distribution is required: |
61 | | -<itemizedlist> |
62 | | - <listitem> |
63 | | - <para>If you are upgrading your <productname>Postgres Pro</productname> |
64 | | -installation from a binary package, the <literal>pgpro_upgrade</literal> script |
65 | | -is run automatically, or you are prompted to run it manually. |
66 | | - </para> |
67 | | - </listitem> |
68 | | - <listitem> |
69 | | - <para>If youhave compiled <productname>Postgres Pro</productname> |
70 | | - from source code or created your database in a non-default location, |
71 | | - you must always run the<literal>pgpro_upgrade</literal> script manually. |
72 | | - Before running the script, youshouldstop postgres service. |
73 | | - Script should be run on behalf of the user owning the database |
74 | | - (typically postgres) and PGDATA environment variable should be |
75 | | - set to the directory where database resides. |
76 | | - </para> |
77 | | - </listitem> |
78 | | - </itemizedlist> |
| 59 | +a dump/restore is not required. Instead ofthe <literal>pg_upgrade</literal>, |
| 60 | +you must use the <literal>pgpro_upgrade</literal> script provided |
| 61 | +in this distribution. This script updates metadata information to |
| 62 | +handle catalog number format change introduced in |
| 63 | +<productname>Postgres Pro</productname> 9.6.4.1.If you are upgrading your |
| 64 | +<productname>Postgres Pro</productname>installation from a binary package, the |
| 65 | +<literal>pgpro_upgrade</literal> scriptis run automatically, or you |
| 66 | +are prompted to run it manually. |
| 67 | +<important> |
| 68 | + <para> |
| 69 | + If yourun <literal>pgpro_upgrade</literal> manually, |
| 70 | +you must stop postgres service. |
| 71 | +The script must be run on behalf of theuser owning the database |
| 72 | +(typically postgres) and PGDATA environment variableshouldbe |
| 73 | +set to the directory where database resides. Running <literal>pgpro_upgrade</literal> |
| 74 | +as root will result in an error. |
| 75 | +If you have compiled <productname>Postgres Pro</productname> |
| 76 | +from source code or created your database in a non-default location, |
| 77 | +you must run the <literal>pgpro_upgrade</literal> script manually. |
| 78 | + </para> |
79 | 79 | <note> |
80 | 80 | <para>On RPM-based Linux distributions, if you are upgrading from |
81 | 81 | version 9.6.2.1 or lower, make sure to move the data directory from |
82 | 82 | <filename>pgsql</filename> to the <filename>pgpro</filename> |
83 | 83 | directory before running the <literal>pgpro_upgrade</literal> script. |
84 | | - Besides, after you upgrade to a newer version, you will have to use |
85 | | - the <literal>systemd</literal> service manager. |
86 | 84 | </para> |
87 | 85 | </note> |
88 | 86 | </para> |
|
