|
38 | 38 | <application>pg_upgrade</> (formerly called <application>pg_migrator</>) allows data
|
39 | 39 | stored in <productname>PostgreSQL</> data files to be upgraded to a later <productname>PostgreSQL</>
|
40 | 40 | major version without the data dump/reload typically required for
|
41 |
| - major version upgrades, e.g. from 8.4.7 to the current major release |
| 41 | + major version upgrades, e.g. from 9.6.3 to the current major release |
42 | 42 | of <productname>PostgreSQL</>. It is not required for minor version upgrades, e.g. from
|
43 |
| - 9.0.1 to 9.0.4. |
| 43 | + 9.6.2 to 9.6.3. |
44 | 44 | </para>
|
45 | 45 |
|
46 | 46 | <para>
|
|
66 | 66 |
|
67 | 67 | <para>
|
68 | 68 | pg_upgrade supports upgrades from 8.4.X and later to the current
|
69 |
| - major release of <productname>PostgreSQL</>, including snapshot and alpha releases. |
| 69 | + major release of <productname>PostgreSQL</>, including snapshot and beta releases. |
70 | 70 | </para>
|
71 | 71 | </refsect1>
|
72 | 72 |
|
|
207 | 207 |
|
208 | 208 | <para>
|
209 | 209 | If you are using a version-specific installation directory, e.g.
|
210 |
| - <filename>/opt/PostgreSQL/9.1</>, you do not need to move the old cluster. The |
| 210 | + <filename>/opt/PostgreSQL/&majorversion;</>, you do not need to move the old cluster. The |
211 | 211 | graphical installers all use version-specific installation directories.
|
212 | 212 | </para>
|
213 | 213 |
|
@@ -298,15 +298,15 @@ make prefix=/usr/local/pgsql.new install
|
298 | 298 | Make sure both database servers are stopped using, on Unix, e.g.:
|
299 | 299 |
|
300 | 300 | <programlisting>
|
301 |
| -pg_ctl -D /opt/PostgreSQL/8.4 stop |
302 |
| -pg_ctl -D /opt/PostgreSQL/9.0 stop |
| 301 | +pg_ctl -D /opt/PostgreSQL/9.6 stop |
| 302 | +pg_ctl -D /opt/PostgreSQL/&majorversion; stop |
303 | 303 | </programlisting>
|
304 | 304 |
|
305 | 305 | or on Windows, using the proper service names:
|
306 | 306 |
|
307 | 307 | <programlisting>
|
308 |
| -NET STOP postgresql-8.4 |
309 |
| -NET STOP postgresql-9.0 |
| 308 | +NET STOP postgresql-9.6 |
| 309 | +NET STOP postgresql-&majorversion; |
310 | 310 | </programlisting>
|
311 | 311 | </para>
|
312 | 312 |
|
@@ -366,17 +366,17 @@ NET STOP postgresql-9.0
|
366 | 366 |
|
367 | 367 | <programlisting>
|
368 | 368 | RUNAS /USER:postgres "CMD.EXE"
|
369 |
| -SET PATH=%PATH%;C:\Program Files\PostgreSQL\9.0\bin; |
| 369 | +SET PATH=%PATH%;C:\Program Files\PostgreSQL\&majorversion;\bin; |
370 | 370 | </programlisting>
|
371 | 371 |
|
372 | 372 | and then run <application>pg_upgrade</> with quoted directories, e.g.:
|
373 | 373 |
|
374 | 374 | <programlisting>
|
375 | 375 | pg_upgrade.exe
|
376 |
| - --old-datadir "C:/Program Files/PostgreSQL/8.4/data" |
377 |
| - --new-datadir "C:/Program Files/PostgreSQL/9.0/data" |
378 |
| - --old-bindir "C:/Program Files/PostgreSQL/8.4/bin" |
379 |
| - --new-bindir "C:/Program Files/PostgreSQL/9.0/bin" |
| 376 | + --old-datadir "C:/Program Files/PostgreSQL/9.6/data" |
| 377 | + --new-datadir "C:/Program Files/PostgreSQL/&majorversion;/data" |
| 378 | + --old-bindir "C:/Program Files/PostgreSQL/9.6/bin" |
| 379 | + --new-bindir "C:/Program Files/PostgreSQL/&majorversion;/bin" |
380 | 380 | </programlisting>
|
381 | 381 |
|
382 | 382 | Once started, <command>pg_upgrade</> will verify the two clusters are compatible
|
|
0 commit comments