@@ -19,10 +19,10 @@ version must be used.
19
19
1) Back up your existing data directory, preferably by making a complete
20
20
dump with pg_dumpall.
21
21
.LP
22
- 2) Copy the programpgsql /contrib/pg_upgrade/pg_upgrade from the current
23
- PostgreSQL distributioninto somewherein your path.
22
+ 2) Copy the program\fI pgsql /contrib/pg_upgrade/pg_upgrade\fP from the current
23
+ PostgreSQL distribution somewhereinto your path.
24
24
.LP
25
- 3) Change your working directory to the pgsql main directory, and type:
25
+ 3) Change your working directory to the pgsql main directory, and type:
26
26
.LP
27
27
.B $ pg_upgrade -1
28
28
.sp
@@ -40,18 +40,18 @@ to install the new binaries.
40
40
.br
41
41
.B $ make install
42
42
.sp
43
- to install thepg_resetxlog utility which is needed by
43
+ to install the\fI pg_resetxlog \fP utility which is needed by
44
44
pg_upgrade.
45
45
.LP
46
46
6) Run initdb to create a new template1 database containing the system
47
47
tables for the new release. Make sure you use settings similar to those
48
48
used in your previous version.
49
49
.LP
50
- 7) Start the newpostmaster. (Note: it is critical that no users connect
50
+ 7) Start the new\fI postmaster. \fP (Note: it is critical that no users connect
51
51
to the server until the upgrade is complete. You may wish to start the
52
- postmaster without -iand/ or alter pg_hba.conf temporarily.)
52
+ postmaster without -i or alter pg_hba.conf temporarily.)
53
53
.LP
54
- 8) Change your working directory to the pgsql main directory, and type:
54
+ 8) Change your working directory to the pgsql main directory, and type:
55
55
.LP
56
56
.B $ pg_upgrade -2
57
57
.sp
@@ -61,15 +61,15 @@ but with no data. It will then physically move the data files
61
61
containing non-system tables and indexes into the proper
62
62
subdirectories.
63
63
.LP
64
- 9) Restore your oldpg_hba .conf if needed to allow user logins.
64
+ 9) Restore your old\fI pg_hba .conf\fP if needed to allow user logins.
65
65
.sp
66
66
.LP
67
67
10) Carefully examine the contents of the upgraded databases. If you
68
68
detect problems, you'll need to recover by restoring from your full
69
- pg_dump backup. You can delete thepg_upgrade_info/ directory when you
69
+ pg_dump backup. You can delete the\fI pg_upgrade_info/ \fP directory when you
70
70
are satisfied.
71
71
.LP
72
72
The upgraded databases will be in an un-vacuumed state. You will
73
- probably want to run aVACUUM ANALYZE before beginning production work.
73
+ probably want to run a\fI VACUUM ANALYZE \fB before beginning production work.
74
74
.SH SEE ALSO
75
75
initdb(1), postmaster(1), pg_dump(1), pg_dumpall(1), vacuumdb(1)