1
- <!-- $PostgreSQL: pgsql/doc/src/sgml/pgupgrade.sgml,v 1.4 2010/05/13 22:51:00 momjian Exp $ -->
1
+ <!-- $PostgreSQL: pgsql/doc/src/sgml/pgupgrade.sgml,v 1.5 2010/05/18 15:41:36 mha Exp $ -->
2
2
3
3
<sect1 id="pgupgrade">
4
4
<title>pg_upgrade</title>
@@ -154,7 +154,7 @@ gmake prefix=/usr/local/pgsql.new install
154
154
155
155
<programlisting>
156
156
pg_ctl --pgdata /opt/PostgreSQL/8.4 stop
157
- pg_ctl --pgdata /opt/PostgreSQL/8.5 stop
157
+ pg_ctl --pgdata /opt/PostgreSQL/9.0 stop
158
158
</programlisting>
159
159
160
160
or on Windows
@@ -175,7 +175,9 @@ NET STOP pgsql-8.3 (different service name)
175
175
<listitem>
176
176
<para>
177
177
Run pg_upgrade
178
+ </para>
178
179
180
+ <para>
179
181
Always run the pg_upgrade binary in the new server, not the old one.
180
182
pg_upgrade requires the specification of the old and new cluster's
181
183
PGDATA and executable (/bin) directories. You can also specify separate
@@ -192,17 +194,17 @@ NET STOP pgsql-8.3 (different service name)
192
194
193
195
<programlisting>
194
196
RUNAS /USER:postgres "CMD.EXE"
195
- SET PATH=%PATH%;C:\Program Files\PostgreSQL\8.5 \bin;
197
+ SET PATH=%PATH%;C:\Program Files\PostgreSQL\9.0 \bin;
196
198
</programlisting>
197
199
198
200
and then run pg_upgrade with quoted directories, e.g.:
199
201
200
202
<programlisting>
201
203
pg_upgrade.exe
202
204
--old-datadir "C:/Program Files/PostgreSQL/8.4/data"
203
- --new-datadir "C:/Program Files/PostgreSQL/8.5 /data"
205
+ --new-datadir "C:/Program Files/PostgreSQL/9.0 /data"
204
206
--old-bindir "C:/Program Files/PostgreSQL/8.4/bin"
205
- --new-bindir "C:/Program Files/PostgreSQL/8.5 /bin"
207
+ --new-bindir "C:/Program Files/PostgreSQL/9.0 /bin"
206
208
</programlisting>
207
209
208
210
Once started, pg_upgrade will verify the two clusters are compatible
0 commit comments