Re: Clarification to pg_upgrade docs on reverting to old cluster

"Jonathan S. Katz" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.documentation
Message-ID <[email protected]>
On 4/5/19 8:26 AM, Magnus Hagander wrote:
> 
> 
> On Thu, Apr 4, 2019 at 11:14 PM Daniel Gustafsson <[email protected]
> <mailto:[email protected]>> wrote:
> 
>     Reading the pg_upgrade reference page, I get the feeling that one of the
>     bullets under "Reverting to old cluster" is a bit thin on detail to
>     be helpful
>     to newcomers:
> 
>         "If you ran pg_upgrade with --link, 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."
> 
>     This is perfectly correct, but it fails to provide information on
>     what to do
>     next in case reverting is in fact what the user wants.  The attached
>     patch adds
>     a short sentence saying the old cluster should be restored from
>     backups at this
>     point.
> 
> 
> Let's have two non-english natives discuss it :), but wouldn't it sound
> better with "in this case" than "at this point"? And as a really small
> nitpick, restore from backup, rather than backups? 

I would go with:

"If you need to restore the old cluster, you will have to do so using
backups that you took prior to the upgrade."

Or if you want to be overly verbose:

"If you need to restore the old cluster, you will have to do so using
backups that you made prior to the upgrade as the --link does not create
a copy of the old cluster files."

Jonathan
signature.asc (application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlynYx8ACgkQ8QSccp8c
ZSeugQ/+Lxx1hXXe0y9INiYveBw1+M9GfspTI+BQauzNjRquRUY3oh/OnXfO5Uuj
BOSSBJHQplAA2TgVAu65bnyln61F3wTIyiqqII4q1IlAVJF+S1QcXQODKw5wfHpC
V968khmc5cwSH+5L9iL5YUlFVmKyh99BrSgwZotSMp/rYcQyBaGrFdMibr4kiuP2
DfaP8g+5Agw9Uuk4RC2R+VgTORpjhaDVXWVGXRBM7VHig2cqayzftvHczwyCzmZM
vcV/zURj4JpZKZZj3ghcsdcfUC+CMwvQFPWDEBt0ylC/mD5G2th8JmBsaJ4jpULC
ajtjDTZrOR2w7Ddt5FguGpYKDMpua71S1SLbvTA8SQKGeFoiJqds0RI8KA0m8Vky
QAskIxNSHUFGaLYWPb0xNiEgjN8M2WhFvlSSkA5MHaId1d93Z4RP+tKvb59XT28b
B1/pFw6/wmq1r/qdCaauioaT9Df6SoNWSzJrY+xe0HsWfIQ1E9yyrjmNyveAfuKT
Y++C8hevY46lXvDRxzSX/HvJPIS/KzJdUco4wvNhLcFfBBrX20hgvXSyLxlBXv4U
7ewbXQxOdU+Npyw4Zy9aGYAKoK01+mm8sgxv0QMLyestcCsY8cgXCr9ZJcNuvxdU
ki/2Qdiy+rk9kShhU3Fpcne1IhmybzaVJP05k6Ne61NEnJvnCy4=
=sdPH
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.