grep -v'^template0$'|

whileread DB

QUERY="`echo\"SELECT relname, oid

QUERY="SELECT relname, oid

if ["$SRC_VERSION"!="7.1"-a \

.LP

\fBpg_upgrade\fP must be run in two stages. In phase one you must run

\fBpg_upgrade\fP with your old database installation in place. In phase two,

\fBpg_upgrade\fP must be run on a freshly\fBinitdb\fP'edcurrent install.

In both phases, the same\fBpg_upgrade\fP scriptmatching the newly installed

version must beused.

\fBpg_upgrade\fP must be run on a freshly\fBinitdb\fP'edserver.

In both phases, the samenewly installed\fBpg_upgrade\fP scriptmust be

used.

.LP

1) Back up your existing data directory, preferably by making a complete

dump with\fBpg_dumpall.\fP

1) Back up your existing data directory, preferably using\fBpg_dumpall.\fP

.LP

2) Copy the program\fIpgsql/contrib/pg_upgrade/pg_upgrade\fP from the current

PostgreSQL distribution somewhere into your path.

.LP

3)Change your working directory to the pgsql main directory, and type:

3)Run phase one of\fBpg_upgrade:\fP

.LP

.B$pg_upgrade-1

.sp

to collect information about the old database needed for the upgrade.

You may use\fI-D\fP to specify the data directory, or use PGDATA.

You may use\fI-D\fP to specify the data directory. By default it uses

the environment variable\fIPGDATA.\fP

.LP

4) Do:

.LP

.B$cdpgsql/src

.br

.B$makeinstall

.sp

to install thenew binaries.

to install thePostgreSQL binaries for the new release.

.LP

5) Do:

.LP

.B$cdpgsql/contrib/pg_resetxlog

.br

.B$makeinstall

.sp

to install the\fIpg_resetxlog\fP utility which is neededby

\fBpg_upgrade\fP.

to install the\fIpg_resetxlog\fP utility, which is neededduring phase

2 of\fBpg_upgrade\fP.

.LP

6) Run initdb to create a new template1 database containing the system

tables for the new release. Make sure you use settings similar to those

to the server until the upgrade is complete. You may wish to start the

postmaster without -i or alter pg_hba.conf temporarily.)

.LP

8)Change your working directory to the pgsql main directory again, and type:

8)Run phase two of\fBpg_upgrade:\fP

.LP

.B$pg_upgrade-2

.sp

The program will do some checking to make sure everything is properly

configured, and will then recreate allthe databases and tables you had,

configured, and will then recreate allyour databases and tables,

but with no data. It will then physically move the data files

containing non-system tables and indexes into the proper

subdirectories.

.LP

9) Restore your old\fIpg_hba.conf\fP if needed to allow user logins.

9) Restore your old\fIpostmaster\fP flags or\fIpg_hba.conf\fP if

needed to allow user logins.

.sp

.LP

10) Carefully examine the contents of the upgraded databases. If you