Date: Wed, 15 May 2019 12:14:21 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 237910] databases/postgresql11-server: incorrect warning about dump/restore Message-ID: <bug-237910-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D237910 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@FreeBSD.org Reporter: francesco@magno.cc Assignee: pgsql@FreeBSD.org Flags: maintainer-feedback?(pgsql@FreeBSD.org) While updating PostgreSQL server, pkg gives this warning: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D BACKUP YOUR DATA! =3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D 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! =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 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 versi= on 10.6. [...] To update between compatible versions, you simply replace the executables while the server is down and restart the server. The data direc= tory remains unchanged =E2=80=94 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 fir= st minor release of the major release 10. For releases before PostgreSQL versi= on 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 vers= ion number, e.g., 9.5, and the minor version is the third number, e.g., 3, mean= ing 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. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-237910-7788>