From 21eee213f0a169c4122549bd729d600edab4dac9 Mon Sep 17 00:00:00 2001 From: Daniel Gustafsson Date: Thu, 4 Apr 2019 21:21:48 +0200 Subject: [PATCH] docs: extend the pg_upgrade docs for cluster revert Clarify in which situations the old cluster can be safely restarted and when it cannot and need to be restored from backup. --- doc/src/sgml/ref/pgupgrade.sgml | 47 +++++++++++++++++++++++++++++------------ 1 file changed, 34 insertions(+), 13 deletions(-) diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml index c896882dd1..598e86152c 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -686,24 +686,45 @@ psql --username=postgres --file=script.sql postgres - If you ran pg_upgrade - with , the data files are shared between the - old and new cluster. If you started the new cluster, the new - server has written to those shared files and it is unsafe to - use the old cluster. + If you ran pg_upgrade without + , the old cluster was not modified and you can + re-use it anytime. - If you ran pg_upgrade without - or did not start the new server, the - old cluster was not modified except that, if linking - started, a .old suffix was appended to - $PGDATA/global/pg_control. To reuse the old - cluster, possibly remove the .old suffix from - $PGDATA/global/pg_control; you can then restart the - old cluster. + If you ran pg_upgrade with , + the data files are shared between the old and new cluster. + + + + + If you started the new cluster, the new server has written to those + shared files and it is unsafe to use the old cluster. The old + cluster will need to be restored from backup in this case. + + + + + + If you did not start the new server, the old + cluster was not modified except that, when linking started, a + .old suffix was appended to + $PGDATA/global/pg_control. To reuse the old + cluster, remove the .old suffix from + $PGDATA/global/pg_control; you can then restart + the old cluster. + + + + + + If pg_upgrade was aborted before linking started, + then the old cluster was not modified and can be restarted. + + + -- 2.14.1.145.gb3622a4ee