postgres.git / summary / log / commit / refs
commit 38f3c7c4ddedf509d8e2bdda4a947df4dc177e5a
Author: Bruce Momjian <bruce@momjian.us>
Date: Fri Oct 28 01:29:03 2011 +0000
First released in: 9.2.0
Update pg_upgrade testing instructions.
contrib/pg_upgrade/TESTING | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)
diff --git a/contrib/pg_upgrade/TESTING b/contrib/pg_upgrade/TESTING
index 85de8da7f7e..f685c938c5f 100644
--- a/contrib/pg_upgrade/TESTING
+++ b/contrib/pg_upgrade/TESTING
@@ -13,26 +13,26 @@ Here are the steps needed to create a regression database dump file:
This database can be created by running 'gmake installcheck' from
src/test/regression.
-2) Use pg_dump to dump out the regression database
- Use the new cluster's pg_dump on the old database to minimize
- whitespace differences in the diff.
+2) Use pg_dump to dump out the regression database. Use the new
+ cluster's pg_dump on the old database to minimize whitespace
+ differences in the diff.
3) Adjust the regression database dump file
- a) Change CREATE FUNCTION shared object paths to use '$libdir'
- The old and new cluster will have different shared object paths.
-
- d) Perform the load/dump twice
+ a) Perform the load/dump twice
This fixes problems with the ordering of COPY columns for
inherited tables.
- e) Fix any wrapping format differences
+ b) Change CREATE FUNCTION shared object paths to use '$libdir'
+ The old and new cluster will have different shared object paths.
+
+ c) Fix any wrapping format differences
Commands like CREATE TRIGGER and ALTER TABLE sometimes have
differences.
- c) For pre-9.0, change CREATE OR REPLACE LANGUAGE to CREATE LANGUAGE
+ d) For pre-9.0, change CREATE OR REPLACE LANGUAGE to CREATE LANGUAGE
- b) For pre-9.0, remove 'regex_flavor'
+ e) For pre-9.0, remove 'regex_flavor'
f) For pre-9.0, adjust extra_float_digits
Postgres 9.0 pg_dump uses extra_float_digits=-2 for pre-9.0
[parent: cbf65509bb59]