Upgrade Process

Unlike my previous upgrade from the 7.4.x series to the 8.1.x series, I
now have all data in /var/lib/pgsql/data. Currently running 8.1.4 on my
Slackware system and want to upgrade to 8.2.4, so I'm checking my procedure
before inadvertently creating major problems for myself.

What I believe should work -- and I'd like conformation or corrections,
please -- is the following:

1) Run 'pg_dumpall > pg8.1.4.sql' as user postgres.
2) Stop the running postmaster as root.
3) Upgrade the Slackware package to 8.2.4 as root.
4) Restart the postmaster as root.
5) Run 'psql -f pg8.1.4.sql postgres' as user postgres.

Have I missed a critical step? The upgrade will replace the existing files
with the new ones in the same directories.

TIA,

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863