BUG #1970: Existing /etc/pam.d/postgresql clobbered by RPM install

The following bug has been logged online:

Bug reference:      1970
Logged by:          Mark Gibson
Email address:      gibsonm@cromwell.co.uk
PostgreSQL version: 8.0.4
Operating system:   Redhat Enterprise Linux 4
Description:        Existing /etc/pam.d/postgresql clobbered by RPM install
Details:

Hello, I noticed that when installing the 8.0.4 RPM's
it replaced our existing /etc/pam.d/postgresql - this caused our system to
break temporarily, as it was missing the following line:

account  required  pam_stack.so service=system-auth

I don't know whether this is required for all systems or is just a
peculiarity of our setup, but could the RPM be changed to not clobber this
file in the future. I believe some RPM's install conflicting configs with
the .rpmnew extension. Cheers.