diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-01-11 06:48:41 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-01-11 06:48:41 +0000 |
| commit | 4e37786f2faa903ca6f9b6f791f9bc5667b54e1f (patch) | |
| tree | e1c62f0191fbfdf4e91b3b23a62c9a353183d432 /src | |
| parent | 37c9346ef2af5e7a7d5e3fe25b4d6da3463edc69 (diff) | |
| download | postgresql-4e37786f2faa903ca6f9b6f791f9bc5667b54e1f.tar.gz postgresql-4e37786f2faa903ca6f9b6f791f9bc5667b54e1f.zip | |
More testing, more cleanups.
Diffstat (limited to 'src')
| -rwxr-xr-x | src/bin/pg_dump/pg_upgrade | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/bin/pg_dump/pg_upgrade b/src/bin/pg_dump/pg_upgrade index e893dbfc92f..6cf9dbba5e2 100755 --- a/src/bin/pg_dump/pg_upgrade +++ b/src/bin/pg_dump/pg_upgrade @@ -5,7 +5,7 @@ #set -x -# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_upgrade,v 1.27 2002/01/11 06:33:01 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_upgrade,v 1.28 2002/01/11 06:48:41 momjian Exp $ # # NOTE: we must be sure to update the version-checking code a few dozen lines # below for each new PostgreSQL release. @@ -158,7 +158,7 @@ fi # we are done with SQL database access # shutdown forces buffers to disk -pg_ctl stop +pg_ctl -w stop if [ "$?" -ne 0 ] then echo "Unable to stop database server.; exiting" 1>&2 exit 1 @@ -271,7 +271,7 @@ fi # Restart server with moved data -pg_ctl start +pg_ctl -w start if [ "$?" -ne 0 ] then echo "Unable to restart database server.; exiting" 1>&2 exit 1 @@ -283,11 +283,14 @@ if [ "$SRC_VERSION" = "7.1" ] then echo "Set int8 sequence values from 7.1..." psql -d template1 -At -c "SELECT datname FROM pg_database" | + grep -v '^template0$' | # no system databases + grep -v '^template1$' | # no system databases while read DB do echo "$DB" # XXX is concurrency a problem here? psql -d "$DB" -At -c "SELECT relname FROM pg_class where relkind = 'S';" | + grep -v '^pg_' | # no system tables while read SEQUENCE do psql -d "$DB" -At <<SQL_END |