[request-tracker-maintainers] Bug#596926: Bug#596926: [request-tracker3.8] Upgrading from rt 3.6 to rt 3.8 with Postgresql backend doesn't work

[Dominic Hargreaves]

On Wed, Sep 15, 2010 at 07:31:15AM +0200, Ingo Juergensmann wrote:
> Currently it is not possible to upgrade from rt 3.6 (Lenny) to rt 3.8  
> (Squeeze) when using PostgreSQL 8.3 as a backend.
> Reason:
> rt3.8-db-postgresql depends on meta-package postgresql-client, which  
> depends on postgresql-client-8.4. Currently the upgrade path from  
> PostgreSQL 8.3 to 8.4 is broken, see  
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=596678
>
> So, to being able to upgrade I needed to edit debian/control. Instead of
>
>     Depends: ${misc:Depends}, libdbd-pg-perl (>= 1.41),
>      postgresql-client (>= 7.4)
>     Suggests: postgresql | postgresql (>= 7.4)
>
> I changed the lines to this:
>
>     Depends: ${misc:Depends}, libdbd-pg-perl (>= 1.41),
>      postgresql-client-8.3 (>= 7.4)
>     Suggests: postgresql-8.3 | postgresql (>= 7.4)
>
> Maybe the lines should include both postgresql-client and  
> postgresql-client-8.3 to ensure an upgrade path to rt 3.8 without  
> needing to upgrade from PostgreSQL 8.3 to 8.4 either?

It's not clear to me what the correct thing to do is. The package
*did* have references to 8.3 until August, when I removed them to
fix some piuparts warnings, since 8.3 is not in sid/squeeze.

Since it appear that pragmatic fix is indeed to put the 8.3 dep back,
I will do that for an upcoming upload. However I would also like to
lower the severity of this bug, because it's not actually a but in
the RT package at all, just something that needs a workaround, as I
understand it.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)