The frontpage at http://pypgsql.sourceforge.net/
"pyPgSQL is available as a Redhat RPM as part of the KRUD distribution that builds on Redhat. These RPMs are now also available for downloading at the project page."
However KRUD was discontinued in 2006.
http://www.tummy.com/Products/krud/ (dated 2005)
A good hint on usual RPM source to use would still be quite helpful.