[Bug 722867] New: server:database:postgresql/postgresql: Bug Postgres doesn't allow multiple installations
https://bugzilla.novell.com/show_bug.cgi?id=722867 https://bugzilla.novell.com/show_bug.cgi?id=722867#c0 Summary: server:database:postgresql/postgresql: Bug Postgres doesn't allow multiple installations Classification: openSUSE Product: openSUSE.org Version: unspecified Platform: x86-64 OS/Version: Linux Status: NEW Severity: Major Priority: P5 - None Component: 3rd party software AssignedTo: max@suse.com ReportedBy: cgiboudeaux@gmx.com QAContact: opensuse-communityscreening@forge.provo.novell.com CC: coolo@suse.com, peter_e@gmx.net Found By: --- Blocker: --- Using Opensuse Factory but the bug is valid for all opensuse versions. The issue: Installing several Postgres version in Opensuse is currently not possible. Due to (frequent) internal database changes between all the major Postgres versions, the data have to be migrated quite often to be able to start the server. pg_upgrade is there to make the upgrade process quite easier (compared to a manual pg_dump+pg_restore operation). However, the old executable and the new one must be installed at the same time which is currently impossible as the executables are installed in /usr/bin and the package is simply called 'postgres' This is a critical issue eg for Akonadi users who chose the Postgres backend. As an example, the recent upgrade to 9.1.1 renders Postgres unusable due to incompatible : [quote] stdout: "waiting for server to start....2011-10-08 17:04:29 GMT FATAL: database files are incompatible with server 2011-10-08 17:04:29 GMT DETAIL: The data directory was initialized by PostgreSQL version 9.0, which is not compatible with this version 9.1.1. [/quote] -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=722867 https://bugzilla.novell.com/show_bug.cgi?id=722867#c1 --- Comment #1 from Christophe Giboudeaux <cgiboudeaux@gmx.com> 2011-10-08 17:10:18 UTC --- Forgot two words sorry: As an example, the recent upgrade to 9.1.1 renders Postgres unusable due to incompatible *changes upstream* [...] -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=722867 https://bugzilla.novell.com/show_bug.cgi?id=722867#c2 Bruno Friedmann <bruno@ioda-net.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bruno@ioda-net.ch --- Comment #2 from Bruno Friedmann <bruno@ioda-net.ch> 2011-10-09 07:45:01 UTC --- This is not new, and all rpm distributions have that kind of trouble. The debian way seems to be the right way. But actually with the introduction of systemd they need to renew it too. This is one example of cross-collaboration upstream/downstream and inter-distribution could give end-users a real plus. Should we start by opening a Fate ? Christophe, about an administrator who upgrade a version when it's clearly stated that if you don't backup/restore or use upgrade tools you will get trouble. a zypper al before against postgresql lock it's updgrade, allowing you to dump your db. I don't know how a package will be able to detect if yes or no, which user is using that postgres instance or not. About the akonadi things, akonadi is not bug free, like for example when I setup it to use my central database, it insist to start it's own instance ? That's not the case with the mysql driver. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=722867 https://bugzilla.novell.com/show_bug.cgi?id=722867#c3 Reinhard Max <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Version|unspecified |Factory Component|3rd party software |Update Problems AssignedTo|max@suse.com |bnc-team-screening@forge.pr | |ovo.novell.com Resolution| |FEATURE Product|openSUSE.org |openSUSE 12.1 QAContact|opensuse-communityscreening |jsrain@suse.com |@forge.provo.novell.com | Severity|Major |Enhancement --- Comment #3 from Reinhard Max <max@suse.com> 2011-10-10 09:25:25 CEST --- I've been pondering about this back and forth in the past and found no sane way to solve this if PostgreSQL comes as part of the OS distribution. If we do a distribution upgrade, we can't keep the old packages, since they might depend on old libs and so forth, so we might end up keeping half of the old installation. But shipping (and hence maintaining) multiple versions of PostgreSQL with every SUSE release also is no option. But this clearly is no bug, but a feature request, so please open a Fate entry for it. BTW, the openSUSE.org bugzilla "product" is about the openSUSE project infrastructure, not about the distribution. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com