|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/pgupgrade.sgml,v 1.9 2010/05/19 20:47:18 momjian Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/pgupgrade.sgml,v 1.10 2010/05/24 17:43:39 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <sect1 id="pgupgrade"> |
4 | 4 | <title>pg_upgrade</title> |
|
35 | 35 |
|
36 | 36 | <variablelist> |
37 | 37 |
|
38 | | - <varlistentry> |
39 | | - <term><option>-d</option> <replaceable>OLDDATADIR</></term> |
40 | | - <term><option>--old-datadir</option> <replaceable>OLDDATADIR</></term> |
41 | | - <listitem><para>specify the old cluster data directory</para></listitem> |
42 | | - </varlistentry> |
43 | | - |
44 | | - <varlistentry> |
45 | | - <term><option>-D</option> <replaceable>NEWDATADIR</></term> |
46 | | - <term><option>--new-datadir</option> <replaceable>NEWDATADIR</></term> |
47 | | - <listitem><para>specify the new cluster data directory</para></listitem> |
48 | | - </varlistentry> |
49 | | - |
50 | 38 | <varlistentry> |
51 | 39 | <term><option>-b</option> <replaceable>OLDBINDIR</></term> |
52 | 40 | <term><option>--old-bindir</option> <replaceable>OLDBINDIR</></term> |
|
60 | 48 | </varlistentry> |
61 | 49 |
|
62 | 50 | <varlistentry> |
63 | | - <term><option>-p</option> <replaceable>portnum</></term> |
64 | | - <term><option>--old-port</option> <replaceable>portnum</></term> |
65 | | - <listitem><para>specify the old cluster port number</para></listitem> |
66 | | - </varlistentry> |
67 | | - |
68 | | - <varlistentry> |
69 | | - <term><option>-P</option> <replaceable>portnum</></term> |
70 | | - <term><option>--new-port</option> <replaceable>portnum</></term> |
71 | | - <listitem><para>specify the new cluster port number</para></listitem> |
| 51 | + <term><option>-c</option></term> |
| 52 | + <term><option>--check</option></term> |
| 53 | + <listitem><para>check clusters only, don't change any data</para></listitem> |
72 | 54 | </varlistentry> |
73 | 55 |
|
74 | 56 | <varlistentry> |
75 | | - <term><option>-u</option> <replaceable>username</></term> |
76 | | - <term><option>--user</option> <replaceable>username</></term> |
77 | | - <listitem><para>clusters superuser</para></listitem> |
| 57 | + <term><option>-d</option> <replaceable>OLDDATADIR</></term> |
| 58 | + <term><option>--old-datadir</option> <replaceable>OLDDATADIR</></term> |
| 59 | + <listitem><para>specify the old cluster data directory</para></listitem> |
78 | 60 | </varlistentry> |
79 | 61 |
|
80 | 62 | <varlistentry> |
81 | | - <term><option>-c</option></term> |
82 | | - <term><option>--check</option></term> |
83 | | - <listitem><para>check clusters only, don't change anydata</para></listitem> |
| 63 | + <term><option>-D</option> <replaceable>NEWDATADIR</></term> |
| 64 | + <term><option>--new-datadir</option> <replaceable>NEWDATADIR</></term> |
| 65 | + <listitem><para>specify the new clusterdata directory</para></listitem> |
84 | 66 | </varlistentry> |
85 | 67 |
|
86 | 68 | <varlistentry> |
87 | | - <term><option>-d</option></term> |
| 69 | + <term><option>-g</option></term> |
88 | 70 | <term><option>--debug</option></term> |
89 | 71 | <listitem><para>enable debugging</para></listitem> |
90 | 72 | </varlistentry> |
|
107 | 89 | <listitem><para>log session activity to file</para></listitem> |
108 | 90 | </varlistentry> |
109 | 91 |
|
| 92 | + <varlistentry> |
| 93 | + <term><option>-p</option> <replaceable>portnum</></term> |
| 94 | + <term><option>--old-port</option> <replaceable>portnum</></term> |
| 95 | + <listitem><para>specify the old cluster port number</para></listitem> |
| 96 | + </varlistentry> |
| 97 | + |
| 98 | + <varlistentry> |
| 99 | + <term><option>-P</option> <replaceable>portnum</></term> |
| 100 | + <term><option>--new-port</option> <replaceable>portnum</></term> |
| 101 | + <listitem><para>specify the new cluster port number</para></listitem> |
| 102 | + </varlistentry> |
| 103 | + |
| 104 | + <varlistentry> |
| 105 | + <term><option>-u</option> <replaceable>username</></term> |
| 106 | + <term><option>--user</option> <replaceable>username</></term> |
| 107 | + <listitem><para>clusters superuser</para></listitem> |
| 108 | + </varlistentry> |
| 109 | + |
110 | 110 | <varlistentry> |
111 | 111 | <term><option>-v</option></term> |
112 | 112 | <term><option>--verbose</option></term> |
|
120 | 120 | </varlistentry> |
121 | 121 |
|
122 | 122 | <varlistentry> |
| 123 | + <term><option>-?</option></term> |
123 | 124 | <term><option>-h</option></term> |
124 | 125 | <term><option>--help</option></term> |
125 | 126 | <listitem><para>show help, then exit</para></listitem> |
@@ -441,6 +442,8 @@ psql --username postgres --file script.sql postgres |
441 | 442 |
|
442 | 443 |
|
443 | 444 | <para> |
| 445 | + Upgrading from PostgreSQL 8.3 has additional restrictions not present |
| 446 | + when upgrading from later PostgreSQL releases. For example, |
444 | 447 | pg_upgrade will not work for a migration from 8.3 if a user column |
445 | 448 | is defined as: |
446 | 449 | <itemizedlist> |
|