|
3 | 3 | # pg_upgrade: update a database without needing a full dump/reload cycle. |
4 | 4 | # CAUTION: Read the manual page before trying to use this! |
5 | 5 |
|
6 | | -# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_upgrade,v 1.33 2002/01/1305:36:42 momjian Exp $ |
| 6 | +# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_upgrade,v 1.34 2002/01/1317:52:00 momjian Exp $ |
7 | 7 | # |
8 | 8 | # NOTE: we must be sure to update the version-checking code a few dozen lines |
9 | 9 | # below for each new PostgreSQL release. |
@@ -70,8 +70,10 @@ make_dbobjoidmap() |
70 | 70 | WHERE relkind ='r' OR |
71 | 71 | relkind ='i' OR |
72 | 72 | relkind ='t'\"`" |
73 | | -# Don't move over 7.1 sequences; use setval() file |
74 | | -if ["$SRC_VERSION"!="7.1" ] |
| 73 | +# Don't move over 7.1 int4 sequences; use setval() file. |
| 74 | +# Sequence XIDs changed from 7.2beta4 to beta5; don't copy them. |
| 75 | +if ["$SRC_VERSION"!="7.1"-a \ |
| 76 | +"$SRC_VERSION"!="7.2" ] |
75 | 77 | thenQUERY="$QUERY OR relkind = 'S';"; |
76 | 78 | QUERY="$QUERY;" |
77 | 79 | fi |
@@ -213,8 +215,9 @@ $0 aborted." 1>&2 |
213 | 215 | make_dbobjoidmap>"$INFODIR"/dbobjoidmap |
214 | 216 |
|
215 | 217 | # Generate setval() script for 7.1 because it has int4 sequences |
216 | | - |
217 | | -if ["$SRC_VERSION"="7.1" ] |
| 218 | +# Sequence XIDs changed from 7.2beta4 to beta5; we have to recreate them. |
| 219 | +if ["$SRC_VERSION"="7.1"-o \ |
| 220 | +"$SRC_VERSION"="7.2" ] |
218 | 221 | then |
219 | 222 | psql -d template1 -At -c"SELECT datname FROM pg_database"| |
220 | 223 | grep -v'^template0$'| |
|
511 | 514 |
|
512 | 515 | # Set sequence values for 7.1-version sequences, which were int4. |
513 | 516 |
|
514 | | -if ["$SRC_VERSION"="7.1" ] |
515 | | -thenecho"Set int8 sequence values from 7.1..." |
| 517 | +if ["$SRC_VERSION"="7.1"-o \ |
| 518 | +"$SRC_VERSION"="7.2" ] |
| 519 | +thenecho"Set sequence values..." |
516 | 520 | psql -d template1 -At<"$INFODIR"/setval |
517 | 521 | if [$?-ne 0 ] |
518 | 522 | thenecho"There were errors during int4 sequence restore. |
|