Re: How to determine to which version of PostgreSQL a patch was applied

On Wed, Jun 20, 2012 at 02:45:16PM -0300, Norberto Dellê wrote:
> Hi all
>
> I would like to determine to which version of PostgreSQL a certain patch
> was applied.
> I'm having trouble with a message flooding my log files and possibly
> affecting the server
> performance, and I found a patch that may shed some light over the problem:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=79b2ee20c8a041a85dd230c4e787bef22edae57b#patch1
>
> How do I find the version to which this patch was applied?

Simple. On the top of the page you can see "tree" link to this address:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;h=8f7336a210832e1d33c613ae24121d63e0a3c54a;hb=79b2ee20c8a041a85dd230c4e787bef22edae57b

in this tree, open "configure" file (blob, link:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=configure;h=ddc25d53ac1a52f3238ba96a7b58bb40a99f2264;hb=79b2ee20c8a041a85dd230c4e787bef22edae57b)
and check line # 601:
PACKAGE_VERSION='9.2devel'

this means that this particular patch was committed to 9.2version - i.e.
to upcomin 9.2 release.

Also - we can check in committers archive, in here:
http://archives.postgresql.org/pgsql-committers/2011-08/mail2.php
that this patch was applied *only* to 9.2devel.
To show difference - please note three mails from 13th of august, with
title "pgsql: Fix incorrect timeout handling during initial
authentication tra"
in their bodies we can see:
Branch: REL9_1_STABLE
Branch: REL9_0_STABLE
Branch: master (master being 9.2devel at the time).

Hope it helps.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/