[Bug 237910] databases/postgresql11-server: incorrect warning about dump/restore

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=237910

            Bug ID: 237910
           Summary: databases/postgresql11-server: incorrect warning about
                    dump/restore
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: pgsql at FreeBSD.org
          Reporter: francesco at magno.cc
          Assignee: pgsql at FreeBSD.org
             Flags: maintainer-feedback?(pgsql at FreeBSD.org)

While updating PostgreSQL server, pkg gives this warning:

  =========== BACKUP YOUR DATA! =============
  As always, backup your data before
  upgrading. If the upgrade leads to a higher
  minor revision (e.g. 8.3.x -> 8.4), a dump
  and restore of all databases is
  required. This is *NOT* done by the port!
  ===========================================

The official PostgreSQL documentation says the opposite, actually.

"Minor releases never change the internal storage format and are always
compatible with earlier and later minor releases of the same major version
number. For example, version 10.1 is compatible with version 10.0 and version
10.6. [...] To update between compatible versions, you simply replace the
executables while the server is down and restart the server. The data directory
remains unchanged — minor upgrades are that simple."
(cfr. https://www.postgresql.org/docs/11/upgrading.html)

>From the same page:
"Current PostgreSQL version numbers consist of a major and a minor version
number. For example, in the version number 10.1, the 10 is the major version
number and the 1 is the minor version number, meaning this would be the first
minor release of the major release 10. For releases before PostgreSQL version
10.0, version numbers consist of three numbers, for example, 9.5.3. In those
cases, the major version consists of the first two digit groups of the version
number, e.g., 9.5, and the minor version is the third number, e.g., 3, meaning
this would be the third minor release of the major release 9.5."

A backup advice is always a good idea, but the provided information may not be
completely correct anymore, since version 10.0.

-- 
You are receiving this mail because:
You are the assignee for the bug.