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.