[Slackbuilds-users] PostgreSQL - multiple installed versions

[Benjamin Trigona-Harany]

On September 3, 2013 17:04:15 Adis Nezirovic wrote:
> Guys, I have a question for all PostgreSQL users and SBo admins.
> 
> Would it be OK for the next PostgreSQL package (upcoming 9.3) to be version
> specific and parallel-installable with  old PostgreSQL versions.
> (of course, we would continue that practice in the future).
> 
> Since PostgreSQL installations are not upgradeable in place, one needs to
> do export/import data cycle or use pg_upgrade utility, and having old and
> new database instance would be very handy for that.
> 
> The packages would be named postgresql93 (v9.3.x), postgresql94 (v9.4.x)
> (the current postgresql can be treated as postgresql92), and would use
> version specific data directories.

This is timely because a similar issue just came up with the 2.2 release of 
PostGIS, which also expects both the current 2.2 and the previous 2.1 versions 
installed to do an in-place upgrade of existing databases.

However, providing both postgis21 and postgis22 SlackBuilds would mean some 
headaches for packages depending on PostGIS since it wouldn't be evident which 
version of PostGIS it was built against without also versioning that build 
script.

Likewise, splitting PostgreSQL into version-dependent scripts is going to 
affect dependencies. Other distros have ended up with packages such as 
postgres91-postgis21-2.1.0, but I don't see that being maintainable, 
especially when we consider the further SlackBuilds that will depend on that 
package.

Ben
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.slackbuilds.org/pipermail/slackbuilds-users/attachments/20130903/0186b230/attachment.asc>