Re: [DOCS] 14.4 If You Are Upgrading - Suggested Improvements

[Alvaro Herrera]

Bruce Momjian wrote:

> Updated text:
> 
>The internal data storage format typically changes in every major
>release of PostgreSQL. Therefore, if you are upgrading
>an existing installation that does not have a version number of
>&majorversion;.x, you must back up and restore your
>data.  If you are upgrading from the same major version, the new version
>can use your current data files so you should skip the backup and
>restore steps below because they are unnecessary.

That's better, but I'd suggest using &majorversion;.x in the last
sentence as well, instead of "the same major version", because some
people does not yet grasp that we refer to "major" as the first two
digits, instead thinking that all "7" versions are compatible, and all
"8", etc.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [DOCS] 14.4 If You Are Upgrading - Suggested Improvements

[Bruce Momjian]

Done, patch attached.

---

Alvaro Herrera wrote:
> Bruce Momjian wrote:
> 
> > Updated text:
> > 
> >The internal data storage format typically changes in every major
> >release of PostgreSQL. Therefore, if you are upgrading
> >an existing installation that does not have a version number of
> >&majorversion;.x, you must back up and restore your
> >data.  If you are upgrading from the same major version, the new version
> >can use your current data files so you should skip the backup and
> >restore steps below because they are unnecessary.
> 
> That's better, but I'd suggest using &majorversion;.x in the last
> sentence as well, instead of "the same major version", because some
> people does not yet grasp that we refer to "major" as the first two
> digits, instead thinking that all "7" versions are compatible, and all
> "8", etc.
> 
> -- 
> Alvaro Herrerahttp://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/installation.sgml
===
RCS file: /cvsroot/pgsql/doc/src/sgml/installation.sgml,v
retrieving revision 1.277
diff -c -c -r1.277 installation.sgml
*** doc/src/sgml/installation.sgml	27 Jan 2007 01:27:36 -	1.277
--- doc/src/sgml/installation.sgml	29 Jan 2007 21:48:05 -
***
*** 385,393 
 release of PostgreSQL. Therefore, if you are upgrading
 an existing installation that does not have a version number of
 &majorversion;.x, you must back up and restore your
!data.  If you are upgrading from the same major version, the new version
!can use your current data files so you should skip the backup and
!restore steps below because they are unnecessary.

  

--- 385,394 
 release of PostgreSQL. Therefore, if you are upgrading
 an existing installation that does not have a version number of
 &majorversion;.x, you must back up and restore your
!data.  If you are upgrading from PostgreSQL
!&majorversion;.x, the new version can use your current
!data files so you should skip the backup and restore steps below because
!they are unnecessary.

  


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org